5.2 SQLite Database – Database Frontend

The Pinebox has an integrated web front end for the SQLIte database. The database frontend is based on sqlite-web, and can be accessed on port :8080 of the Pinebox web server or via the link in the Pinebox web interface menu:

On the left side of the database frontend, the tables for the ports are shown. The default table names are PORT_1 to PORT_4:

The default database name is database.db.

The tabs for each table splits into structure, content, query and insert:

Under “Structure”, the table structure of the port can be analysed. Also, additional columns can be added, and columns can be altered and deleted

Unter “Content”, the acquired data can be analysed and also modified.

Under “Query”, custom queries can be executed to view and also modify the database structure and content. Knowledge of the SQL syntax is required to do so.

Unter “Insert”, data can be added column-wise.