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