Powerful open source SQLite manager for Raspberry Pi
SQLite is a lightweight but powerful database management tool. It occupies a little space on the device – a bit more than 500KB, but offers most of the features implemented on other SQL database tools. SQLite is a serverless engine, meaning that the whole database is stored in a single file, and all transactions are reads and write from the file. There are no initial server configurations required – all you need is to create a .db file and start writing queries. This is why SQLite is preferred on small devices like mobile phones, embedded devices, and Raspberry Pi. Previously, we have installed an SQLite into Raspberry Pi, created a database and table with only a few lines of script. We performed all the tasks from the command-line tool. Eventually, you will want to have full control of the database and see the whole picture. Therefore, you should also consider installing SQLite manager, which brings a graphical user interface to work with SQL databases. To run the SQLite manager, you will need to work from the Raspberry Pi desktop. You may want to connect a monitor or use a VNC client to access the Raspberry Pi desktop like me. VNC…