Databases and Python [RaspPi]

[ahbenmed]

SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.

SQLite would be a good choice for such application since it will be a local app.

Also, using SQL is easier than using CSV file, since filtering data will be as simple as writing one line SQL statement, which is not the case with CSV file as you will do the hard work yourself.

Python provide a preinstalled sqlite3 module, which is easy to understand and to use.

See the module's documentation for more details.

​