> To facilitate quick note taking I wrote a FUSE driver for it
I didn't understand this part. Why can't you just write the file and then either manually/automatically trigger an import of the text into the SQLiteDB?
The note taking service is on one of my raspberry pi's and exposes a HTTP API which the fuse driver interacts with.
Could have used NFS or something to achieve what you've suggested, but this is the path I went down and seems to work ok for my needs.
The fuse FS (which, fuse not at all difficult to use, there are many implementations of SQLite-backed fs) implements the trigger that automatically imports it.
All notes are markdown, stored in a SQLite DB with full text search. It has a simple frontend and you can drag/drop images onto the editor and it will upload them.
To facilitate quick note taking I wrote a FUSE driver for it and have bound CMD+N to open a command line scratchpad window (I use i3wm) where I can write and edit notes using conventional *nix tooling.
It's not perfect, nor slick, but it works for me.