~/About~/Systems~/Foundry~/Blueprint~/Journal~/Projects
Book a Call

The Blueprint

Master specifications, system topologies, and architectural briefs. The technical entry point for every system.

Showing 22 entries

Architecture briefs compared by topology, constraints, decision records, and implementation signals.

+63 more tags inside entries

Scenario runs freeze planning data before JuMP touches it. PostgreSQL holds audit truth while DuckDB keeps backtests off the OLTP path.

juliaoptimizationsupply-chain
System TopologyInfrastructure DecisionsConstraintsDecision Log

May 2026

4 min read

Open entry

Fourteen document families share one renderer, while invoices, credit notes, pro-forma invoices, and resolutions keep separate service paths.

typescriptfastifypostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

May 2026

6 min read

Open entry

Carrier polling can return duplicates, stale events, and malformed payloads. The gateway keeps Postgres as the record and Redis as delivery.

typescriptfastifypostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

May 2026

6 min read

Open entry

Six upstream exception sources feed one tenant-scoped queue. Disabled adapters, explicit correlation, and frozen audit exports keep the core independent.

clojurepedestaldatomic
System TopologyInfrastructure DecisionsConstraintsDecision Log

May 2026

6 min read

Open entry

Penalty money needs replayable math, paired ledger rows, and disabled external clients by default. F# keeps calculation pure while Postgres owns the record.

fsharpdotnetpostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

May 2026

6 min read

Open entry

Alert history must be byte-identical six months later, even after tenant renames and vendor merges. Frozen JSONB snapshots make audit reprints trustworthy.

rubyrailspostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

8 min read

Open entry

AI-extracted obligations always land in Pending, never Active. Four terminal states answer four different audit questions across 41 endpoints.

csharpdotnetpostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

9 min read

Open entry

PO, receipt, and invoice never reconcile on first pass. Five resolution strategies with decaying confidence route matches to auto-approve or human queue.

kotlinktorpostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

8 min read

Open entry

Rust on Tokio sustains 5,000 sensor readings per second inside 512MB. Anomaly detection runs post-flush so HTTP timeouts can't stall the ingest loop.

rusttimescaledbnats
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

5 min read

Open entry

Eight subscription states with 15 valid transitions enforced in Elixir. OTP supervisors restart crashed processors; Oban handles retries on Postgres.

elixirphoenixoban
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

6 min read

Open entry

Real-time slot computation under 500ms across 5 providers and 8 rooms. Double-bookings blocked by a Postgres unique constraint, not application checks.

pythonfastapipostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

5 min read

Open entry

Immutability enforced at the code layer: no UPDATE or DELETE methods on the ledger table. BIGSERIAL ordering makes tampering structurally detectable.

gopostgresqlnats-jetstream
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

7 min read

Open entry

Webhooks persist before anything touches them. Two-layer SSRF protection blocks creation-time lookups and re-resolves DNS on every delivery.

typescriptfastifypostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

6 min read

Open entry

DAGs with runtime branching via mutable skip sets instead of tangled edges. Jinja2 sandboxing isolates user expressions from the Python runtime.

pythonfastapipostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

5 min read

Open entry

Kafka consumer sits behind a USE_KAFKA flag because Redpanda burns 150MB on a 1GB VPS. Direct HTTP ingestion and Kafka converge on one pipeline.

typescriptfastifypostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Apr 2026

6 min read

Open entry

Neo4j made optional because it won't fit in a 1GB VPS. Hybrid retrieval weighs vector, keyword, and graph at 0.7, 0.2, 0.1 with graceful degradation.

pythonfastapipostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Mar 2026

6 min read

Open entry

Transaction Reconciliation Engine

Money as int64 cents, never floats. Two-tier Redis plus Postgres dedup with owner-verified Lua lock release across every gateway-ledger pair.

GoPostgreSQLfintech
System TopologyInfrastructure DecisionsConstraintsDecision Log

Mar 2026

5 min read

Open entry

PostgreSQL logical replication pulls 79 tables from four service databases into two materialized views. Refresh cadence caps scale at 50,000 properties.

postgresqllogical-replicationsupabase
System TopologyInfrastructure DecisionsConstraintsDecision Log

Mar 2026

6 min read

Open entry

BeautifulSoup instead of Playwright to stay under a 200MB Docker image. Celery workers self-kill at 450MB so one stuck job never drains the pool.

djangocelerypostgresql
System TopologyInfrastructure DecisionsConstraintsDecision Log

Mar 2026

7 min read

Open entry

NBA game logs only exist for games a player appeared in. A two-stage model splits DNP classification from minutes regression to escape the survivor bias.

pythonscikit-learnsqlite
System TopologyInfrastructure DecisionsConstraintsDecision Log

Mar 2026

5 min read

Open entry

Thirteen suppliers send thirteen different CSV and XLSX formats. Per-supplier cleaners plus a two-pass matcher hit 99.5% coverage on 4,162 variants.

pythonshopify-graphqlpandas
System TopologyInfrastructure DecisionsConstraintsDecision Log

Mar 2026

5 min read

Open entry

Get Notified

New system breakdown? You'll know first.