Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a...
by stanac on Wednesday July 29, 2026 @06:05AM
(#49095407)
If your app is a web app you could create a rudimental page with SQL input and table output and authorize only admins. It's risky, if someone gets access to admin account they can drop everything. I have something like this for logs, app reads log files directly and they are accessible only via private domain (tailscale), if I connect to public domain I can't access logs. Additionally you could enable only SELECT statements via web.
Another downside is that it will take time to make it look nice.
Another downside is that it will take time to make it look nice.