[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:

http://www.justatheory.com/computers/databases/sqlite/foreign_key_triggers.html


-- 
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.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.