On 13 Sep 2014, at 6:16pm, Tim Streater <t...@clothears.org.uk> wrote:
> On 13 Sep 2014 at 16:39, Richard Hipp <d...@sqlite.org> wrote: > >> I say that a filesystem is an eventually-consistent key/value database. >> The keys are the filenames and the values are all big BLOBs, specifically >> the file content. Filesystems also have a hierarchical keyspace, which is >> an extension from the usual key/value concept, but it is still key/value. > > Key Example value > --- ------------- > filename somefile.txt > creation date <seconds since the epoch> > file type text > opens with textwrangler.app > content <lines of text> > ... > > and so on. That's not what I meant. That's the file as a database. What I want is the entire volume as a database. It would be something like Key Example value --- ------------- /robots.txt/path / /robots.txt/filename robots.txt /robots.txt/creationdate whatever /robots.txt/filetype text /robots.txt/creatorapp /Applications/textwrangler.app /robots.txt/content BLOB /index.html / /index.html/filename /index.html /index.html/creationdate whatever ... The actual primary key would be a a two column index, of course. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users