I received a potentially nice tip from Mr Shark today – a web editor for SQLITE (as against PHPLITEADMIN which is not Web based and uses PHP). Beware I found some kind of timeout, the author agreed this was likely some kind of timeout, then closed the issue on Github without doing anything. Not sure what that means.
sudo pip install –upgrade pip
sudo pip install sqlite-web
sqlite_web -H 0.0.0.0 -x –P dbs/iot.db
Where 0.0.0.0 is the IP address of the machine with SQLITE on it (otherwise the editor defaults to localhost so you can access the DB from the board itself.
Change that to the IP address of your SQLITE installation.
The software uses port 8080 by default, To use instead for example port 89…on internal address 192.168.1.19
sudo sqlite_web -H 192.168.1.19 -x -p 89 -P dbs/iot.db
If using port under 1024 you need to run with sudo/
If you want to pass the password as an environment variable:
sudo SQLITE_WEB_PASSWORD=mypass /usr/local/bin/sqlite_web -H 0.0.0.0 -x -P -p 89 /home/pi/dbs/iot.db
If you’re planning to use this a lot, it can be installed as a service, right now it holds up that user session and you break out with control-C.
Looks good. https://github.com/coleifer/sqlite-web