A Sqlite3 logging demo with CCS811 Air Quality Sensor connected to an ESP32. This demo has a backend for logging, and a backend for a web ui that shows a graph.
For manual review of the Sqlite3 db you can use a really handy program called sqlitebrowser: https://github.com/sqlitebrowser/sqlitebrowser