SQL joins: a small reference with predictable results
Use a tiny customer-and-order dataset to see inner joins, left joins, and the filter placement that changes their meaning.
SQLite.
An embedded SQL database that stores an application's data in a local file.
Official documentationWhere it fits
An embedded SQL database that stores an application's data in a local file.
This profile covers a embedded database in the Relational databases category.
Evaluate it for your workload
Start with your access patterns, data size, concurrency, and recovery requirements. Check the official documentation for the exact edition, engine version, and deployment model you intend to use.
For self-managed deployments, account for upgrades, monitoring, access controls, and the process for recovering your data.
Learn by doing
Related guides appear below as they complete editorial review. Use those examples as a starting point for testing a representative development workload.