// Articles
Guides, tutorials, and comparisons to help you build better backend applications.
A neutral comparison of schema migration tools for Postgres and other SQL databases, covering versioned vs declarative migrations, rollbacks, licensing and ORM-coupled tools like Prisma Migrate and Drizzle Kit.
Authentication checks who is calling, authorization decides what they may do. How the two fit together in a backend API, the common models for each, and TypeScript code for both.
Both are open source backend platforms with auth, a database, storage and functions, available as a managed cloud or self-hosted. They differ most in the database model and how much SQL you write.
How fixed window, sliding window, token bucket and leaky bucket limiters work, what to return when a client is over the limit, and how to enforce one limit across every instance of a TypeScript API.
Testing Go database code against a real Postgres instead of mocks: Testcontainers, template databases with pgtestdb, a shared Compose database, and encore test with a fully migrated database per test.
Four ways to get a local Postgres for your app: started automatically by Encore, Docker Compose, Homebrew or Postgres.app, and Testcontainers, with the PostgreSQL 18 Docker volume change that loses data if you miss it.
Verifying X-Hub-Signature-256 over the raw body, answering within GitHub's 10-second limit, deduplicating redeliveries by X-GitHub-Delivery and doing the work from a queue, with tested code that deploys to your own AWS or GCP account.
Verifying the Stripe-Signature header with stripe-go, avoiding the API version mismatch error, acknowledging fast and deduplicating retries, with tested code that deploys to your own AWS or GCP account.
Options for teams whose Cloud Run functions have grown into a backend, compared on time limits, local development, databases and queues, and where the code runs.
Backends for teams that started on PocketBase, compared on database, scaling, extensibility in Go and TypeScript, and where the backend runs.
Job queues and workflow tools for Node.js and TypeScript teams, compared on what they run on, how retries and scheduling work, and what you operate in production.
HashiCorp deprecated CDK for Terraform in December 2025. These are the options for teams that still want infrastructure in a programming language, compared on migration effort, scope and day-to-day workflow.