Sakila is the official MySQL training DB, ported to SQLite. It features rental stores, films, actors, and customers. It is excellent for teaching many-to-many relationships.
: Lists of names from 1980 through 2015. sqlite data starter packs link
| Pack Name | Direct Link Pattern | Best For | | :--- | :--- | :--- | | Northwind | sqlitetutorial.net → Sample DB button | SQL beginners | | Chinook | github.com/lerocha/chinook-database | ORM testing | | IMDb (Kaggle) | kaggle.com/datasets/.../download | String queries | | COVID-19 | data.world → SQLite export | Date functions | | Datasette Gallery | datasette.io/-/galleries/example-databases | One link for all | Sakila is the official MySQL training DB, ported to SQLite
If you’re learning SQL or building a quick prototype, the SQLite Data Starter Packs are a fantastic time-saver. Instead of creating fake data from scratch or hunting for messy CSV files, these packs give you clean, well-structured SQLite databases ready to query. : Lists of names from 1980 through 2015
Stop wasting time mocking database data! 🛑