cmd sqlite3 code example

Example 1: describe in sqlite3

#describe sqlite
.schema table_name

Example 2: sqlite populate database from file command shell

sqlite3 test.db
sqlite3> .read create-tables.sql

Example 3: sqlite

SQLite is a C-langage library also works with python django 
creates automatically sqlite3 database