All posts tagged with "postgresql"
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.
Master database access in TypeScript with Prisma, Drizzle ORM, and raw SQL. Learn schema design, migrations, relations, query optimization, N+1 prevention, transactions, and connection pooling for production apps.
Master database schema design from scratch. Learn normalization (1NF-3NF), relationships, naming conventions, soft deletes, UUIDs vs auto-increment, and design real-world schemas.
Master relational database fundamentals. Learn how SQL queries execute internally, ACID properties, transactions, isolation levels, data types, constraints, and when to choose PostgreSQL vs MySQL vs SQLite.
Complete guide to database integration in Spring Boot using Spring Data JPA and Hibernate. Learn entity mapping, repository patterns, relationships, queries, and best practices with PostgreSQL.
Master database integration in FastAPI with SQLAlchemy. Learn async operations, CRUD patterns, migrations with Alembic, and best practices for production APIs.
Build a production-ready monorepo template with Express 5, React 19, PostgreSQL, Pulumi, and Azure DevOps. One command to bootstrap, TypeScript everywhere.