Tag: postgresql

All the articles with the tag "postgresql".

• The README — Enterprise NestJS Monorepo (enterprise-todo)

  25 May, 2026

  The production-ready README for the enterprise-todo repository built across all 24 parts of this series. Copy this into your repo's README.md — it covers stack, prerequisites, getting started, every environment variable, every script, the architecture, and all known gotchas.

• Affiliate & Referral Tree — Materialized Path Hierarchy on UserEntity

  18 May, 2026

  Add a self-referential affiliate tree to UserEntity using the materialized path pattern — store each user's ancestry as a string path, enabling O(1) depth lookups, efficient descendant queries with a single LIKE clause, and referral commission calculations without recursive CTEs.

• Database - PostgreSQL, TypeORM, Entities & Migrations

  4 May, 2026

  By the end of this part, you will learn PostgreSQL, TypeORM, AbstractEntity, SnakeNamingStrategy, migration lifecycle and verify your schema in Adminer.