Re: [Gnu-arch-users] file system interface to a database

[Milan Cvetkovic]

Andy Tai wrote:
> Thanks for the information. It does not look like this is an easy thing
> to do, to try to put a tla archive on top of sqlite.  But nontheless I
> may try to look into continuing the work you have done when I feel up to
> it...

Well, I am not too sure if this is the good thing to do, to put tla on
top of sqlite (or any database).

One of the main reasons why I decided to use tla (and migrate all
projects in the company to tla) is that it *never* touches the old files
(old revisions). So, you could have portions of your archive on a CD
ROM. I never tried this, but the thought of "not modifying" the previous
revisions gave me high level of confidence that tla will not corrupt my
archive so easy.

With sqlite, I would imagine that there would be a single database for a
number of revisions. Adding a revision would have to modify this
database, rather than add a new file (or directory, or whatever tla
adds). This means that a bug in tla could easyly corrupt old revisions.

At least, there should be always be an option to use file system instead
of sqlite.

Regards, Milan.


> 
> Andy
> 
> On 1/6/06, *John Arbash Meinel* <address@hidden
> <mailto:address@hidden>> wrote:
> 
> 
>     >
> 
>     I worked on creating a virtual filesystem (hackerlab vu layer) for both
>     zip files, and for an sqlite database. I don't know that I got very far
>     with the sqlite database.
>     But here is my older archive:
>     http://arch.arbash-meinel.com/address@hidden/
>     In general, writing a virtual filesystem wasn't terribly hard. The
>     hardest part was handling the fact that tla wants atomic rename, but
>     that isn't possible in a zip file. (*especially* if you are renaming
>     between zip files).
> 
>     I guess that was the hard part in general. There were a lot of places in
>     the tla code where it expected everything to be on the same filesystem.
> 
>     John
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Gnu-arch-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/gnu-arch-users
> 
> GNU arch home page:
> http://savannah.gnu.org/projects/gnu-arch/