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 13 of 35. Clear filters
- DatabaseAugust 12, 20267 min read
Migrate WordPress Content to PostgreSQL
Export WordPress content and media, map it into PostgreSQL, build an idempotent importer, and preserve URLs and SEO signals.
WordPressPostgreSQLdata migrationSEO - DatabaseAugust 12, 20267 min read
Handle Dates and Time Zones in Node.js and PostgreSQL
Model instants, local schedules, Nepal Time, date-only values, and API timestamps without server-time-zone surprises.
Node.jsPostgreSQLtime zonesdate handling - DatabaseAugust 12, 20266 min read
Back Up and Restore PostgreSQL for a Production Application
Plan logical PostgreSQL backups with pg_dump and pg_restore, secure retention, version compatibility, and tested recovery.
PostgreSQLbackupsdisaster recoverypg_restore - 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 12, 20266 min read
Prevent Overlapping Time-Based Bookings in PostgreSQL
Use half-open timestamp ranges and an exclusion constraint to prevent concurrent bookings for the same resource.
PostgreSQLbooking systemsrange typesdata integrity - 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 - DataMarch 12, 20263 min read
Database indexing beyond B-trees — selectivity, partial indexes, and write amplification
How query planners pick indexes, when covering indexes beat heap fetches, and the operational cost every extra index hides.
PostgreSQLperformancequery-plansstorage