What database?

[exp]

You guys are funny :) MySQL is one of the biggest DB's in the market.

erm, you mean most common, not biggest.
MySQL can't keep up with a real DBS, feature wise.
And DB2 or Oracle is what I call a big DBS btw. :P

BYe!
EXP

[DonGato]

MySQL is no match for any serious database, and that is put in everything but the soup doesn't mean it "is" good. I know an OS that does that in almost every computer sold. -_-;

[Furcube]

of course
MySQL was made to be small and fast and to handle small databases
It would be rather stupid to buy Oracle for small db
PS
Simple example of large db handled by MySQL: www.livejournal.com

[PetriW]

LiveJournal is hardly complex however.

[Elberet]

MySQL currently offers:

• MySQL 4.0 (stable, outdated)
• MySQL 4.1 (stable, recommended for production systems)
• MySQL 5.0 (development release, not tested enough to be considered stable)

- views (partial, 5.0~)
- sequences (missing, ?)
- constraints (present in 4.1)
- subqueries (present in 4.1)
- triggers (5.1)
- stored procedures (since 5.0)
- prepared queries (present in 4.1)
- cursors (since 5.0)
- transactions (present in 4.1, BDB or InnoDB tables)

MySQL ain't all that bad, incompatible or outdated as you made it look.

[DonGato]

Nobody said it was bad but that is not the best choice for a project like this. AniDB might have been small but with time will grow bigger and bigger.

[PetriW]

MySQL ain't all that bad, incompatible or outdated as you made it look.

Granted, 5.0 ain't production quality and 4.1 hasn't been out all that long.
It took a long time to get these features and most who use mysql today don't have mysql 4 much less innodb tables.

I'd still pick postgresql over mysql.

[Elberet]

Well, personally, if I need a database that offers most feautures and supports complex queries, I'd pick postgresql as well. But if long-term stability and performance are most important, I'd go with MySQL and MyISAM tables.