By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,160 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,160 IT Pros & Developers. It's quick & easy.

Database choice

P: 1
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
Aug 9 '05 #1
Share this Question
Share on Google+
2 Replies


P: 1
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: marius_slyzius@hotmail.com

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
Jul 31 '07 #2

bartonc
Expert 5K+
P: 6,596

Post your reply

Sign in to post your reply or Sign up for a free account.