best database for php

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
aznur95
Forum Newbie
Posts: 2
Joined: Mon Nov 03, 2003 6:36 pm
Location: selangor, malaysia
Contact:

best database for php

Post by aznur95 »

what is the best database for php?

...i mean for commercial use,

..very robust database...best performance.. :?:
jason
Site Admin
Posts: 1767
Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:

Post 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.
aznur95
Forum Newbie
Posts: 2
Joined: Mon Nov 03, 2003 6:36 pm
Location: selangor, malaysia
Contact:

dependsssssssssssss????????

Post 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 :(
bigwreck
Forum Newbie
Posts: 2
Joined: Tue Nov 04, 2003 8:01 am

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
User avatar
Johnm
Forum Contributor
Posts: 344
Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:

Post by Johnm »

MySQL, PostgreSQL, Oracle, MS SQL, SAP
Don't forget us Informix guys! <g>


John M
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Re: best database for php

Post 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.
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post 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
Tayla6
Forum Commoner
Posts: 26
Joined: Thu Oct 10, 2013 8:40 am
Location: Manchester
Contact:

Re: best database for php

Post by Tayla6 »

For me it has to be mysql because it is very light weight and it get along very well with PHP.
Tayla the great
disha
Forum Newbie
Posts: 5
Joined: Fri Jul 18, 2014 6:21 am

Re: best database for php

Post 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.
Post Reply