/postgres
Posts touching postgres.
15 posts
- March 22, 2026 5 min
Why every fintech startup eventually builds its own ledger
FinanceOps started with a third-party ledger. Within 18 months we built our own. Ledger semantics are too coupled to business rules for abstraction.
- /fintech
- /financeops
- /architecture
- /postgres
- /blog
- February 2, 2026 5 min
Drizzle ORM crossed 32K stars and I still think ORM choice barely matters
Query patterns, migration discipline, and connection pooling matter far more than which ORM you choose. The ORM was never the bottleneck.
- /postgres
- /typescript
- /architecture
- /decision-making
- /blog
- January 26, 2026 4 min
Why I run my portfolio site on the same stack I use at work
Next.js, Payload CMS, PostgreSQL, Cloudflare. Not laziness. Every problem solved on the portfolio feeds back into production expertise.
- /architecture
- /typescript
- /react
- /postgres
- /career
- December 22, 2025 5 min
Building a fintech reconciliation engine that handles ten million transactions a day
PostgreSQL partitioned tables, Node.js worker pools, idempotent batch processing, and a custom diffing algorithm. Sub-minute reconciliation at ten million daily transactions.
- /fintech
- /financeops
- /postgres
- /architecture
- /node
- November 10, 2025 5 min
The Prisma-to-Drizzle migration we almost did and why we stayed on Prisma
We built a prototype, benchmarked it, and stayed on Prisma because the migration cost exceeded the performance gain for our actual query patterns.
- /postgres
- /typescript
- /architecture
- /financeops
- /learning
- September 24, 2025 5 min
What payment reconciliation systems teach you about distributed consistency
Eventual consistency in payment reconciliation is a business requirement, not a technical compromise. Idempotency keys and reconciliation windows replaced two-phase commits.
- /fintech
- /financeops
- /architecture
- /postgres
- /blog
- March 3, 2025 5 min
Postgres connection pooling: the problem you do not know you have until you have 50 concurrent users
Our Node.js API opened a new PostgreSQL connection per request. At 50 concurrent users we exhausted the connection limit and the whole system halted. PgBouncer fixed it.
- /postgres
- /architecture
- /node
- /financeops
- /blog
- November 4, 2024 4 min
The day our monolith's database hit 80% CPU and nobody noticed until sales called
A slow query compounded by a missing index took our PostgreSQL instance to the brink. Sales noticed before engineering did because client reports were timing out.
- /postgres
- /observability
- /architecture
- /financeops
- /experience
- September 25, 2024 4 min
The night our database ran out of connections and what I learned about pooling
At 2am our payment processing froze. Every database connection was consumed by long-running report queries sharing a pool with transactions.
- /postgres
- /node
- /architecture
- /fintech
- /experience
- September 11, 2024 4 min
PostgreSQL 17 just dropped and COPY performance alone makes the upgrade worth it
PostgreSQL 17 shipped with 2x COPY performance, JSON_TABLE, and MERGE with RETURNING. The COPY improvement cut our nightly import from 12 minutes to under 6.
- /postgres
- /fintech
- /architecture
- /blog
- August 14, 2024 4 min
The PostgreSQL query that took 47 seconds and how I got it to 3 milliseconds
A financial report query joined five tables across 2 million rows and took 47 seconds. The fix was not adding an index.
- /postgres
- /architecture
- /fintech
- /blog
- July 10, 2024 4 min
Building a payment reconciliation engine that catches every penny
When your product handles financial transactions, close enough is not a rounding strategy. Here is the three-way reconciliation engine I built.
- /fintech
- /financeops
- /postgres
- /architecture
- /blog
- June 12, 2024 4 min
How I use PostgreSQL as a job queue and why you probably should too
Every guide says use Redis or BullMQ for background jobs. I used PostgreSQL SKIP LOCKED and it handled thousands of jobs per day with zero additional infrastructure.
- /postgres
- /node
- /architecture
- /fintech
- /blog
- May 8, 2024 4 min
Designing a multi-tenant PostgreSQL schema that does not make you cry at 3am
Shared database, shared schema, row-level security. That was the bet. Here is how it played out.
- /postgres
- /architecture
- /fintech
- /api-design
- /blog
- April 3, 2024 4 min
Why I chose PostgreSQL over MongoDB and how it shaped our entire fintech stack
Every fintech startup I talked to was defaulting to MongoDB. I went the other way and bet on PostgreSQL with strict schemas from day one.
- /postgres
- /architecture
- /fintech
- /decision-making
- /experience