On Sun, 09 Apr 2006 18:55:29 -0400, Reed Hedges wrote: >> my personal goal for .24 would be refurbishing the sqlpersist machinery. I >> just don't trust mysql at all ;-) > > What do you mean, you don't trust it? > > What about PostgreSQL then?
I know MySQL is now a complete proper database system, with ACID and all. But up to just a few months ago, it was just a place to dump your data that happened to (mostly) respond to SQL queries. It gained so much popularity because it was fast; but anyone who really cared about this database stuff knew that it was faster because it was incomplete. Like, well, DOS is faster than WinXP. And even now, at least last time I looked, the "completeness" (ACID compliance and whatever else) is optional... the default setup is just as bad (and fast) as it was in the bad old days. The Free Software / Open Source world can do better. Where you need ACID compliance, safety, robustness, and flexibility, go with PostgreSQL, it's a much better database. Where you need speed and don't care much about the other stuff, sqlite simply humiliates MySQL. As for the "trust"... most admins will go for the "fast" setup, or even not touch the defaults. Then something bad happens to the data, and it's our fault. Sigh. best, Lalo Martins -- So many of our dreams at first seem impossible, then they seem improbable, and then, when we summon the will, they soon become inevitable. -- personal: http://www.laranja.org/ technical: http://lalo.revisioncontrol.net/ GNU: never give up freedom http://www.gnu.org/ _______________________________________________ vos-d mailing list vos-d@interreality.org http://www.interreality.org/cgi-bin/mailman/listinfo/vos-d