Database choice

[dymatrix]

Hello.

I am getting started with PHP 4/5. I am coming from a Delphi background. I find PHP straightforward so far. The books I have are guiding me via MySQL, but my client is running MSSQL. I will be developing a few learning apps along the way. I was asked if MYSQL is stable enought to run a million dollar business on. The app will be the center of an ASP hosted system. Client likes MS SQL but realizes that the bigger he gets the more $$ Microsoft gets. Once I get the basics of PHP and MYSQL down I plan on looking at PostgreSQL and Firebird with PHP. I use Firebird with all my Delphi apps and love it, but I here the PG has solid features including good replication.

I am interested in any opinions, links and/or comments on picking the right database.

The finall app to be buillt will support 100 to 2,000 simultaneous users and be scalled across multiple web servers with one database server, though client may partition DB to support different users i.e. East Coast on one set of servers, West coast on second set of servers or perhaps use replication to support reporting and lookups on on server and main input/updates on secondary server (will require real-time replication services).

My first app will be a simple app for a package courier , a demo app just to learn and get the hang of session management, user security etc.... as well as proper coding style to allow the "WEb Designer" to make it look pretty. I have come across SMarty template processor and hope to have time to include that in my rewrite of the "Courrier" system. Once I get started, I will post link to my code in case there are others in the same situation as me... learning by doing.

Thanks for reading my ramblings.

- Lou

[slyzius]

Hi, I am from Scimore UAB. We can recommend ScimoreDB. It can scale out and it is free. Here is a link to benchmark: http://www.scimore.com/technology/tpc.aspx

If you have questions, please contact me on:

skype: slyzius
msn: [e-mail]

Hello.

I am getting started with PHP 4/5. I am coming from a Delphi background. I find PHP straightforward so far. The books I have are guiding me via MySQL, but my client is running MSSQL. I will be developing a few learning apps along the way. I was asked if MYSQL is stable enought to run a million dollar business on. The app will be the center of an ASP hosted system. Client likes MS SQL but realizes that the bigger he gets the more $$ Microsoft gets. Once I get the basics of PHP and MYSQL down I plan on looking at PostgreSQL and Firebird with PHP. I use Firebird with all my Delphi apps and love it, but I here the PG has solid features including good replication.

I am interested in any opinions, links and/or comments on picking the right database.

The finall app to be buillt will support 100 to 2,000 simultaneous users and be scalled across multiple web servers with one database server, though client may partition DB to support different users i.e. East Coast on one set of servers, West coast on second set of servers or perhaps use replication to support reporting and lookups on on server and main input/updates on secondary server (will require real-time replication services).

My first app will be a simple app for a package courier , a demo app just to learn and get the hang of session management, user security etc.... as well as proper coding style to allow the "WEb Designer" to make it look pretty. I have come across SMarty template processor and hope to have time to include that in my rewrite of the "Courrier" system. Once I get started, I will post link to my code in case there are others in the same situation as me... learning by doing.

Thanks for reading my ramblings.

- Lou

[bartonc]

This page may give a pretty good idea of MySQL's stability. See how companies around the world have improved database Reliability, Performance and TCO using MySQL.