Mac OS X (Client) Database Software

[DjmUK]

Hi ya'all,

As I'm turning to Mac's, what is the best form of databases for ASP programming..?

I know that I can get an ASP module for Apache, or somehow convert ASP to PHP. But I'm looking for something like Microsoft SQL Server. You see with MS Access, it could only handle 10 similtaneous connections, where MS SQL Server can handle 100's. Is there an equivalent that Mac OS X can use that handle 100's of similtaneous connections..?

Any recommendations would be very grateful.

P.S.

I've heard of MySQL, is that any good?

P.S.2

Links to the homepages of the databases would be nice too :)

Thanks in advance :p

[epec254]

I use mysql locally here. It work great with PHP (not sure about ASP, never tested it cause I don't use ASP). The hompage is http://www.mysql.com

I used the mac os x build from here - www.entropy.ch/software/macosx/mysql.

[Tim Dorr Veteran]

MySQL is a good choice, assuming you're not running enterprise-level applications off your mac ;) It's fast and full-featured.

[DjmUK]

So I'm guessing that MySQL is the equivalent to MS Access..?

And there isn't a powerful Mac OS X database software that can handle 100's of similtaneous connections via ASP/PHP scripting just like SQL Server..?

Thanks in advance ya'all.

[Tim Dorr Veteran]

Well, this site (and most of the internet) runs on MySQL. It's not Access, I'll tell you that. It can handle safely up to about 2000 connections (maybe more with tuning). What I meant by enterprise is like 10k connections or whatnot :D

[DjmUK]

10K connections, I see what you mean - I can safely say I won't need that many connections ;)

I'll have to have a good look into MySQL, 2000 connections sounds very nice indeed - more than enough.

All I have to do now is figure out how to use the MySQL database and convert my ASP Access site into MySQL (PHP). I'm glad Dreamweaver MX can handle PHP scripts ;)

And if there's any info on how to use PHP, MySQL database, scripts connections then that'll be great. I can do it all in ASP but PHP is all new to me.

Thanks again.

[Tim Dorr Veteran]

Well, I assume you were using SQL to do all your db interaction. In that case, MySQL should pretty much accept anything you threw at Access/MsSQL. There are exceptions, but it's 99% the same.

As for ASP to PHP, there is a tool I've heard of, but it sucks and it's best to learn by hand anyways. Look in the web programming forum for some threads started on the subject :)