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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
