Data · 6 files
Sample SQLite Files
SQLite 3 databases with customers and orders tables linked by a foreign key, an index and a view. Open them with the sqlite3 CLI, DB Browser for SQLite or any SQLite driver.
All 6 sqlite files
Download all with curl
# 6 files, 141 MB in total
while read -r url; do curl -LO --fail "$url"; done <<'EOF'
https://files.samplefiles.com/data/sqlite/sample-1k-rows.sqlite
https://files.samplefiles.com/data/sqlite/sample-1mb.sqlite
https://files.samplefiles.com/data/sqlite/sample-10k-rows.sqlite
https://files.samplefiles.com/data/sqlite/sample-10mb.sqlite
https://files.samplefiles.com/data/sqlite/sample-100k-rows.sqlite
https://files.samplefiles.com/data/sqlite/sample-100mb.sqlite
EOF| File | Size | Details | Download |
|---|---|---|---|
| SQLite database, 1,000 customerssample-1k-rows.sqlite | 328 KB | 1,000 rows | Download |
| 1 MB SQLite filesample-1mb.sqlite | 1 MB | 6,554 rows | Download |
| SQLite database, 10,000 customerssample-10k-rows.sqlite | 2.9 MB | 10,000 rows | Download |
| 10 MB SQLite filesample-10mb.sqlite | 9.6 MB | 63,249 rows | Download |
| SQLite database, 100,000 customerssample-100k-rows.sqlite | 30.7 MB | 100,000 rows | Download |
| 100 MB SQLite filesample-100mb.sqlite | 97 MB | 627,512 rows | Download |