SQLite

SQLite defines itself as “a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.” They claim it is “the most used database engine in the world.” It’s source code

Really Basic

Enthusiasts

Tutorials

  • tutorialspoint’s Learn SQLite Tutorial Series – THis covers:
    • Installation
    • Dot Commands:
      • .help, .backup, .bail, .databases, .dump, .echo, .exit, .explain, .header(s), .import, .indices, .load, .log, .mode, .nullvalue, .output (stdout), .print, .prompt, .quite, .read, .schema, .separator, .show, .stats, .tables, .timeout, .width, .timer
    • Syntax / Grammar:
      • Comments, Operators, Expressions, ALIAS Syntax, AUTOINCREMENT, EXPLAIN, Date & Time
    • Data Types:
      • Storage Classes
        • NULL, INTEGER, REAL (floating point), TEXT (string), BLOB
      • Affinity Types
    • Databases:
      • CREATE, ATTACH, DETACH, Indexes
    • Tables:
      • CREATE, DROP, Constraints
    • Queries:
      • INSERT, SELECT (DISTINCT), UPDATE, DELETE, Subqueries, Views
    • Clauses:
      • WHERE, AND & OR, LIKE, GLOB, HAVING, UNIONS, INDEXED BY, JOINS
    • Commands:
      • ALTER, TRUNCATE, PRAGMA, VACUUM
    • Useful Functions
    • Security:
      • Injection
    • Interfaces:
      • C/C++, Java, PHP, Perl, and Python.
    • Triggers
    • Transactions

Tooling

  • Official SQLite Site
    • The official homepage of SQLite.
  • DB Browser for SQLite – Stars: 14.7k – Updated: 4/2021 – Checked: 4/2021
    • A popular, open source, cross-platform, and free GUI for SQLite databases.
  • SQLiteStudio – Stars: 1.9k – Updated: 4/2021 – Checked: 4/2021
    • Another free, open source, cross-platform GUI for SQLite databases.
  • SQLite Web – Stars: 1.2k – Updated: 3/2021 – Checked: 4/2021
    • A web-based SQLite GUI that allows one to use a web browser to view and manage SQLite databases.
    • This is the quickest way I’ve found to access Visual Studio Code (VSC) Dev Containers’ SQLite databases in a visual manner.
  • sqlitebiter – Stars: 615 – Updated: 3/2021 – Checked: 4/2021
    • “A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.”
  • dqlite – Stars: 2.4k – Updated: 3/2021 – Checked: 4/2021
    • “dqlite is a C library that implements an embeddable and replicated SQL database engine with high-availability and automatic failover.”
    • “The acronym ‘dqlite’ stands for ‘distributed SQLite’, meaning that dqlite extends SQLite with a network protocol that can connect together various instances of your application and have them act as a highly-available cluster, with no dependency on external databases.”
  • Flyway
    • Created by redgate, this software provides version control for databases and works with SQLite.
  • Scout – Stars: 213 – Updated: 12/2020 – Checked: 4/2021
    • “RESTful search server written in Python, powered by SQLite…aims to be a lightweight, RESTful search server in the spirit of ElasticSearch.”
  • Datasette – Stars: 5k – Updated: 4/2021 – Checked: 4/2021
    • “Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size, analyze and explore it, and publish it as an interactive website and accompanying API.” It includes support for SQLite.

Python

PHP

Official Documentation