in this category

Backend Development

Server-side development, APIs, databases, Node.js, Python, microservices, and backend architecture

66 posts

Postgres Dead Tuples Not Being Removed: Fixes (2026)

Backend DevelopmentAugust 27, 2026

Postgres dead tuples not being removed? VACUUM can only delete rows older than the xmin horizon. Here is how to find what holds it back, and how to fix it.

#postgresql #vacuum

BullMQ Worker Not Processing Jobs? Fix It (2026)

Backend DevelopmentAugust 3, 2026

BullMQ worker not processing jobs? Work through queue name and prefix, maxRetriesPerRequest, stalled-job locks, and the v6 ioredis peer dependency change.

#bullmq #redis

Postgres MERGE RETURNING: Old and New Values (2026)

Backend DevelopmentJuly 2, 2026

Postgres 18 lets MERGE RETURNING return old and new row values in one query. See merge_action(), the xmax alternative, and verified Node.js/TypeScript code.

#postgresql #postgres 18

Correlation IDs in Node.js with AsyncLocalStorage (2026)

Backend DevelopmentJuly 1, 2026

Add a correlation ID to every log line in Node.js with built-in AsyncLocalStorage and Express — typed, zero-dependency, plus pino and downstream propagation.

#asynclocalstorage #correlation-id

Node.js Circuit Breakers with opossum + TypeScript (2026)

Backend DevelopmentJune 30, 2026

Build a production Node.js circuit breaker in TypeScript with opossum: closed, open, half-open states, fallbacks, errorFilter, timeouts, and verified output.

#node.js #circuit breaker

Postgres Row-Level Security for Multi-Tenant Apps (2026)

Backend DevelopmentJune 27, 2026

Implement Postgres row-level security for multi-tenant apps with node-postgres: enable RLS, write current_setting policies, and avoid the pool-leak footgun.

#postgres #row-level security

Drizzle ORM Relational Queries: db.query Guide (2026)

Backend DevelopmentJune 24, 2026

Query nested relations in Drizzle ORM with db.query and the with operator: filter and limit child rows, run many-to-many joins, plus the v1 vs v2 changes.

#drizzle orm #relational queries

tRPC v11 End-to-End Type Safety: Server + Client (2026)

Backend DevelopmentJune 22, 2026

Build a fully type-safe tRPC v11 API in TypeScript: a standalone server, a vanilla client, Zod validation, and error handling. No framework, all runnable.

#trpc #trpc v11

Postgres 18 UUIDv7 Primary Keys: Practical Guide (2026)

Backend DevelopmentJune 17, 2026

Use Postgres 18's built-in uuidv7() for primary keys: default DDL, uuidv7 vs uuidv4 vs bigint, migrating off uuidv4, and the timestamp-leak caveat to know.

#postgres #postgresql 18

Valkey with Node.js and TypeScript: 2026 Setup Guide

Backend DevelopmentJune 16, 2026

Connect Valkey from Node.js and TypeScript with the iovalkey client: Docker setup, typed caching, pipelines, pub/sub, error handling, and graceful shutdown.

#valkey #node.js

gRPC in Node.js and TypeScript: Production Guide (2026)

Backend DevelopmentJune 14, 2026

Build a typed, production gRPC service in Node.js and TypeScript: server streaming, deadlines, the error model, and health checks. Runnable 2026 guide.

#grpc #node.js

Postgres LISTEN/NOTIFY for Job Queues: 2026 Guide

Backend DevelopmentJune 11, 2026

Should you use Postgres LISTEN/NOTIFY for a job queue? The global commit lock, 8000-byte payload cap, PgBouncer limits, and safer SKIP LOCKED patterns.

#postgres #listen notify

Cursor Pagination in Postgres with Node.js (2026)

Backend DevelopmentJune 10, 2026

Build fast cursor pagination on Postgres with Node.js and TypeScript: keyset queries, a compound (created_at, id) tiebreaker, and opaque base64url cursors.

#cursor pagination #keyset pagination

Idempotency Keys for a Node.js API with Postgres (2026)

Backend DevelopmentJune 6, 2026

Make POST and PATCH retry-safe. Build a production idempotency-key layer in TypeScript on Node 24 with Fastify 5 and Postgres 18: atomic claims, 409s, replays.

#idempotency #postgres

NATS JetStream Worker in TypeScript: Retries & DLQ (2026)

Backend DevelopmentJune 2, 2026

Build a durable NATS JetStream worker in TypeScript on Node 24: create a stream, a pull consumer with explicit acks, backoff retries, and a dead-letter queue.

#nats #jetstream

Drizzle ORM + pg-boss Atomic Transactions Tutorial (2026)

Backend DevelopmentMay 31, 2026

