SQLite

1. Appropriate Uses and Architecture

   Embedded serverless design, single-file database, when SQLite fits versus client/server databases.

2. Datatypes and Type Affinity

   Storage classes, dynamic typing, type affinity, flexible typing and comparison rules.

3. SQL Language Syntax

   Supported SQL statements, CREATE TABLE, upserts, CTEs, RETURNING, ALTER TABLE and SQLite dialect specifics.

4. STRICT and WITHOUT ROWID Tables

   Rigid type enforcement with STRICT tables, rowid versus WITHOUT ROWID table layout and INTEGER PRIMARY KEY.

5. Foreign Key Support

   Enabling foreign key enforcement, ON DELETE and ON UPDATE actions, deferred constraints and constraint behavior.

6. Partial and Expression Indexes

   Partial indexes, indexes on expressions, covering indexes and index design.

7. Query Planner and Optimizer

   How the optimizer chooses indexes, EXPLAIN QUERY PLAN, ANALYZE statistics, join ordering and the next-generation query planner.

8. Atomic Commit and Rollback Journal

   Journal-based atomic commit, fsync durability, crash recovery and how transactions stay ACID.

9. Locking and Concurrency

   Shared, reserved and exclusive locks, SQLITE_BUSY, busy timeout, BEGIN IMMEDIATE and writer serialization.

10. Write-Ahead Log (WAL) Mode

    WAL mode, readers not blocking writers, checkpointing, WAL file growth and its limitations.

11. Isolation

    Isolation between connections, read transactions as snapshots and read uncommitted behavior.

12. Pragma Commands

    journal_mode, synchronous, cache_size, foreign_keys, user_version and other runtime configuration.

13. JSON Functions

    JSON and JSONB functions, path syntax, json_each and json_tree and generated columns over JSON.

14. FTS5 Full Text Search

    Virtual tables for full-text indexing, MATCH queries, tokenizers, ranking with bm25 and external content tables.

15. Window Functions

    OVER clauses, partitions, frames, ranking functions and running aggregates.

16. Virtual Tables and Extensions

    Virtual table interface, loadable extensions, R-Tree and other modules.

17. File Format and Internals

    B-tree pages, database file layout, page size and the VDBE bytecode engine.

18. Limits and Threading

    Thread-safety modes, connection sharing across threads and implementation limits.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.

Source: endoflife.date

• ScyllaDB
• Sidekiq
• Snowflake
• Solr
• Spark
• SQL Server
• Superset
• SurrealDB
• TimescaleDB
• Trino
• Turso
• Typesense