News for hackers. Stuff that matters.
Re:LiteFS a FUSE-based file system for replicating SQLite by benbjohnson on Tuesday July 26, 2022 @03:56PM (#32243151)
The VFS system is great and I plan to support that as well. SQLite is simple to get started with but it can be complicated to integrate a VFS depending on the language using. My goal is to make the deployment as simple as possible and also to support legacy applications.

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.

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].

[1] https://www.sqlite.org/loadext.html

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.