Peter Walter wrote at about 07:44:49 -0400 on Tuesday, June 2, 2009:
 > Tino Schwarze wrote:
 > > An SQL approach would be rather complicated because it would have to
 > > support a directory structure. We would end up with ... a filesystem!
 > >   
 > 
 > Yes, but SQL databases are not the only game in town. There are other 
 > database architectures that would be a good choice for supporting a 
 > hierarchical structure, and, although I am not a Perl programmer, I am 
 > told by my friends who are into Perl that Perl's superior 
 > text-processing capabilities makes databases built solely on text files 
 > feasible, without requiring inclusion of or dependencies on another 
 > database project.
 > 

I think using databases built solely on text files would be slow. In
fact, that is essentially what BackupPC does now in that the attrib
files are really individual database files constructed for each
directory. However, each time they are accessed, they need to be read
in, unpacked, parsed, edited, repacked, rewritten, etc. which is slow
and kludgy. What we really want here is a relational database - that
would allow access to all the attribs and metadata.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/