Sqlite Data Starter Packs Link
Use simple normalized tables. Example for a notes app:
Optional tags table for many-to-many:
Create those tables:
CREATE TABLE notes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
body TEXT,
tags TEXT,
created_at TEXT DEFAULT (datetime('now')),
updated_at TEXT DEFAULT (datetime('now'))
);
CREATE TABLE tags (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT UNIQUE NOT NULL
);
CREATE TABLE note_tags (
note_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY(note_id, tag_id),
FOREIGN KEY(note_id) REFERENCES notes(id) ON DELETE CASCADE,
FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE
);
Don't use a browser. Use curl or wget for speed:
curl -L -o chinook.db https://github.com/lerocha/chinook-database/raw/main/ChinookDatabase/DataSources/Chinook_Sqlite.sqlite
Best for: Learning JOINs, sales dashboards, and inventory management. sqlite data starter packs link
Northwind is the "Hello World" of database schemas. It includes customers, orders, products, shippers, and employees.
Where to find the exact link: Visit
www.sqlitetutorial.net→ "SQLite Sample Database" → Right-click the download button to copy the direct.dbURL. Use simple normalized tables
Unlike cloud databases that require credentials, networking, and provisioning, SQLite lives in a single file. To start a new project with a starter pack, you literally run:
cp ./starter-packs/ecommerce.db ./my-new-app.db
That’s it. You now have 10,000 products, 2,000 customers, and 15,000 orders ready to query. Optional tags table for many-to-many:
