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

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

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.

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.