To open the SQLite3 console, make sure you have sqlite3 installed (installation guide and download page), then run the following command from the project directory:
sqlite3 sqlite3-db/pythonsqlite.db
To list all tables, run this command:
.tables
To safely quit the console, run this command:
.quit
To see the table info for the table person, run this command:
PRAGMA table_info('person');
To see all entries in the table `person' run this command:
SELECT * FROM person;