Blog SQL Database Sample
Download a free blog SQL database with 5 tables and 2,000 rows (100 KB). Includes posts, categories, tags, comments, and users. Ideal for testing CMS backends, blog engines, and content management queries.
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
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-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
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-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
What tables are in the blog database?
Standard blog schema: users (authors), posts (with title, content, status, publish date), categories, tags (with many-to-many post_tags), and comments (with parent_id for nested comments).
Can I use this with WordPress?
This uses a generic blog schema, not the WordPress wp_ table structure. It's designed for custom blog engines (Ghost, custom CMS, learning projects). For WordPress-specific test data, use the WordPress Theme Unit Test XML.
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