<snip>
>
>Instance Manager: Uniquely MySQL. It allows things like starting and
>stopping the database remotely.
>
>
I cannot think of a reason ever to need this when we have OpenSSH....
<snip>
I'm just curious, but how does this work for a windows box?
>
>Federated Storage Engine: Allows MySQL to access tables in other
>servers like they are here. No real direct equivalent in PostgreSQL,
>but dblink provides similar functionality.
>
>
DBI-Link also has a wider range of functionality and can access tables
on MySQL, Oracle, DB2, etc. servers.
<snip>
If I had just one wish for postgresql it would be to support cross-database queries like Oracle. This is a HUGE pain in the ass, and DBI-Link syntax is clunky as hell.
I would switch to Oracle tomorrow if I had the budget just because of this feature. I have data across four and five databases that are related, and I need to build cross database views, and do data munging _easily_, DBI link is far from easy, and I suspect that it's performance is far from stellar, but I've not actualy benched it. For me this needs to be a core database feature. I have certain legal problems that are also an issue where I have to keep data that is related in seperate databases, and my clients _want_ me to cross join it for select purposes, but I'm legaly required to keep it in a seperate database.
Maybe it's just difference shock - Postgresql<>Oracle so I'm scared ;), but I don't like dblink very much ;)
<snip>
Alex Turner
NetEconomist