signet-cold-sql

SQL backend for signet-cold storage.

Testing

SQLite (no external dependencies)

cargo t -p signet-cold-sql --features test-utils

PostgreSQL (requires Docker)

A script is provided to start a Postgres container and run the full test suite (SQLite + PostgreSQL):

./scripts/test-postgres.sh

This starts a Postgres 16 container via docker compose, runs the conformance tests with DATABASE_URL set, and tears down the container on exit.

Manual steps (if you prefer to manage Postgres yourself):

# 1. Start Postgres (any method)
docker compose up -d --wait postgres

# 2. Run tests with the connection string
DATABASE_URL="postgres://signet:signet@localhost:5432/signet_test" \
  cargo t -p signet-cold-sql --features test-utils

# 3. Tear down
docker compose down