Add PostgreSQL and Prisma ORM to your URL shortener. Learn database schema design, migrations, indexing strategies, connection pooling, and how to replace in-memory storage with persistent database queries.
Learn to build a production-ready URL shortener from scratch with Express, TypeScript, PostgreSQL, Redis, and React. A 15-post series covering API design, database modeling, caching, analytics, auth, deployment, admin panel, and SEO.
Master advanced SQL features: window functions for rankings and running totals, CTEs for readable query composition, recursive queries for hierarchical data, and essential functions for real-world analytics.
Containerize your Next.js blog and PostgreSQL database with Docker Compose. Build a multi-stage Dockerfile, configure dev and production overrides, run migrations on startup, and test everything locally before deploying to a VPS.
Connect your Express.js API to PostgreSQL with Prisma ORM. Covers schema design, migrations, type-safe CRUD, transactions, connection pooling, seeding, and testing database code — building on the task API from the previous post.
Add a PostgreSQL database to your Next.js blog using Drizzle ORM. Design schemas for post views, newsletter subscribers, and comments. Run migrations and wire up CRUD helpers and a real-time view counter.
A complete guide to building and self-hosting a personal blog from scratch using Next.js 16, ShadCN/UI, PostgreSQL, Drizzle ORM, MDX, Docker Compose, and deploying to an Ubuntu VPS on Hostinger with a custom domain.
Master SQL fundamentals from scratch. Learn SELECT queries, filtering, aggregation, all JOIN types with diagrams, subqueries, and the actual execution order SQL uses — with real-world examples throughout.
Complete SQL and NoSQL learning roadmap for developers. Master SQL fundamentals, advanced queries, PostgreSQL, MongoDB, Redis, indexing, transactions, schema design, and when to choose SQL vs NoSQL.