Send Postgres-backed pg-boss 12 jobs inside a Drizzle ORM transaction with the fromDrizzle adapter, retries, dead letters, and cron schedules.

#pg-boss #drizzle-orm

Fail-Open vs Fail-Closed Middleware: Hono + Redis (2026)

Backend DevelopmentMay 28, 2026

Build resilient Hono middleware that fails open or fails closed when Redis is down: auth, feature flags, rate limits, plus a typed TypeScript circuit breaker.

#resilience #hono

API Rate Limiting with Upstash Redis: 2026 Node Tutorial

Backend DevelopmentMay 24, 2026

Add production rate limiting to a Node.js API with Upstash Redis sliding windows: reusable Hono middleware, 429 + Retry-After headers, multi-tier limits.

#rate limiting #upstash

pg_partman + pg_cron: Postgres 18 Auto Partitions (2026)

Backend DevelopmentMay 20, 2026

Tutorial: install pg_partman 5.4.3 + pg_cron on Postgres 18.4, configure daily range partitions with retention, automate maintenance, troubleshoot.

#pg_partman #pg_cron

pg-boss Tutorial: Postgres Job Queue in Node 24 (2026)

Backend DevelopmentMay 15, 2026

Production pg-boss tutorial. Queue jobs in Postgres from Node.js 24 with TypeScript, retries, dead-letter queues, cron, and graceful shutdown.

#pg-boss #postgres

Postgres 18 Zero-Downtime Upgrade: pg_createsubscriber 2026

Backend DevelopmentMay 13, 2026

Upgrade Postgres 17 to 18.3 with zero downtime using pg_createsubscriber and logical replication. Docker walkthrough with sequences, cutover, rollback.

#postgres #postgresql

htmx Tutorial: TypeScript Express Live Kanban (2026)

Backend DevelopmentMay 9, 2026

Build a production htmx kanban with TypeScript, Express 5, and SSE live updates. 2026 step-by-step tutorial—real code, no React, every version pinned.

#htmx #typescript

Production Postgres Pooling: PgBouncer + Supavisor 2026

Backend DevelopmentMay 7, 2026

Hands-on 2026 guide: PgBouncer 1.25.1 in front of Postgres 18, then swap to Supabase Supavisor — transaction pooling, prepared statements, and pitfalls.

#postgres #postgresql

Postgres LISTEN/NOTIFY: Real-Time Presence Tutorial 2026

Backend DevelopmentMay 5, 2026

Hands-on 2026 tutorial: build a real-time online-presence system on Postgres 18 LISTEN/NOTIFY with Node.js, Express, and ws — no Redis, no broker, just SQL.

#postgres #postgresql

Python Best Practices: The 2026 Guide for Clean, Fast, and Secure Code

Backend DevelopmentMay 5, 2026

Python best practices for 2026: pyproject.toml, uv, Ruff, type hints, pytest, free-threaded 3.14, structured logging, and security patterns for clean, fast, shippable code.

#python #best practices

Distroless Python Containers with uv: 2026 Tutorial

Backend DevelopmentMay 4, 2026

Hands-on 2026 tutorial: build a tiny, secure Distroless Python container for a FastAPI app using uv 0.11.8, multi-stage builds, and a non-root runtime user.

#python #docker

Mastering Right Joins: Practical Applications and Real-World Insights

Backend DevelopmentJanuary 22, 2026

SQL RIGHT JOIN mastered: when to use it over LEFT JOIN, real reporting examples, edge cases in Postgres/MySQL/SQLite, and why it's rarely the right default.

#SQL #database joins

Text Processing Automation: Scripts to Scale

Backend DevelopmentJanuary 21, 2026

Learn how to automate text processing at scale using Python, modern tooling, and best practices for performance, security, and maintainability.

#text processing #automation

Mastering Server-Sent Events (SSE): Real-Time Updates Made Simple

Backend DevelopmentJanuary 18, 2026

Server-Sent Events (SSE) in 2026: one-way server→client streams over HTTP. Live dashboards, notifications, LLM streaming — when to pick SSE over WebSockets.

#server-sent events #real-time web

Mastering Unit Testing Strategies for Reliable Code

Backend DevelopmentJanuary 16, 2026

Unit testing for reliable code: isolation, determinism, mocking, dependency injection, and the test pyramid shape that actually survives a growing codebase.

#unit testing #software testing

Choosing the Right NoSQL Database: A Practical Guide

Backend DevelopmentJanuary 13, 2026

A deep, hands-on guide to selecting the right NoSQL database for your application — covering types, trade-offs, performance, security, and real-world use cases.

#NoSQL #databases

Integrating Cryptocurrency Platforms: A Complete Developer Guide

Backend DevelopmentJanuary 9, 2026

