Journal
Writing
Opinionated engineering notes—security, scalability, correctness, and the interfaces between humans and machines. No listicles—just explanations you can reuse in prod and in interviews.
Filter
Matching posts
Showing 8 of 35. Clear filters
- DatabaseAugust 12, 20267 min read
PostgreSQL Transactions with Prisma
Choose between nested writes, sequential operations, and interactive Prisma transactions while handling concurrency and retries correctly.
PostgreSQLPrismatransactionsconcurrency - DatabaseAugust 8, 20269 min read
How to Fix Prisma Schema Drift Without Losing Production Data
A diagnosis-first procedure for reconciling Prisma migration history and production schema state with backups, restored-copy rehearsals, and controlled deployment.
PrismaPostgreSQLdatabase migrationsschema drift - DatabaseAugust 8, 20269 min read
PostgreSQL Connection URL Explained, Piece by Piece
A component-by-component breakdown of the PostgreSQL connection URL — user, password, host, port, database, and query parameters — plus safe environment-variable handling.
PostgreSQLPrismadatabase connectionenvironment variables - DatabaseAugust 8, 20269 min read
PostgreSQL Connection Pooling: Direct Connection vs Pooler
Compare direct PostgreSQL connections, application-side pools, and external poolers for persistent Node.js, serverless, Prisma, and migration workloads.
PostgreSQLPrismaNode.jsconnection pooling - DatabaseAugust 8, 20267 min read
PostgreSQL SSL Modes Explained for Node.js and Prisma
Understand PostgreSQL sslmode choices, certificate and hostname verification, and the differences between libpq, node-postgres, Prisma, and hosted providers.
PostgreSQLPrismaNode.jsTLS - DatabaseAugust 8, 20268 min read
Prisma Migrate Dev vs Deploy vs DB Push
Choose the correct Prisma schema command for development, prototyping, and CI/CD without confusing direct schema sync with versioned migrations.
PrismaPostgreSQLdatabase migrationsCI/CD - DatabaseAugust 8, 20268 min read
Prisma Migration Baseline for an Existing Database
Why Prisma Migrate reports the schema is not empty on an existing database, and how to baseline it correctly without a destructive reset.
PrismaPostgreSQLdatabase migrationsschema management - DatabaseAugust 8, 20266 min read
How to URL-Encode Special Characters in PostgreSQL Connection Strings
Encode PostgreSQL usernames and passwords safely without breaking the scheme, host, port, database name, or query parameters.
PostgreSQLPrismaNode.jsdatabase connection