Download sqlite Sample Databases

Download sample sqlite data sets below:

File Type: CSV | JSON | sqlite | Parquet

Sqlite Data File Examples:

File	Description
sakila.db	The Sakila sample database was initially developed by Mike Hillyer, a former member of the MySQL AB documentation team. It is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth.
chinook.db	Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

These data sets are used for testing QStudio
QStudio is a free SQL Editor that allows easily querying sqlite/parquet/h2/json/csv/tsv/duckdb files.

Using Sqlite Driver

QStudio includes support for sqlite.

SELECT "ArtistId", "Name" FROM artists LIMIT 5;

-- 2. Count the number of invoices per customer:
SELECT "CustomerId", COUNT("InvoiceId") AS "InvoiceCount" FROM invoices GROUP BY "CustomerId";

-- 3. Find the top 5 longest tracks:
SELECT "Name", "Milliseconds" FROM tracks ORDER BY "Milliseconds" DESC LIMIT 5;

-- 4. Get the total sales amount per billing country:
SELECT "BillingCountry", SUM("Total") AS "TotalSales" FROM invoices GROUP BY "BillingCountry";

Via DuckDB

QStudio bundles DuckDB which can also open sqlite files:

INSTALL sqlite;
LOAD sqlite;
ATTACH 'C:\Users\ray\dev\web\timestored.com\timestored.com\public_html\data\sample\chinook.db' AS chinook (TYPE SQLITE);
USE chinook;
SHOW tables;
SHOW databases;
SELECT * FROM albums LIMIT 10;

USE memory;
DETACH chinook;

Would query the file above via duckdb, alternatively within windows you can simply click to open a file.