Hi,

Gosh... Never Ever... I guess MySQL should close up shop...

Your question of Databases is actually quite personal to your project... What do you need? Speed/Throughput, ease-of-use, help resources, deployment tools, robust SQL...

The nice thing about MySQL, PostgreSQL, and Firebird, is they are all avaiable to try out. I like MySQL's minimalist approach for RDBMS, it fits the needs of a project of mine, and the damn thing screams.

You should hit the MySQL, PostgreSQL, etc. mailing lists, and ask a few questions with your needs in mind.

Spend some time outlining your needs, and you'll reap the benefits down the road...

-Jon

Make a list

Tino Wildenhain wrote:

Hi,

Am Montag, den 29.11.2004, 15:33 -0500 schrieb Jonathan Cyr:

Everything I've read says that MySQL is much faster, and matches
Oracle for speed... If your going to do heavy lifting on a budget...
something to consider.


Never ever. Well, if you do read only simple selects. But then
you can also store the data in Files and use memory mapping.

IF you want to do heavy inserts while complex selects are
going on you see a lot of speed differences in databases.

Not to mention what happens if you are so old fashioned to expect
you get out of the database what you put in - and not whatever
the database decides to let you see *wink* ;)

An advantage of MySQL is that it doesn't encourage you to code in the
database... stored procedures et al, are nice, but not as easy to
manage as keeping it in the app code.


This sounds like an euphemism :-) "Doesnt encourage" is better
then the bare truth: "Does not allow" ;) 

Well, for playing around, store some simple unimportant things, 
mySQL is certainly ok and a bit faster then Gadfly.

If you love your data, want to learn SQL, want a unique
interface (from different applications) to your data,
want security, dont have only trivial queries, well, then
maybe you want another database.

Regards
Tino