Re: multimaster - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: multimaster
Date
Msg-id 20070602081918.GA26799@svana.org
Whole thread Raw
In response to Re: multimaster  ("Alexander Staubo" <alex@purefiction.net>)
Responses Re: multimaster  ("Alexander Staubo" <alex@purefiction.net>)
List pgsql-general
On Sat, Jun 02, 2007 at 02:27:06AM +0200, Alexander Staubo wrote:
> >What you are basically saying below is... web 2.0 developers such as
> >rails developers have so fundamentally broken the way it is supposed to
> >be done, we should too...
>
> I don't know if I said that, but I would love to hear how they have
> broken it, and what you propose the solution to be.

I don't know if it's a general problem, but I've been involved in a
using rails and it appears to have it's own way of declaring the
database. It presumes to handle referential integrity and uniqueness in
the application code (!).

Lo and behold, there are now some uniqueness violations and no-one knows
why. There seems to be a general unwillingness to let the database
check this because it's "slow".

My proposal is: let databases do what they're good at: checking
uniqueness, referential integrity and constraints, and let the user
code deal with the actual work.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: PFC
Date:
Subject: Re: multimaster
Next
From: "Simon Riggs"
Date:
Subject: Re: warm standby server stops doingcheckpointsafterawhile