All Articles

Backend

Transaction Isolation Levels, Write Skew and SSI

Learn what each transaction isolation level allows, how PostgreSQL implements Read Committed and Repeatable Read, why write skew slips past row locks, and how SSI makes SERIALIZABLE safe.

Sep 24, 202610 min read

Backend

Hexagonal Architecture in Go: Ports and Adapters Explained

Learn hexagonal architecture (ports and adapters): keep the domain at the center, define driving and driven ports, write HTTP and Postgres adapters in Go, test with fakes, and know when it's overkill.

Sep 24, 202610 min read

Backend

Go Quickselect and Sorting: slices.Sort to Top-K in O(n)

Learn sorting in Go with sort and slices, frequency counting with maps, Lomuto partition and quicksort, then Go quickselect to find the k-th element and top-k frequent values in O(n) average time.

Sep 24, 202610 min read

DevOps

Kubernetes Operator and CRDs: Build a Reconcile Loop in Go

Learn how a Kubernetes operator works: define CRDs, write a controller with a level-triggered reconcile loop, and build a small database operator in Go with kubebuilder, plus a kopf example.

Sep 24, 202610 min read

DevOps

Kubernetes Probes and CrashLoopBackOff: A Debugging Guide

Learn what CrashLoopBackOff really means, how liveness, readiness and startup probes work, and a step-by-step routine to debug it with describe, logs --previous, events and exit codes.

Sep 24, 202610 min read

Backend

OLTP vs OLAP: Database Types and How to Choose

OLTP vs OLAP explained: relational, object-relational and NoSQL database families, transactional vs analytical workloads, row vs column storage, and how to choose a database.

Sep 24, 202611 min read

Backend

ACID and MVCC Explained with a Bank Transfer Example

ACID and MVCC explained with a bank transfer: what atomicity, consistency, isolation and durability mean in PostgreSQL, and how MVCC lets readers and writers run without blocking.

Sep 24, 202611 min read

Backend

PostgreSQL Storage Internals: Pages, Tuples and TOAST

PostgreSQL storage internals explained: 8KB pages, tuple headers, 1GB segment files and TOAST, a worked sizing example for 5 million rows, and the data directory layout.

Sep 24, 202612 min read

Backend

PostgreSQL Architecture: Processes, Memory and WAL

How PostgreSQL architecture works: the postmaster, one backend per connection, pg_hba.conf auth, shared buffers, WAL, work_mem, and what each background process does.

Sep 24, 202611 min read

Showing 28-36 of 65 articles

Ready to build something great?

Tell us about your project — we'll help you get there.

Start a Project