Learn how to integrate cryptocurrency platforms securely and efficiently — from architecture design to API integration, scalability, and monitoring.

#cryptocurrency #API integration

Building Real-Time, Low-Carbon DApps with Server-Sent Events

Backend DevelopmentDecember 30, 2025

Build real-time, low-carbon dApps with Server-Sent Events: cheaper than WebSockets, greener than polling, and plenty for collaboration and notification UIs.

#carbon footprint #real-time collaboration

Backend Architecture Patterns: From Monoliths to Microservices

Backend DevelopmentDecember 25, 2025

Backend architecture in 2026: monolith, modular monolith, microservices, serverless, event-driven. Trade-offs, failure modes, and how to evolve between them.

#backend architecture #microservices

Redis Caching Patterns: The Complete Guide for Scalable Systems

Backend DevelopmentDecember 12, 2025

Learn how to design, implement, and optimize Redis caching patterns for high-performance, scalable applications — from cache-aside to write-through and beyond.

#Redis #caching

SQLite Today: The Unsung Hero Powering Modern Apps

Backend DevelopmentDecember 11, 2025

SQLite in 2026, beyond embedded: edge compute, AI inference caching, local-first apps on Turso and Cloudflare D1. Why it's the database quietly powering 2026.

#SQLite #databases

Rust Systems Programming: Safety, Speed, and Real-World Power

Backend DevelopmentDecember 10, 2025

Rust for systems programming: ownership, borrowing, and zero-cost abstractions that deliver C-level speed with memory safety — and where it pays off in 2026.

#Rust #systems programming

Django Backend APIs: Scalable & Secure

Backend DevelopmentNovember 30, 2025

A deep dive into how Django powers modern backend APIs — from REST to GraphQL — with practical examples, performance insights, and production-ready practices.

#Django #Backend

Backend Web Development: The Complete 2025 Guide

Backend DevelopmentNovember 28, 2025

A deep, practical dive into backend web development — from architecture and APIs to scalability, security, and real-world production insights.

#backend development #web development

Mastering Full Stack Development with the MERN Stack

Backend DevelopmentNovember 28, 2025

A deep, practical guide to building, scaling, and securing full stack applications using MongoDB, Express, React, and Node.js — from architecture to deployment.

#MERN #Full Stack

Build a Lightweight Backend with PocketBase

Backend DevelopmentNovember 22, 2025

Build a lightweight backend with PocketBase: bundled database, auth, and admin UI in one binary. Local-first deploy, real-time subscriptions, and when it fits.

#PocketBase #backend development

Mastering JavaScript Async Patterns: From Callbacks to Concurrency

Backend DevelopmentNovember 11, 2025

JavaScript async patterns in 2026: callbacks → promises → async/await → structured concurrency. Event loop internals and real performance wins in practice.

#JavaScript #Async

Python Power Moves: Pro Tips for Your First Big Project

Backend DevelopmentNovember 10, 2025

Python power moves for your first real project: pyproject.toml, venvs, type hints, structured logging, tests, and the patterns that survive a year of growth.

#python #software engineering

SQL vs NoSQL Databases: Choosing the Right Data Backbone

Backend DevelopmentSeptember 26, 2025

SQL vs NoSQL in 2026: PostgreSQL, MySQL, MongoDB, Cassandra, DynamoDB. Consistency, schema flexibility, scaling, and when each actually fits your workload.

#databases #sql

Algorithms for Beginners: A Friendly Deep Dive

Backend DevelopmentSeptember 23, 2025

A comprehensive beginner's guide to algorithms, explained in a warm, approachable way with real examples, insights from Lisp, and step-by-step exploration.

#algorithms #beginners

Mastering the Coding Interview: A Complete Deep-Dive Guide

Backend DevelopmentSeptember 19, 2025

Prepare for coding interviews with this in-depth, friendly guide that covers strategies, pitfalls, and real-world insights into technical interviews.

#coding interview #software engineering

The Complete Guide to SQL: From Basics to Advanced Queries

Backend DevelopmentSeptember 18, 2025

SQL from beginner to advanced queries: CRUD, JOINs, subqueries, CTEs, Window Functions, indexes — covering Postgres, MySQL, and SQLite (most examples are portable; vendor-specific differences are noted where they apply).

#SQL #Database

The Complete Python Guide: From Basics to Best Practices

Backend DevelopmentSeptember 18, 2025

Python from scratch in 2026: variables, data types, control flow, functions, OOP, comprehensions, and the Pythonic patterns that separate beginners from pros.

#Python #Programming

Unlocking the Power of Backend Development: A Comprehensive Guide

Backend DevelopmentSeptember 18, 2025

Backend development in depth: servers, databases, APIs, auth, caching, and architectural choices that decide whether your app scales or buckles under load.

