Sqlite Data Starter Packs Link !!install!!
Northwind is the "Hello World" of database schemas. It includes customers, orders, products, shippers, and employees.
: Originally for MySQL, this DVD rental store database has been ported to SQLite and is available on GitHub and Kaggle .
That’s it. You now have 10,000 products, 2,000 customers, and 15,000 orders ready to query. sqlite data starter packs link
The European Soccer Database (25,000+ matches), 120 Years of Olympic History, and cryptocurrency historical price packs. 3. Datasette Ecosystem (Public Data)
— Inspired by Pieter Levels' philosophy of using simple tech stacks, this project demonstrates a single-file architecture that handles all routing and logic in one index.php file, using SQLite with optimized settings for performance. It has achieved impressive results: 330,000 writes per second on a Vultr NVMe VPS ($12/mo) and 180,000 writes per second on a Hetzner entry VPS (€3.30/mo). Northwind is the "Hello World" of database schemas
I can provide direct repository links and tailored initialization code for your specific setup. Share public link
For those looking for a standard technical "sandbox" database, the Chinook Sample Database That’s it
sqlite-utils insert my_starter.db my_table huge-dataset.csv --csv
There is a massive collection of these starter packs maintained by the open-source community. You can find everything from NBA player stats to historical weather data.
Large row counts, ideal for practicing window functions and aggregates. Localized Geography / ZIP Codes
— A very simple, very small database of people who just go by their first names, and live in a world in which they own pets and homes. This 0.01 MB database contains 3 tables and is ideal for learning new SQL syntax.