Re:LiteFS a FUSE-based file system for replicating SQLite
by devnull3 on Tuesday July 26, 2022 @11:30PM
(#32246599)
It just so happens that I am working on a versioned file system for sqlite based on its VFS interface. Planning to release it in a week's time. It will be in pre-alpha stage and its more of a proof-of-concept.
Having worked with FUSE in the past, there is always some performance penalty, but the advantage is that there is no change in the application.
The VFS will need change in the application but less overhead. Trade-offs!
Re:LiteFS a FUSE-based file system for replicating SQLite
by tptacek on Tuesday July 26, 2022 @04:03PM
(#32243236)
Would doing the VFS thing require participating applications to be linked to a LiteFS library?
Re:LiteFS a FUSE-based file system for replicating SQLite
by benbjohnson on Tuesday July 26, 2022 @04:14PM
(#32243371)
That's a good question. I thought that was the case but I just double checked and it looks like you can load a VFS as an extension [1].
Re:LiteFS a FUSE-based file system for replicating SQLite
by devnull3 on Tuesday July 26, 2022 @11:33PM
(#32246613)
I can confirm that it does. I am working on it as I write this :).
Technically, an extension and VFS are separate things.
An extension when loads, allows you to register the VFS with the Sqlite. It can also register virtual tables as well.
There's some interesting work I'm looking at with the VFS and WASM where you could deploy something like this across pure serverless functions like Vercel or Deno.