SQLiteドキュメント - Truly the knowledge base

SQLiteドキュメント

SQLiteの公式が出しているドキュメントは、SQLiteのデータベースの利用想定が滲んでいて面白い

https://sqlite.org/docs.html

Distinctive Features Of SQLite

SQLite Is Serverless

SQLite is Transactional

Atomic Commit In SQLite

Quirks, Caveats, and Gotchas In SQLite

Features

SQLite And 8+3 Filenames

SQLite Autoincrement

SQLite Foreign Key Support

Internal Versus External BLOBs in SQLite

Using SQLite In Multi-Threaded Applications

Indexes On Expressions

NULL Handling in SQLite Versus Other Database Engines

Clustered Indexes and the WITHOUT ROWID Optimization

SQLite Shared-Cache Mode

Advocacy

35% Faster Than The Filesystem

The Advantages Of Flexible Typing