#Backend Development #Web Development

Web Development for Beginners: From Zero to Full Stack

Backend DevelopmentSeptember 18, 2025

Web development for beginners in 2026: HTML, CSS, JavaScript, Git, Node, then React and a backend. The shortest real path from zero to full-stack shipping.

#web development #frontend

Learn about API Development Types, Tools, and Best Practices

Backend DevelopmentApril 23, 2023

API development guide: REST, GraphQL, gRPC, tRPC compared. Auth flows, versioning, documentation, rate limits, and the patterns production teams actually use.

#API development #REST

A Full Guide: Understand Everything About APIs with Examples

Backend DevelopmentUpdated: September 16, 2025

APIs explained with diagrams: what an API is, REST vs. GraphQL vs. gRPC, auth flows, rate limits, and how integrations really work under the hood.

#API #REST

An Introduction to API Development

Backend DevelopmentUpdated: March 27, 2026

API development explained: REST, GraphQL, gRPC, and tRPC side by side. Auth, versioning, docs, and when to pick each — with a minimal working example.

#api #rest

Best Ways to Strip Punctuation From Strings in Python and Javascript

Backend DevelopmentUpdated: March 27, 2026

Remove punctuation from strings: Python translate(), regex, or unicodedata. JavaScript replace() with regex. Performance benchmarks and edge cases.

#python #javascript

Easy Hands on Guide how to get Started With SQL

Backend DevelopmentUpdated: March 27, 2026

SQL from zero — SELECT, JOIN, GROUP BY, window functions, CTEs. Hands-on exercises using real tables; works in Postgres, modern SQLite, and MySQL 8.0+.

#sql #database

Explain Dynamic Programming and Other Techniques With Examples

Backend DevelopmentUpdated: March 27, 2026

Dynamic programming with worked examples: memoization, tabulation, classic LeetCode patterns, and when DP beats greedy, divide-and-conquer, or brute force.

#algorithms #dynamic-programming

Project Euler Problems 1-5: Solutions With Math & Python

Backend DevelopmentUpdated: March 27, 2026

Project Euler problems 1-5: divisibility, Fibonacci, primes, palindromes, LCM. See brute-force vs optimized Python solutions with complexity analysis.

#project-euler #algorithms

Project Euler Problems 11-15: Grids, Divisors & Combinatorics

Backend DevelopmentUpdated: March 27, 2026

Solve Project Euler problems 11-15: grid products, divisors, Collatz sequences, lattice paths. Dynamic programming and combinatorics with Python code.

#project-euler #algorithms

Project Euler Problems 6-10: Primes, Squares & Sequences

Backend DevelopmentUpdated: March 27, 2026

Solve Project Euler problems 6-10 with Python: sums of squares, prime generation, digit products, Pythagorean triples, sieve algorithms. Full explanations.

#project-euler #algorithms

How to Start With Python the Basics for Absolute Beginners

Backend DevelopmentUpdated: March 27, 2026

Python for absolute beginners in 2026 — install Python 3.13+, use uv for packaging, write your first functions, and run real scripts with zero prior experience.

#python #programming-basics

Learn About API Development Types Tools and Best Practices

Backend DevelopmentUpdated: March 27, 2026

API types, tools, and best practices for 2026. REST vs. GraphQL vs. gRPC, OpenAPI, Postman, rate limiting, auth patterns, and observability that scales.

#api #rest

Practical SQL Guide an Overview of Where to Start With SQL

Backend DevelopmentUpdated: March 27, 2026

Practical SQL guide: where to start, what to learn first, and the core query patterns every developer uses. Core SQL is portable across Postgres, SQLite, and MySQL; vendor-specific extensions (JSONB, etc.) are flagged as such.

#sql #database

Python for all Ages an Accessible Guide for Beginners

Backend DevelopmentUpdated: March 27, 2026

Python for all ages: kids use Turtle graphics, teens build games, adults transition to data science. Accessible tools and resources for every learner.

#python #beginners

Python for Beginners: A Practical Guide

Backend DevelopmentUpdated: March 27, 2026

Master Python with best practices: type hints, virtual environments, modern tooling. Complete guide from setup to professional coding habits.

#python #beginners

Remove First and Last Character From String Python vs Javascript

Backend DevelopmentUpdated: March 27, 2026

Remove first and last characters from a string — Python slice vs. JavaScript slice/substring. Edge cases, Unicode handling, and TypeScript-typed examples.

#python #javascript

Web Scraping Learn how to use Tools and Techniques

Backend DevelopmentUpdated: March 27, 2026

Web scraping in 2026: ethical practices, robots.txt, BeautifulSoup, Scrapy, Playwright. Handling JS-heavy sites, rate limits, and cleaning messy data.

#web-scraping #python