mysql's innodb and mysql 5's 'improvements' should address a lot of
issues with previous versions
that said, mysql and postgres are great. (i've never used firebird)
there's beginning to be less of a difference between mysql and
postgres as time progresses though
the mysql project essentially started with speed, and aimed for a
full set of db features
the postgres project essentially did the opposite: support
everything , but slow, then go for speed
i think the only annoying thing between migrated from postgres<-
>mysql is the triggers vs auto_increment stuff
if your code uses a lot of insert_id from an auto_increment field,
expect to go crazy tracking down all of your calls and creating
triggers/serials/stored procedures to replicate that functionality
On Feb 20, 2006, at 3:27 PM, Tyler MacDonald wrote:
Daniel McBrearty <[EMAIL PROTECTED]> wrote:
I'm currently using mysql, but I'm considering changing over to
firebird or
postgre.
Anyone have any reasoned loves/hates/useful experiences to pass on?
I love postgresql!
OK, to make it reasoned:
* Better license than MySQL, BSD-like license means it can be
embedded in commercial products if need be.
* Everything's journaled and transactional, which means the database
_may be slightly_ slower, but it's far more resistant to data
corruption.
* slony makes it easy to cluster your database.
* People on the postgresql-general mailing list have been responsive
and helpful
* PL/PGSQL procedural language is fast and not too difficult to
learn (although the documentation could use some improvement, if it
weren't
for my having easy access to a postgres mentor I'd have wasted many
more
hours on this...)
* I dig the elephant logo.
- Tyler
