Sqlite Data Starter Packs — Link

Here are the specific datasets I reach for when prototyping:

I will generate a JSON object representing a "Helpful Feature". This feature is a "SQLite Starter Pack Menu" that appears when the user mentions downloading or finding data. It provides quick links to high-quality sample databases for testing and learning.

Best for: Testing ORMs (Entity Framework, SQLAlchemy) and API endpoints. sqlite data starter packs link

Chinook is a modern alternative to Northwind. It models a digital media store with artists, albums, tracks, playlists, and invoices.

Insert a note:

INSERT INTO notes (title, body, tags) VALUES ('First note', 'This is body', 'personal,ideas');

Query notes (all):

SELECT id, title, substr(body,1,200) AS preview, created_at FROM notes ORDER BY created_at DESC;

Query by tag (simple CSV tag field):

SELECT * FROM notes WHERE tags LIKE '%personal%';

Update a note (and updated_at):

UPDATE notes SET title='Updated', body='New body', updated_at=datetime('now') WHERE id=1;

Delete:

DELETE FROM notes WHERE id=1;

Using many-to-many tags: add tag & associate:

INSERT OR IGNORE INTO tags (name) VALUES ('work');
INSERT INTO note_tags (note_id, tag_id)
  VALUES (1, (SELECT id FROM tags WHERE name='work'));