[Zope] Which database?
Jonathan Cyr
cyrj at cyr.info
Mon Nov 29 16:50:08 EST 2004
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
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20041129/1ae2f465/attachment.htm
More information about the Zope
mailing list