I have set up a website on my VPS (running Ubuntu with a B4JServer). For this test-project, I used Sqlite.
Normally I use DB Browser for Sqlite but that means I must download the DB locally and then open it. To do that, I must stop the server which I prefer not to do...
Thus, I am wondering if it is possible to query the Sqlite datebase from a shell?
Thanks.
I have set up a website on my VPS (running Ubuntu with a B4JServer). For this test-project, I used Sqlite.
Normally I use DB Browser for Sqlite but that means I must download the DB locally and then open it. To do that, I must stop the server which I prefer not to do...
Thus, I am wondering if it is possible to query the Sqlite datebase from a shell?
Thanks.
What I did was install Caddy as a reverse proxy that also hosts PHP pages and run phpliteadmin to do remote management.
Caddy thus hosts phpliteadmin, but also acts as a revrse proxy (with let's encrypt SSL) to Jetty applications in B4J.
You can also use the (commercial) Navicat suite that can connect to sqlite through a tunnel (php page as well). Works very well (has much more functionality than phpliteadmin) but comes at a cost of 59 USD (or plus depending on your situation). See: https://www.navicat.com/en/store/navicat-essentials