PostgreSQL

0 articles

JoyMini API — Enterprise-Level NestJS Backend Architecture Practice

A unified backend platform built with NestJS + Prisma + PostgreSQL + Redis + BullMQ, supporting 200+ API endpoints across 4 frontend applications

Project Cases

4-Core Server Backend Optimization Report: Why Cluster Mode Is Not the Answer

This article documents the multi-core optimization evaluation process for a NestJS API backend deployed on a 4-core VPS. It analyzes the feasibility of Cluster mode, UV_THREADPOOL_SIZE, database query optimization, Redis caching, and Nginx cache tuning one by one, ultimately concluding that "the bottleneck is DB I/O, not CPU."

Performance Optimization

Detailed Explanation of Deployment Rollback Mechanism – Container Rollback and Database Recovery Shell Script Practice

Based on a 151-line production-grade rollback script rollback.sh, this article explains three rollback modes in detail: container rollback (restarting the previous available image), database rollback (restoring backups with pg_restore), and the design approach for an interactive safety confirmation mechanism.

Operations and Deployment

Prisma Optimistic Locking in Practice: Dual-Currency Wallet System with Audit Trail for Financial Tracking

An in-depth analysis of a production-grade NestJS wallet service, covering Prisma update where optimistic locking, dual-currency accounting (cash + coins), freeze/unfreeze mechanisms, and complete transaction flow tracking.

Backend Development