SQLite Foreign Key Support
SQLite Autoincrement
PRAGMA Statements
Write-Ahead Logging
Atomic Commit In SQLite
SQLite is Transactional

SQL As Understood By SQLite

SELECT
INSERT
UPDATE
BEGIN TRANSACTION

SQLite C Interface

Last Insert Rowid

Tutorials

renenyffenegger.ch: SQLite
SQLite – AUTOINCREMENT
SQLite AUTOINCREMENT
SQLite Transaction

Command Line Shell For SQLite

Command Line Shell For SQLite

$ sqlite3.exe /c/Users/andreas/AppData/Roaming/DatabaseSelect/default.sqlite

.database
.table
.tables

.mode column
.header on

.quit

MSYS

$ pacman -S sqlite3
$ pacman -S sqlite-vfslog