APIs
Filtering and Sorting in Go APIs Without SQL Injection
Build filter and sort parameters for a Go API from an allowlist: bound values, mapped columns, escaped LIKE wildcards and a blind injection through ORDER BY.
13 min read
Topic
Databases
Talking to Postgres, MySQL, SQLite, Redis and friends without leaking connections, hand-building queries or fighting your migrations.
APIs
Cache API Responses in Go With Redis and Invalidate Safely
Cache API data in Redis from Go: cache-aside with singleflight, a version fence against stale writes, namespace versions for lists and TTL jitter, on Redis 8.
16 min read
Editor's pick
APIsGuide
Design and Build a JSON API in Go That Stays Maintainable
Build a JSON API in Go from a written contract: standard routing, one error format, strict decoding, validation, cursor paging, PATCH, auth and tests.
39 min read
Web
Build a Pastebin Clone in Go With Expiring Share Links
Build a pastebin in Go on SQLite with unguessable IDs, expiry, burn after read that survives link previews, delete tokens and output that cannot run scripts.
20 min read
APIs
Partial Updates in Go APIs With PATCH and Pointers
Implement PATCH in a Go API with merge-patch semantics: tell absent, null and zero apart, apply only the keys sent and reject bad patches before any SQL runs.
12 min read
Web
Build a URL Shortener in Go With Tests and a Database
Build a URL shortener in Go on SQLite with random base62 codes, collision retries, custom aliases, expiry, hit counting and tests for the awkward cases.
19 min read
APIs
Pagination in Go APIs With Offset Cursor and Keyset
Paginate a Go API with offset, keyset and signed cursors on SQLite: duplicates under inserts, rows lost on tied keys, and 7.9 ms against 31 µs at depth.
15 min read
APIs
Quotas and Usage Metering in Go APIs Done Correctly
Meter API usage and enforce quotas in Go: an atomic conditional UPDATE, idempotent events, weighted routes, refunds for 5xx, UTC periods and reconciliation.
18 min read
APIs
Bulk Endpoints in Go APIs and Handling Partial Failure
Design bulk endpoints in Go: atomic versus partial modes, per-item results by index, savepoints, idempotent refs, limits, and 100 creates in 1.2 ms not 18.
16 min read
APIs
Build a CRUD REST API in Go With the Standard Library
Build a CRUD API in Go with the standard library: a natural key, PUT upserts, ETag and If-Match locking, and a store contract tested on memory and SQLite.
22 min read
Web
Add Server Side Search to a Go Website Without Elastic
Add full-text search to a Go site with SQLite FTS5: stemming, bm25 ranking, highlighted snippets, search as you type and safe handling of raw user queries.
15 min read
Get new articles by email
We send one email when a new article is published. No spam.