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