#postgresql

11 posts RSS

Postgres as a Queue with SKIP LOCKED

A background job lands in your jobs table. Two workers wake up at the same time, both run SELECT FROM jobs WHERE status = 'pending…

Jul 3, 2026 7 min read

Your API is humming along at 200 requests per second. Traffic doubles during a launch, you scale your Node.js service from 4 pods…

Jul 2, 2026 8 min read

A support engineer runs a quick query to debug a customer complaint. She forgets one WHERE tenant id = $1 . The dashboard now show…

Jul 1, 2026 7 min read

A customer pays 100.00. Your database records a 100.00 sale, marks the order paid, ships the goods. Two days later the money lands…

Jun 30, 2026 7 min read

A user places an order. Your service opens a transaction, writes the row to Postgres, commits, and then calls broker.publish("orde…

Jun 29, 2026 7 min read

A customer taps "Pay." The request reaches your server, the charge succeeds, and then the response times out on the way back. The…

Jun 27, 2026 7 min read

With real-world Docker Compose setups, GitHub Actions CI pipelines, and practical command recipes. Everything you need to master D…

Jul 23, 2025 5 min read

In the world of SaaS, designing for scale starts with multi-tenancy done right. Why Multi-Tenant Architecture Matters SaaS is all…

Jul 11, 2025 2 min read

In this blog post, we will walk you through the process of setting up a task manager application using NestJS and RabbitMQ. This a…

Oct 22, 2024 3 min read

Introduction In this post, I'll demonstrate how to include Traefik Proxy — a cloud native application proxy — in our Docker Compos…

Nov 29, 2022 5 min read

Introduction In this article, we're going to discuss the differences between stored procedures and functions. Before we begin comp…

Sep 19, 2022 3 min read