News for hackers. Stuff that matters.
Re:SQLite-Web: Web-based SQLite database browser written in ... by c16 on Thursday February 08, 2024 @07:50AM (#39301337)
From my experience on a fun project, it's fine for running your website, but if you need to edit data as values update, pulling down the db, making changes then uploading the DB will obviously not do. You'll need some sort of web interface like phpliteadmin; and if you're not running php well now you are. Unless you want to use a docker image, and now you're using docker.

I wish there was a real simple way to connect to a remote db like you do with postgres.

Re:SQLite-Web: Web-based SQLite database browser written in ... by radiator on Thursday February 08, 2024 @11:25AM (#39303885)
if you can SSH into the remote server where the .sqlite database is saved, then you can do anything can't you? Including editing the data without down/uploading the whole DB. Perhaps also make use of sshfs, if you want to use a GUI installed on your workstation.