Nov-08-2019, 06:53 PM
Quote:sqlite is mainly for relational databasesSqlite3 is a relational data base management system (DBMS), it's not like one.
It would be perfectly OK to use Sqlite3, but simpler to arrange your data in memory as a dictionary, and then store as a JSON file.
Or arrange as a data frame an save with pandas.
Using sqlite3 with python is quite simple, see: https://docs.python.org/2/library/sqlite3.html