Ok so if we take this repo and then the headline from https://news.ycombinator.com/item?id=41085376, we could get an infinitely fast file system by just putting another SQLite filesystem on top.

Reminds me of Microsoft WinFS.

Which was essentially SQL Server as a filesystem.

Project was ultimately cancelled.

https://en.m.wikipedia.org/wiki/WinFS

Why would you bother with this instead of just making an in memory drive? I remember mounting in memory drives even in MS-DOS back in the early 90s. I did it to move whatever game I wanted to play into the RAM Drive so my load times would be faster.

If SQLite is faster than a normal file system, how fast is SQLite running on “SQLite as a filesystem”?

Will anyone mention the repo hasn't been updated on 4 years?

It works (on Linux)! Should add that I only got to do what it does after following the advice expressed in the error message:

    fusermount: option allow_other only allowed if 'user_allow_other' is set in /etc/fuse.conf

It did not work using `sudo`

For the bored, I was searching for 'database filesystem' and found one by Oracle. I gather it's a way to make editing BLOBs easier. That could make for some interesting recursive things.

It's "a file system interface placed on top of files and directories that are stored in database tables."[0]

[0] https://docs.oracle.com/en/database/oracle/oracle-database/1...

Related: SQLiteDAV - WebDAV server that maps an SQLite database to directories/files.

https://github.com/Airsequel/SQLiteDAV

I wrote this one, I tested with PostgresDB and Oracle , at time:

https://github.com/gbonacini/dbfs

Filesystems are DB like structures these days anyway.