Which is the best database for the web?

In these days there are plenty of choices for databases over internet.

As far as I know people use Mysql, access, oracle, sybase and propably others, but which is the best and why?

[Join us @ facebook]

This depends on the project that you want it for.

If your database will have less than 100.000 - 200.000 records then the best choice is MySQL. This is because mysql is not too loaded with extra stuff that the big dbms (database management systems) have. And this is why mysql is the fastest database for internet. Another great advantage of mysql is that is open source and almost free to use(1$ per license I think) and it is very well documented.

Access is the worst database in the world, and I say that because it is the only dbms that can not handle more than 10 connections, plus it has a lot bugs.

Sybase and Oracle are the best solution for very big databases. I used oracle in one of my projects for this reason, but I should warn you it is too difficult to use it with php, but this is about to change as Oracle has made a cooperation with zend about this, so in the future the integration will be easier.

what about PostgreSQL?

[Join us @ facebook]

what about PostgreSQL?

I never used this database so I can't tell

I use MySQL too, because everybody uses it. I don't know much about databases so I can't tell if there is a better one

MySQL here, havnt really used any other ones.

MySQL here, havnt really used any other ones.

Me too. Propably because everybody is using this database all over the internet.

Very true, I dont know much people that use other ones.

I've only used MySQL as well, it has worked fine for everything I've needed it for.

[Guest]

[36.293]

Yahoo crawler, Googlebot, Baidu Spider