sqlite12 KB
Sample SQLite Database
A real SQLite database with two related tables — users and orders joined by a foreign key — for testing database importers and SQL tooling.
Preview — schema + first 8 rowssqlite
| idint | nametext | emailtext |
|---|---|---|
| 1 | User 1 | user1@example.com |
| 2 | User 2 | user2@example.com |
| 3 | User 3 | user3@example.com |
| 4 | User 4 | user4@example.com |
| 5 | User 5 | user5@example.com |
| 6 | User 6 | user6@example.com |
| 7 | User 7 | user7@example.com |
| 8 | User 8 | user8@example.com |
users table (8 of 10 rows); a related orders table (25 rows) joins on user_id.
Specifications
- Tables
- users, orders
- Relationship
- orders.user_id → users.id
- Users
- 10
- Orders
- 25
What is a .sqlite file?
SQLite is a self-contained, serverless relational database stored as a single binary file holding tables, indexes, and schema in a defined page format. It is the most widely deployed database engine, embedded in browsers, phones, and applications. The file is a complete, transactional SQL database requiring no server.
How to use this file
Use an example SQLite file to test database drivers, schema and table introspection, SQL query execution, and tools that read or migrate embedded databases.
Related files
- csv10,000-Row CSVA CSV with 10,000 data rows — for testing streaming parsers, memory handling, and import performance.
- csvClean CSVA clean, well-formed CSV with a header and 20 rows — the baseline case for CSV parser testing.
- csvE-commerce Customers (CSV, 500 rows)A realistic e-commerce customer directory (500 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
- jsonE-commerce Customers (JSON, 500 records)The e-commerce customers table as a JSON array — the format twin of the CSV, for import and conversion testing.
- sqlE-commerce Database Schema (SQL)A relational SQL schema (products, customers, orders with primary and foreign keys) plus sample INSERTs — the DDL twin of the e-commerce dataset, for testing schema import and migrations.
- csvE-commerce Orders (CSV, 2000 rows)A realistic e-commerce order lines (customer_id → customers, product_id → products) (2000 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
Generated by generation/data_structured.py. Free for any use, no attribution required — license.