Local Database Replay Fixtures

SQLite, SQL, MessagePack, and JSON fixtures for offline replay, support debugging, and embedded-database validation.

3 Why This Workflow Matters
6 Files
Use workflow pages to move from a job to the exact fixtures, packs, and supporting references.
Why This Workflow Matters

About This Workflow

  • Covers embedded sqlite databases, SQL seed scripts, and binary cache/session payloads used alongside local replay workflows.
  • Useful for reproducing support incidents, validating local import logic, and exercising offline analysis tools.
  • Anchored to cache-serialization and warehouse packs so replay suites can start from one bundle.
Recommended Packs

Fixture Packs

Cache Serialization Fixture Pack

Bundle of real MessagePack, SESSION, JWT, JSON, and SQLite fixtures for cache serialization, replay, and embedded-state debugging.

cache_serialization_fixture_pack.zip · 2.8 KB

Warehouse Import Fixture Pack

Bundle of real Parquet, Avro, SQLite, CSV, and JSON fixtures for warehouse import, schema mapping, and analytic table-load workflows.

warehouse_import_fixture_pack.zip · 3.7 KB

SQL Database Seed Pack

Bundle of real SQL fixtures for schema migrations, seed data, reporting queries, and transaction-handling workflows.

sql_database_seed_pack.zip · 1.3 KB

Fixture Matrices

Fixture Matrices

SQLite Local Database Fixture Matrix

Choose SQLite fixtures for embedded database replay, schema changes, staging imports, and local-analysis workflows.

SQL Database Fixture Matrix

Use SQL fixtures for migrations, seed data, reporting queries, transaction workflows, and real large-file database seeding.

MessagePack Cache Fixture Matrix

Use MessagePack fixtures for cache payloads, compact event batches, and binary serialization compatibility checks.

Suggested Fixtures

Files

Filename Format Size Actions
sqlite_local_replay_sample.sqlite
.sqlite SHA256 02e3bb90c4e2...
SQLITE 16.0 KB
sqlite_batch_ingestion_sample.sqlite
.sqlite SHA256 77f8629e18f9...
SQLITE 12.0 KB
sql_seed_data_sample.sql
.sql SHA256 0db23b610430...
SQL 253 B
msgpack_nested_session_sample.msgpack
.msgpack SHA256 c3c15a732fa0...
MSGPACK 108 B
msgpack_cache_payload_sample.msgpack
.msgpack SHA256 565fc210a41b...
MSGPACK 130 B
json_nested_api_payload_sample.json
.json SHA256 194dfa7be986...
JSON 423 B
Related Strategy Pages

Related Guides