Backend
July 202610 min read
Integrating Midtrans Snap Payments into a Next.js App
A hands-on guide to wiring Midtrans Snap into Next.js: server-side token creation, the Snap popup, and a webhook that verifies the SHA512 signature key.
Read More
Blog
Backend & APIs
Articles on backend architecture, API design, and database patterns — NestJS, PostgreSQL, and building reliable server-side systems.
40 articles
Backend
July 202610 min read
Dynamic QRIS Payment Integration in Node.js: The Complete Guide
Static vs dynamic QRIS, generating a dynamic QR through a licensed PSP, the MPM flow, webhook handling, NMID onboarding, and 2025 MDR fees — a hands-on Node.js guide.
Read More
Backend
July 202610 min read
Integrating the Official WhatsApp Business Cloud API in Indonesia
How I wire up message templates, webhooks, the 24-hour window, and per-message pricing with the official WhatsApp Cloud API for Indonesian apps.
Read More
Backend
July 20269 min read
Bun vs Node.js as a Production Runtime in 2026
Bun and Node.js are closer than the benchmarks suggest in 2026 — here is where each actually wins in production, from startup to native addons.
Read More
Backend
July 20269 min read
Drizzle ORM vs Prisma for TypeScript Backends
SQL-first or schema-first? A hands-on comparison of bundle size, edge support, and migrations for the two ORMs I actually ship on.
Read More
Backend
July 20269 min read
Hono: One API Codebase for Workers, Bun, and Node
How Hono lets me write one Web-Standards API and run it unchanged on Cloudflare Workers, Bun, and Node — plus typed RPC with zero codegen.
Read More
Backend
July 20269 min read
NATS JetStream vs Kafka for Teams That Do Not Need Kafka's Scale
Kafka is the reflexive answer to "we need a message log," but for workloads under a million messages per second, NATS JetStream gives you durable streams and solid delivery guarantees with a fraction of the operational cost.
Read More
Backend
July 20269 min read
Request-Scoped Providers in NestJS: DI Gotchas
Request-scoped providers look like a one-line fix, but scope bubbles up your whole DI graph and costs latency. Here is how it works and why I reach for AsyncLocalStorage first.
Read More
Backend
July 20269 min read
End-to-End Type Safety with openapi-typescript
Delete your hand-written API interfaces and generate them from the OpenAPI spec instead — how openapi-typescript and openapi-fetch give you a typed client and catch backend drift at compile time.
Read More
Backend
July 20269 min read
Distributed Tracing in NestJS with OpenTelemetry Auto-Instrumentation
How I added distributed tracing to a NestJS API with OpenTelemetry auto-instrumentation — the SDK setup, context propagation, and exporting spans to a collector.
Read More
Backend
July 20269 min read
Zero-Downtime PostgreSQL Major Upgrades with Logical Replication
How to move a live PostgreSQL database to a new major version with sub-second downtime using publications and subscriptions — and the sequence, large-object, and DDL gaps that will bite you at cutover if you forget them.
Read More
Backend
July 20269 min read
Server-Sent Events vs WebSockets for Realtime
When one-way SSE beats a full WebSocket, how reconnection and HTTP/2 change the math, and how I actually choose per use case.
Read More
Backend
July 20269 min read
Why My ERP Cash Book Is a Derived Postgres UNION View
How I killed a drift-prone ledger table and rebuilt the JID Carwash cash book as a derived Postgres UNION view over payments, expenses, and kasbon.
Read More
Backend
July 20269 min read
Why We Store Money as Integer Rupiah, Never Float
Why the JID Carwash ERP stores every rupiah as an integer, never a float — and the end-of-day reconciliation bug that made the rule non-negotiable.
Read More
Backend
July 20269 min read
Idempotency Keys That Stop a POS From Double-Charging
How I made carwash POS payment settlement safe against double-taps and network retries using idempotency keys, a Postgres unique constraint, and one guard spec test.
Read More
Backend
July 20269 min read
Inventory Truth: A Stock Movement Ledger, Not a Column
Why I made SUM of an append-only StockMovement ledger the source of truth in my carwash ERP, and treated Product.stockQty as a cache I rebuild.
Read More
Backend
July 202610 min read
Integrating Shopee and Tokopedia Seller APIs
How I build seller-side middleware that keeps one inventory source of truth across Shopee Open Platform and Tokopedia (TikTok Shop) APIs.
Read More
Backend
July 202610 min read
Xendit vs Midtrans: Which Payment Gateway to Pick in Indonesia
A hands-on backend comparison of Xendit and Midtrans for Indonesian payments — payment methods, fees, DX, and disbursement.
Read More
Backend
July 20269 min read
The Expand/Contract Pattern for Safe Schema Migrations
How to rename or restructure a live database column with zero downtime by keeping old and new columns running side by side through a five-step rollout.
Read More
Backend
July 20269 min read
The Idempotent Consumer Pattern for Message Queues
Your broker delivers at-least-once, so duplicates are guaranteed. Here is how a processed-messages table turns that into exactly-once effects.
Read More
Backend
July 20269 min read
PgBouncer Pooling Modes: Session vs Transaction vs Statement
The three PgBouncer pooling modes, the prepared-statement trap that bit me in transaction mode, and how to actually size pool_size for a real app.
Read More
Backend
July 20269 min read
Reading PostgreSQL EXPLAIN ANALYZE Like a Pro
How I read PostgreSQL EXPLAIN ANALYZE output: seq scan vs index scan, nested loop vs hash join, buffers, and how to find the node that is actually slow.
Read More
Backend
July 20269 min read
PostgreSQL Generated Columns for Computed Data
When to push derived logic into STORED generated columns, how to index them, and the constraints that bite you in production.
Read More
Backend
July 20269 min read
Running SQLite in Production with Litestream
Continuous streaming replication to object storage, point-in-time restore, and the honest limits of single-node SQLite on a VPS.
Read More
Backend
July 20269 min read
Valkey vs Redis: Should You Migrate After the Fork?
The license drama split the ecosystem in two. Here is what actually changed, how drop-in the swap really is, and whether it is worth your weekend.
Read More
Backend
July 202611 min read
Saga Pattern in NestJS: Distributed Transactions Without 2PC
How to coordinate multi-service transactions in NestJS using the saga pattern, orchestration vs choreography, compensating actions, and idempotent step design.
Read More
Backend
July 20269 min read
A Reliable Job Queue in PostgreSQL with SKIP LOCKED
How SELECT FOR UPDATE SKIP LOCKED turns a plain table into a concurrent job queue with no double-processing, and where a real broker still wins.
Read More
Backend
July 202610 min read
The Transactional Outbox Pattern with PostgreSQL
Reliably publish domain events without dual-write bugs, using an outbox table, a relay poller, and PostgreSQL's row-level locking.
Read More
Backend
July 202610 min read
Designing Reliable Webhooks: Retries, Signing, and Replay
A practical blueprint for webhooks your consumers can actually trust: HMAC signing, at-least-once delivery with backoff, idempotency keys, and a replayable event log.
Read More
Backend
July 20269 min read
Feature Flags in NestJS: Progressive Rollouts and Kill Switches
How to add feature flags to a NestJS backend for percentage rollouts, per-tenant targeting, and kill switches, without letting flag debt pile up.
Read More
Backend
July 202611 min read
Testing NestJS Applications: Unit, Integration, E2E Guide
A practical walkthrough of testing NestJS apps at three layers — mocked-provider unit tests, real-database integration tests, and supertest-driven end-to-end tests.
Read More
Backend
July 202610 min read
Zero-Downtime Database Migrations with Prisma
Ship schema changes without taking your app offline, using the expand-contract pattern with Prisma: backfills, dual-write windows, and safely dropping old columns.
Read More
Backend
July 202610 min read
PostgreSQL Row-Level Security for Multi-Tenant SaaS
How to enforce tenant isolation inside the database itself with PostgreSQL row-level security, session variables, and tests that actually prove isolation holds.
Read More
Backend
June 202610 min read
NestJS Custom Decorators: Metadata, Reflector & Guards
The mental model most NestJS tutorials skip: decorators just attach metadata, and guards read that metadata back at request time with Reflector. Once that clicks, custom decorators stop feeling like magic.
Read More
Backend
June 202610 min read
I Built an npm Library for ERP Hierarchical Approval Workflows
After rebuilding multi-level approval workflows three times across ERP projects, I extracted the pattern into an open-source TypeScript npm library.
Read More
Backend
June 20269 min read
NestJS Health Checks with Terminus for Kubernetes & Docker
A practical walkthrough of building liveness and readiness probes in NestJS with the official @nestjs/terminus package, wired into real Docker and Kubernetes configs.
Read More
Backend
April 202610 min read
Reliable Background Jobs with BullMQ and NestJS
Retries, exponential backoff, dead-letter queues, and monitoring: a production blueprint for background jobs with BullMQ, Redis, and NestJS that survives bad days.
Read More
Backend
April 202610 min read
Idempotency Keys: Designing APIs That Survive Retries
Double-charged payments start with a timeout and a retry. How to design idempotent endpoints with idempotency keys, from storage schema to client behavior.
Read More
Backend
April 202611 min read
PostgreSQL Indexing in Practice: B-tree, GIN, and Partial Indexes
A practical PostgreSQL indexing guide: when B-tree, GIN, BRIN, and partial indexes win, how to read EXPLAIN ANALYZE, and the real numbers behind a 170x speedup.
Read More
Backend
December 202511 min read
Indonesia SNAP API & QRIS 2.0: Developer Guide to Open Banking Integration
Bank Indonesia's SNAP (Standar Nasional Open API Pembayaran) is now mandatory for all licensed payment service providers. This guide covers OAuth 2.0 authentication, HMAC-SHA512 request signing, QRIS 2.0 cross-border payments, and practical Node.js implementation patterns for Indonesian fintech developers.
Read More