5 ms·
Next week on Show HN: `sqlitefs`, the SQLite-backed FUSE filesystem?
by OJFord 7y ago
Next week on Show HN: `sqlitefs`, the SQLite-backed FUSE filesystem?
- progval 7y agoHaving it on top of FUSE would make it significantly slower than an in-kernel filesystem.
- mirekrusin 7y agoIt would be interesting to see how it performs ie. on nodejs projects with node_modules.sqlite3 - for practical reasons it would be nice to mount it via fuse to node_modules - if needed.
- dana321 7y agoWell, to be fair, it would be a lot faster than mysqlfs.
- ruuda 7y agoSomething similar exists: https://www.youtube.com/watch?v=wN6IwNriwHc https://www.youtube.com/watch?v=wN6IwNriwHc
- ngirard 7y agoInteresting project, thanks. For the record, their GitHub repository is https://github.com/samzyy/DB-based-replicated-filesystem https://github.com/samzyy/DB-based-replicated-filesystem
- dymk 7y agohttps://github.com/guardianproject/libsqlfs https://github.com/guardianproject/libsqlfs already exists
- devnonymous 7y agoI've taken a stab at this and made quite a bit of progress. However, the idea was to use the sqlite fuse layer as a stacked layer over the underlying filesystem rather than a full scale file-system (which for example, is what libsqlfs provides). The motivation was not to improve filesystem performance but improving the speed of querying (ie: lightning fast stat of the entire deeply nested directory tree) at the expense of slower writes. Additionally I could (in theory, never got around to it) store rich metadata about the files, build all sorts of indexes, apply a richer access-control mechanism etc. Unfortunately, it remains in pre-alpha state, because life.