sqlitefs can mount a sqlite table as a file system.

The philosophy is that it should be very easy to get started (e.g. by providing a VIEW with some very simple columns and then adding more columns will put more data in the filesystem, like permissions etc.). It should also be fairly flexible and “do the right thing”, in line with the sqlite design.

Minimum required table schema:

that’s it. If it is a table, it will be mounted read-write, if it as a VIEW, it is mounted read-only (because VIEWS cannot write into their underlying tables).Forward-slashes are turned into directories.