[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 17.42:46 Dan Langille wrote:
>> 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?
> I'll probably drop support for SQLite 2 at some point because it is not being 
> developed, but we will keep support for SQLite 3.
>> If so, both MySQL and PostgreSQL do RI.

Perhaps we could implement whatever RI we needed through stored procedures 
in SQLite:


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.