Sqlite manual - HawpT/BrainFloss GitHub Wiki

Setting up the db file

  • create a directory under your vm called sqlite

  • Go into the directory

  • type "sqlite3 nameofdb.db"

  • "create table nameOfTable(int a, b string)" #this creates a table that accepts a int and a string

  • use .schema to look at tables

  • to insert use "insert into nameOfTable(a,b) values(3, "hello");"

  • To select "select * from first;"

  • To quit use ".quit"

SQLite documentation website

Database setup + creating models tutorial

database tutorial

effective Django tutorial