Tag: PostgreSQL
13 posts
-
PostgreSQL Internals That Matter: MVCC, VACUUM, the Planner and B-tree vs GiST vs GIN
PostgreSQL internals: MVCC snapshots, VACUUM/autovacuum, cost-based planner & stats, B-tree vs GiST vs GIN—plus partitioning, replication, backups.
-
TypeORM with TypeScript: Entities, Repositories, Relations, Migrations and Transactions
Using TypeORM with SQL databases: configuration, entity definitions, the repository pattern, relations, migrations, transactions, validation and custom repositories.
-
Drizzle ORM Advanced Guide | Transactions· Relations
Drizzle ORM in production: transaction isolation levels, relational query vs. join trade-offs, safe migrations, and connection pooling.
-
C++ Query Optimization Guide | Index Selection· Plans
C++ query optimization: index selection, EXPLAIN plans, statistics, cost models, and production patterns [#49-3].
-
PostgreSQL Query Optimization Guide | EXPLAIN· Indexes
Find slow PostgreSQL queries with pg_stat_statements and EXPLAIN ANALYZE, then fix them with the right indexes, VACUUM, PgBouncer and postgresql.conf tuning.
-
Prisma ORM in TypeScript: Schema Design, Dev vs Prod Migrations, Relations and Raw SQL
Model data in schema.prisma, use migrate dev locally and migrate deploy in production, query relations with typed results, and fall back to raw SQL.
-
Supabase as a Postgres Backend: Auth, Row Level Security, Realtime, Storage and Edge Functions
Supabase as a Postgres backend: email and OAuth auth, queries with filters and joins, Row Level Security, realtime, storage, Edge Functions and Next.js.
-
Drizzle ORM Basics: TypeScript Schemas, Type-Safe Queries and drizzle-kit Migrations
Learn Drizzle ORM fundamentals: TypeScript-first schema definition, type-safe queries, and drizzle-kit migrations — no separate schema DSL, no codegen step.
-
SQL vs NoSQL Database Guide | MySQL· PostgreSQL
A comparison of SQL and NoSQL databases covering data models, consistency guarantees, and when to choose each.
-
PostgreSQL vs MySQL | Deep Comparison | When to Use Each
PostgreSQL or MySQL? Compare data types, JSON, full-text search, locking, indexes, replication and extensions to decide which one fits your workload.
-
Python Databases | SQLite, PostgreSQL, and ORMs Explained
Work with databases in Python: sqlite3, SQLAlchemy models, CRUD, relationships, and a Flask + SQLAlchemy API example.
-
Node.js Database Integration: MongoDB, PostgreSQL, and MySQL
Connect Node.js to MongoDB (Mongoose), PostgreSQL (pg, Sequelize), and MySQL (mysql2): connection pools, CRUD, transactions, REST examples, indexes.
-
PostgreSQL vs MySQL: Schema, Transactions, Queries and Operations
PostgreSQL vs MySQL compared for schema flexibility, ACID, SQL features, replication, and ops—plus Node.js–friendly criteria to pick the right RDBMS.