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

Download

File details and verification

Filename: sample-blog.sql
Exact size: 233,739 bytes
Displayed size: 228 KB
Catalog status: Valid catalog fixture
SHA-256: 219a3fa539ba2c1d78b9bbd21605b8c863ac9b23cae396354387d0b1a5c2f12b
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 2,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-blog.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Other SQL files

sample-mysql.sql

55.6 KB

1,000 rows

Download

File details and verification

Filename: sample-mysql.sql
Exact size: 56,910 bytes
Displayed size: 55.6 KB
Catalog status: Valid catalog fixture
SHA-256: 3feac5727e2d7f9a7fbaf226f293db7fc0c0c2d7961974d4869d9316603edccd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-mysql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-postgresql.sql

55.3 KB

1,000 rows

Download

File details and verification

Filename: sample-postgresql.sql
Exact size: 56,651 bytes
Displayed size: 55.3 KB
Catalog status: Valid catalog fixture
SHA-256: 9bd034cdb1452aefe78a9b94bdb353161ef4bd9abf183adedcddd612ac545cee
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-postgresql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-sqlite.sql

55.2 KB

1,000 rows

Download

File details and verification

Filename: sample-sqlite.sql
Exact size: 56,490 bytes
Displayed size: 55.2 KB
Catalog status: Valid catalog fixture
SHA-256: 15f0df10b8d315589cf5ebe044621c6a96e52ff3ae8b43e41063ca7515f326ad
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-sqlite.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-users-table.sql

28.1 KB

500 rows

Download

File details and verification

Filename: sample-users-table.sql
Exact size: 28,735 bytes
Displayed size: 28.1 KB
Catalog status: Valid catalog fixture
SHA-256: aad074e827941c55db90b7c118b96a544f3a84518cb2a7ab075a3b66bfbdb386
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 500
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-users-table.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-ecommerce.sql

245 KB

5,000 rows

Download

File details and verification

Filename: sample-ecommerce.sql
Exact size: 250,844 bytes
Displayed size: 245 KB
Catalog status: Valid catalog fixture
SHA-256: b6f6e4b4711ad979f21fa4ef0e3e7f4603c22f44156114e4373c27425b25eebd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 5,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-ecommerce.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-schema-only.sql

528 B

Download

File details and verification

Filename: sample-schema-only.sql
Exact size: 528 bytes
Displayed size: 528 B
Catalog status: Valid catalog fixture
SHA-256: 6b773f0fba36b6484ea5c24126a1c861427e080924d2228a77cef4542de17e2a
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-schema-only.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

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

JSON XML CSV Excel (XLSX)

Similar files in other formats

sample-simple.json

87 B

1 rows

Download

File details and verification

Filename: sample-simple.json
Exact size: 87 bytes
Displayed size: 87 B
Catalog status: Valid catalog fixture
SHA-256: 2ed7134796dcc9670f375f725f09c73fd518f6d2e463dd31081137a4bd068235
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/json
Rows: 1
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/json/sample-simple.json

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-simple.xml

153 B

Download

File details and verification

Filename: sample-simple.xml
Exact size: 153 bytes
Displayed size: 153 B
Catalog status: Valid catalog fixture
SHA-256: c329bdea7bc82f57371d383f658c7dde4ecf4cac01c8be1662271ff075c9f4c2
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/xml
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/xml/sample-simple.xml

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1kb.yaml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.yaml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 2e383ce376f7cdea9bc326b12d679a226657fff5a9e1f99cda389caa956f5863
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/yaml/sample-1kb.yaml

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1kb.toml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.toml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 5321484b28dd4dd11e150116a8e70e97e8d5d953bb38a6340a13766822d35faf
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/toml/sample-1kb.toml

See how TrueFileSize generates and measures sample files, or review the editorial policy.