Sample SQLite SQL File
Download a free SQLite-compatible SQL dump with 3 tables and 1,000 rows (50 KB). Test SQLite database creation, embedded database seeding for mobile/desktop apps, and SQLite-specific syntax handling.
sample-sqlite.sql
55.2 KB
1,000 rows
Verified file details
- Filename
- sample-sqlite.sql
- Exact size
- 56,555 bytes
- Displayed size
- 55.2 KB
- MIME type
- application/sql
- Rows
- 1,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-sqlite.sql
Other SQL files
sample-mysql.sql
55.2 KB
1,000 rows
Verified file details
- Filename
- sample-mysql.sql
- Exact size
- 56,547 bytes
- Displayed size
- 55.2 KB
- MIME type
- application/sql
- Rows
- 1,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-mysql.sql
sample-postgresql.sql
55.4 KB
1,000 rows
Verified file details
- Filename
- sample-postgresql.sql
- Exact size
- 56,771 bytes
- Displayed size
- 55.4 KB
- MIME type
- application/sql
- Rows
- 1,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-postgresql.sql
sample-users-table.sql
27.7 KB
500 rows
Verified file details
- Filename
- sample-users-table.sql
- Exact size
- 28,413 bytes
- Displayed size
- 27.7 KB
- MIME type
- application/sql
- Rows
- 500
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-users-table.sql
sample-ecommerce.sql
245 KB
5,000 rows
Verified file details
- Filename
- sample-ecommerce.sql
- Exact size
- 251,375 bytes
- Displayed size
- 245 KB
- MIME type
- application/sql
- Rows
- 5,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-ecommerce.sql
sample-blog.sql
228 KB
2,000 rows
Verified file details
- Filename
- sample-blog.sql
- Exact size
- 233,200 bytes
- Displayed size
- 228 KB
- MIME type
- application/sql
- Rows
- 2,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-blog.sql
sample-schema-only.sql
528 B
Verified file details
- Filename
- sample-schema-only.sql
- Exact size
- 528 bytes
- Displayed size
- 528 B
- MIME type
- application/sql
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-schema-only.sql
Frequently Asked Questions
How do I import this into SQLite?
CLI: sqlite3 database.db < sample-sqlite.sql. Or use DB Browser for SQLite (GUI). In Node.js: better-sqlite3 can execute the file content directly. In Python: sqlite3 module's executescript().
What makes SQLite SQL different?
SQLite uses dynamic typing (any column can store any type), INTEGER PRIMARY KEY for auto-increment, no user management, and a simpler CREATE TABLE syntax. It doesn't support ALTER TABLE DROP COLUMN (before v3.35) or some advanced constraints.
Other data formats
Similar files in other formats
sample-simple.json
87 B
1 rows
Verified file details
- Filename
- sample-simple.json
- Exact size
- 87 bytes
- Displayed size
- 87 B
- MIME type
- application/json
- Rows
- 1
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/json/sample-simple.json
sample-simple.xml
153 B
Verified file details
- Filename
- sample-simple.xml
- Exact size
- 153 bytes
- Displayed size
- 153 B
- MIME type
- application/xml
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/xml/sample-simple.xml
sample-1kb.yaml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.yaml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/yaml/sample-1kb.yaml
sample-1kb.toml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.toml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/toml/sample-1kb.toml