Page 1 of 1

best database for php

Posted: Mon Nov 03, 2003 6:36 pm
by aznur95
what is the best database for php?

...i mean for commercial use,

..very robust database...best performance.. :?:

Posted: Mon Nov 03, 2003 6:50 pm
by jason
Depends on your needs really.

MySQL, PostgreSQL, Oracle, MS SQL, SAP, etc. all have a place. There is no best database for PHP. However, there are many good one's to choose from.

dependsssssssssssss????????

Posted: Mon Nov 03, 2003 7:13 pm
by aznur95
depend on my needs....hhmmm
can anybody tell me more specific...

i have one project that need to submit in 5 month.
i'm really really new in this fields...

any comparison, or analysis..
i have to do like project monitoring progress..
it may involve 1000 construction companies will use it..
data submit on 2 time a day. 12.30pm and 5.00pm including something like video file.

thanks :(

Posted: Tue Nov 04, 2003 8:01 am
by bigwreck
I have several tables which millions of rows in them using MySQL. I all you are doing is updating, selecting, MySQL is plenty good

Posted: Tue Nov 04, 2003 9:18 am
by twigletmac
Check out MySQL's crash-me server:
http://www.mysql.com/information/crash- ... advanced=1

It'll give you an idea of what various DB's support and how they holdup under strain. Which database you use really will depend on your needs - after all you know where you're happy to make tradeoffs on speed, price, functionality not us.

Mac

Posted: Tue Nov 04, 2003 10:35 am
by Johnm
MySQL, PostgreSQL, Oracle, MS SQL, SAP
Don't forget us Informix guys! <g>


John M

Re: best database for php

Posted: Tue Nov 04, 2003 4:19 pm
by JAM
aznur95 wrote:what is the best database for php?

...i mean for commercial use,

..very robust database...best performance.. :?:
Purely personal notes...

MySQL is good, and you get alot for the money when you buy the licence (as you mention commercial usage). But, it does not (yet) support Views, Procedures and subqueries to the fullest as for example MSSql.

MSSql on the other hand is a Win32 platform solution. But as an experienced MSSql user I can vouch for that it's very good, and you can link it to *nix solutions. It's Enterprise Manager is also an easy to understand and graphicly can help you build tables, views, queries etc. It comes with a db-monitor that as a db-administrator heps you alot.

However, the heavyweighter Oracle practically 'wrote the book' so to speak, supports most you can think of in the sql language (everything mentioned above), stable as a brick on a flat surface, but costs mucho dineros.

So as Mac said, try to find all benchmarking tests, but also don't forget the economic issue.

Posted: Sun Nov 09, 2003 12:07 am
by fractalvibes
For commercial use I would also recommend you take a look at IBM's DB2 for Unix?Linux/Windows. Like Oracle and the other heavy-hitters, it is not for the faint-hearted, administrative-wise - it pays to have a good DBA to manage. From a developer's perspective, it is very full-featured and robust. MySQL is not yet as full-featured, but seems very fast and robust.

Depends upon the feature set you need. You can get good performance on most any database if you do it right, and crappy performance using a bank of Crays if your SQL is crappy and your database not properly tuned...

fv

Re: best database for php

Posted: Tue May 27, 2014 9:42 am
by Tayla6
For me it has to be mysql because it is very light weight and it get along very well with PHP.

Re: best database for php

Posted: Fri Jul 18, 2014 7:04 am
by disha
Hi,
There are so many databases available but the best is MySQL because it’s easy to use, its secure, it’s inexpensive, It's fast, It runs on many operating systems and It supports several development interfaces. Thanks I hope my replay will help you.