Hey Indie Hackers,
I've recently published a project [1] that turns your SQLite database directly into a REST api. It can be used directly as a binary/docker image or you can use it as a lib (Rust) and add your custom routes.
The exposed api is PostgREST [2] compatible so any fontend client works (if that is your cup of tea, though i prefer to just use default http clients since the url format is very readable)
I think this combination (Rest over SQLite) would be particularly interesting for Indie Hackers since it greatly reduces operational complexity. Your entire backend is just a binary/container reading from a sqlite file, any cheap/free vps will do just fine.
Though it's a commercial project, you have access to the full source and beta testers (like you) get a free lifetime license.
Let me know what you think.
Thank you
[1] https://github.com/subzerocloud/blue-steel
[2] https://postgrest.org/