SQLite

SQLite is a database stored in memory or a single file, making it a great data structure and easy to transport.

About SQLite

Create a database

create table mytable (
  id integer primary key autoincremenet,
  first_name text,
  last_name text,
  email text not null
);

Read about primary keys, autoincrement, rowid: https://www.sqlite.org/autoinc.html

You may see code samples with capitalization. Many examples show integer fields using "int", but primary keys needs it spelled out as "integer primary key" for some reason.

CLI

After installing sqlite3 in your project, you can create a new database and open the terminal with:

sqlite3 database_name.db

. commands

List all commands
.help

Get create database command from schema
.schema

Change output format
.mode

Multiline commands

You can add new lines when entering commands, but when you press the up arrow to repeat a command, it only shows one line. To enter a multi line command that you can repeat, use ctrl-v ctrl-j to enter a "\n" character instead.