FUSE filesystem in Python

In order to take advantage of powerful queries, and existing backup systems, I moved some data from the filesystem to a database. This works well, but it’s just too convenient to have everything in the filesystem.

So I wrote my first FUSE filesystem in Python. I used the python-fuse library which is an easy-to-use wrapper around the C library. It’s probably okay to use since it’s from the same people who wrote the C library.

Where does the data live? In my ClickHouse database, of course. It gets a tiny bit laggy, I should probably do a local cache. But then you have to worry about getting stale data if someone else modifies the database.