Re: PostgreSQL 8.1 vs. MySQL 5.0?

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Alex Turner <armtuk(at)gmail(dot)com>
Cc: Chris Travers <chris(at)travelamericas(dot)com>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, CSN <cool_screen_name90001(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?
Date: 2005-10-13 18:29:54
Message-ID: 1129228194.18052.79.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

Am Donnerstag, den 13.10.2005, 13:00 -0400 schrieb Alex Turner:
...
>
>
>
> 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.

Why not put them in separate schemas and tell the customers these
are separate databases? From outside it looks exactly like it.
You can constraint the users to the different schemas and still
join between the tables at will. See schema-searchpath and
stuff for sticking users to a schema.

HTH
Tino

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Alex Turner 2005-10-13 18:58:27 Re: PostgreSQL 8.1 vs. MySQL 5.0?
Previous Message David Fetter 2005-10-13 17:35:22 Re: PostgreSQL 8.1 vs. MySQL 5.0?

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-13 18:30:11 Re: On "multi-master"
Previous Message Tom Lane 2005-10-13 18:23:21 Re: PostgreSQL Gotchas