Re: mapping an sqlite3 table of files as files on the file system

On Wed, 11 Sep 2024 02:43:05 +0200
Janis Papanagnou <janis_papanagnou+ng@hotmail.com> boringly babbled:

On 11.09.2024 01:30, Johanne Fairchild wrote:

Suppose I have a series of text files stored in an sqlite3 table.  Can I
somehow read these files as if they're files on a certain directory?
Would I have to write a kernel driver for this?  It seems to me that I
would have to.

>
An interesting question. - Being curious I searched for "mount sqlite
on file system" and got a couple links; the first one was
https://adamobeng.com/wddbfs-mount-a-sqlite-database-as-a-filesystem/
Maybe it's of some use. (Or maybe some other links of that search.)

Don't see how you interact with it using any of the normal toolset unless you
map table -> directory and column -> file though it would be a very clunky
and inefficient way to use a relational DB.