Re: Integrity on large sites

From: "Stuart Cooper" <stuart(dot)cooper(at)gmail(dot)com>
To: "Naz Gassiep" <naz(at)mira(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Integrity on large sites
Date: 2007-05-23 02:27:54
Message-ID: 7fc8628a0705221927w632b9b16vd0b98fe7525ccb2d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "*Really* big sites don't ever have referential integrity. Or if the few
> spots they do (like with financial transactions) it's implemented on the
> application level (via, say, optimistic locking), never the database level."

Some large sites don't even use data types!

http://www.thestar.com/News/article/189175

"in some cases the field for the social insurance number was instead
filled in with a birth date."

(search the archives for "OT: Canadian Tax Database")

Cheers,
Stuart.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard P. Welty 2007-05-23 02:31:45 Re: Integrity on large sites
Previous Message Naz Gassiep 2007-05-23 02:12:52 Integrity on large sites