Jordan’s Toolkit
GitHub
← All categories

Data & State

Protect database invariants, evolve schemas, reconcile jobs, and account for usage consistently.

Browse the collection

4 entries

Showing 4 entries

Original

PostgreSQL Transaction Boundaries

Implement database invariants with explicit transaction ownership, isolation decisions, constraint-backed concurrency control, and retry-safe effects.

Dataexperimental
Original

PostgreSQL Migration Safety

Test schema changes against populated prior versions, rolling application compatibility, locks/backfills, and explicit recovery rather than clean-install success alone.

Dataexperimental
Original

Usage Metering Idempotency

Account for usage through stable event identities, explicit precision and settlement policy, duplicate protection, adjustments, and replayable reconciliation.

Security and stateexperimental
Original

Async Job State Machines

Model durable jobs with legal transition authority, stable operation/attempt identity, guarded effects, cancellation races, and recoverable indeterminate outcomes.

Security and stateexperimental