All posts tagged with "postgresql"
Build a high-performance redirect engine and click analytics system. Learn 301 vs 302 redirects, non-blocking click tracking, user-agent parsing, geolocation, and analytics aggregation queries with PostgreSQL.
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.