On Mon 07 Jun 2010 at 05:07:43 PM +0200, Kees Nuyt wrote: > >That could be implemented as an appication with a set of >virtual tables, backed by the readdir() and stat() system >calls. >I haven't heard of any implementation, although fossil >http://www.fossil-scm.org/index.html/doc/tip/www/index.wiki >has a few routines which might be interesting.
Interesting approach. I've never heard of virtual tables. Unfortunately, I don't know anything about the backend of generating indices or optimizing db queries either. But I see what you are getting at, maybe I can work it out. Fossil, looks interesting too. I'm adding it to my library of resources on this project. If it's not clear, I want to do development on top of such an application. The key goal here is to address data sprawl. Duplicate files on multiple (offline) disks, S3 like resources and no index for 5 year old (or 1 month) data. I'm looking to index, merge and purge duplicate data; and be able to opportunistically build indices and run transactions while media is transiently online. So, something that barely works---builds indexes from fs data, supports rudimentary queries and generates filesystem manipulation commands is my first goal. I'll use it to discover duplicates and organize files. I'm sure this project will evolve considerably. >I know Microsoft does (or tries to do) something similar, >perhaps MSDN is of any help? The only microsoft system I have is a multimedia player. Not sure how I could roll their products into my developments.... Thanks, Cheers, George _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users