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@lists.sourceforge.net List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/