It can rollback, it can do that nested query, and it most certainly supports replication and master/slave setups.
But my interest in software is not the brand, but can it do what I want with the least of trouble. If that's postgresql for you, fine.
MySQL can keep my data in sync with no trouble at all, I know how it works - and that's it for me.
Leon
Joose Vettenranta wrote:
15.4.2004 kello 12:39, Leon Widdershoven kirjoitti:
I actually agree with Joose; the lack of wizards in MySQL is very
disturbing.
Heh =)
OK. Bad joke. But I do agree; I think there are situations where MySQL is not the solution. As it happens nested queries have only just been introduced, which is kind of a nice feature to have. Not required - but
I created version 1 of a software to mysql and to postgresql.
versio 2 was only available as to postgresql, because mysql couldn't do transactions and nested queries..
Now that I'm working on version 3, there is even more complex SQL-queries and I don't want to even start to consider MySQL, 'caz it might not work. I don't even know does MySQL have transactions (begin, rollback, commit) and if it does handle well nested queries like (select foo from bar where x = (select bar from quux)) stuff.
Speed is something I don't need to consider, because with money I can buy hardware, but software without enough functionality isn't possible to fix with money -> have replace. And postgresql seems to be more friendly when porting to Oracle or DB2.
And how about replication in MySQL? There is replication for postgresql and there is replication for Oracle =)
- Joose
-- "Always remember that you are unique, just like everyone else!" * http://iki.fi/joose/ * [EMAIL PROTECTED] * +358 44 561 0270 *
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
