[graboid]

As someone really tempted to use SQLite in production, the one thing I keep bumping against is how to have a nice GUI to interact with the running database. With our current prod databases, I can connect dbeaver and the like to them and nicely browse the data, query, or even do the occasional fix. Seems like this would be much more of a head scratcher if the database is just a file on the same VPS the app runs on.

[stanac]

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.

[d1l]

sqlite-web, put it behind nginx with basic auth or configure a password.

[woodpanel]

DBeaver can also open/manage SQLite databases. I use it daily (although on a tiny page).

[graboid]

Ah, my point was more on how to connect to the live database on some remote server.

[fnord123]

DBeaver can connect to remote sqlite databases through an SSH tunnel:

https://dbeaver.com/docs/dbeaver/Database-driver-SQLite/#rem...

[grebc]

Connect to the remote server and run it?