Simple HTTP based SQLite server which serialises writes.
For an application with mutiple processes wanting to write to a single DB, we can
- Enable WAL mode to handle concurrent reads within the application,
- Serialize writes by sending SQL writes to this this SQLite server,
Internally,
- We setup a HTTP server exposing an endpoint,
- Get multipe SQL write requests, which is serialized by a go routine,
- Yet to bind to local host,
- Some form of authnetication to HTTP requests to prevent attacks leading to DB corruption,
- Executable size. Its ~13 MB in macOS Big Sur. We can compress using tools like UPX.
- Can we handle SQL READs and formulate a way to respond data needed precisely for the query
- Authenticate DB requests
- Bind HTTP server to local host
MIT License