[development] Referential integrity -- finally?

[Darrel O'Pry]

On Mon, 2007-01-22 at 23:53 -0500, Rowan Kerr wrote:
> On 22-Jan-07, at 5:31 AM, adrian rossouw wrote:
> > Maintaining schemas is still a lot of work,. and i fear adding another 
> > layer of complexity to it will start making it unmanageable.
> 
> If the schemas are designed correctly, there should not need to be many 
> changes made over time. :)
> 
> 
> > This means we're going to be doing essentially the same work 6 times 
> > over. And that's only for core, the majority of contrib
> > modules will still not work on other db's.
> 
> Or we could write some schema migration helper functions when queries 
> between different databases are too different?

cck has some code that sort of does that for normalizing field tables
when you have shared field instances or multivalue fields.

> > I also seriously doubt that just adding referential integrity is going 
> > to draw lots of postgresql experts out of the ether..
> 
> This affects more than just PostgreSQL. Having RI, while not some sort 
> of silver bullet, will make database design sticklers take Drupal more 
> seriously and open up new areas for deployment.
> 
> -Rowan
>