All Articles

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

Backend

Go Slices, Maps and Pointers: How Data Really Moves

A practical guide to Go slices, maps and pointers: arrays vs slices, len, cap and append, nil vs empty slices, map gotchas, and what pass by value really copies in Go 1.22+.

Sep 24, 202610 min read

Backend

Go Strings, Bytes and Runes: UTF-8 Text Done Right

Understand Go rune vs byte vs string: why len counts bytes, how UTF-8 and Thai text work, ranging over strings, strconv, strings.Builder, plus data types, const and iota.

Sep 24, 202610 min read

Backend

Go Interfaces, Structs and Methods: A Practical Guide

Learn how Go interfaces, structs and methods fit together: value vs pointer receivers, implicit implementation, any, type assertions, type switches and the nil interface trap.

Sep 24, 202610 min read

Backend

Running Databases in Production: Pooling, Maintenance, Partitioning, and Backups

Fast queries are only part of a healthy database. This guide covers the operational side: sizing connection pools, keeping vacuum and statistics healthy, partitioning large tables, planning capacity, and designing backups you have actually tested restoring.

Sep 24, 20266 min read

Backend

Go Concurrency in Production: Goroutines, Channels, and Knowing When to Stop

Starting a goroutine takes one keyword. Shutting it down cleanly, capping how many run at once, and making sure none leak takes design. This article covers the patterns we use for concurrent Go services that stay predictable under load.

Sep 24, 20265 min read

Showing 19-27 of 35 articles

Ready to build something great?

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

Start a Project