[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] pruning - using relational integrity

Kern Sibbald wrote:
> On Tuesday 12 February 2008 16.00:22 Dan Langille wrote:
>> I'm a big fan of relational integrity.  If you delete a job from the
>> Job table, everything
>> should magically disappear from the database.
> That is the way it works, only Bacula explicitly maintains the relational 
> integrity itself rather than relying on the SQL engine to do it.
>> This approach should greatly simplify the pruning.
> Unfortunately not all database support relational integrity ...

We only deal with SQLite, PostgreSQL and MySQL.  Is SQLite being dropped? 
If so, both MySQL and PostgreSQL do RI.

Dan Langille - http://www.langille.org/
BSDCan - The Technical BSD Conference: http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference:    http://www.pgcon.org/

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
Bacula-devel mailing list

This mailing list archive is a service of Copilot Consulting.