About this resource

Pubs, with provenance.

Microsoft's classic publishing sample database, with authors, books, publishers, stores, sales, and publisher-logo images. This site is generated from the provider contract and its pinned exports.

The source

Traceable data.

The pinned Microsoft SQL Server 2000 sample script is converted to SQLite by scripts/rebuild-source.py. Its original Microsoft 1994-2000 copyright header and the upstream repository MIT license are retained. The converter preserves all 255 INSERT statements, eleven tables, source keys and relationships, the titleview, seven ordinary equivalents of the SQL Server indexes, and eight publisher-logo GIF BLOBs. discounts and roysched have no primary key or unique index in the source; their entities omit ModelSpec keys. The generated descriptor records empty primary-key arrays but its current format does not include a unique-key inventory. Two text fields preserve the pinned source's U+FFFD replacement character in M�nchen; they are not reconstructed. Two-digit dates are normalized to ISO text; money values use SQLite numeric affinity and SQL Server collation behavior is not reproduced. The two omitted pubdate GETDATE() defaults are frozen to 2000-01-01 for reproducibility; SQL Server-only setup, triggers, and stored procedures are not part of the SQLite fixture. The build recipe validates complete logical equivalence to the committed SQLite artifact; SQLite file bytes may vary across SQLite library versions. SQLite and JSON preserve NULL values; generated CSV represents NULL as an empty field, which is indistinguishable from empty text in CSV. BLOB values in JSON and CSV are base64 encoded.

Upstream revisionbeaab06ef728
Data licenceMIT
Recordsets12

Upstream project ↗

DemoDB provider contract at 34501946b047 ↗

Read the included licence ↗

OpenVaultDB

Connect to a read-only sample database.

OVDB support is not declared by this provider. The connection target is published in the database discovery document.