BackendPostgreSQL Backup and Restore: A Production-Safe Guide
Build a reliable PostgreSQL backup and restore workflow with pg_dump, pg_restore, protected credentials, retention, verification, and recovery drills.
7 min read
Engineering notes
Blog Articles
Backend
Software DevelopmentBuild a Node.js CI Pipeline with GitHub Actions and PostgreSQL
Create a secure, fast Node.js CI pipeline with GitHub Actions, npm caching, lint and build checks, automated tests, and an isolated PostgreSQL service container.
8 min read
BackendRedis Caching in Node.js: Cache-Aside, TTLs, and Safe Invalidation
Build a reliable Redis cache for a Node.js API with cache-aside reads, bounded TTLs, write invalidation, stampede protection, graceful fallback, and production monitoring.
9 min read
BackendPostgreSQL Indexing Guide: Use EXPLAIN ANALYZE to Fix Slow Queries
Learn a repeatable PostgreSQL performance workflow using EXPLAIN ANALYZE, composite and partial indexes, covering indexes, planner statistics, and production-safe validation.
10 min read
BackendHow to Deploy Laravel with Livewire or Inertia.js on Ubuntu Linux
Deploy a production-ready Laravel application with Livewire or Inertia.js on Ubuntu using Nginx, PHP-FPM, Vite, SSL, queues, scheduling, and a repeatable release workflow.
10 min read
BackendBuild a REST API with Express, Prisma, and PostgreSQL
Learn how to build a structured REST API with Express, Prisma, and PostgreSQL, including migrations, validation, pagination, error handling, and production practices.
6 min read