Drizzle ORM Migrations: A Practical drizzle-kit Guide
Learn the full Drizzle ORM migration workflow: push vs migrate, drizzle-kit setup, Turso/libSQL config, team conflicts, and production best practices.
20 min readZeeshan Tofiq
Databases
5 articles
Database work centred on PostgreSQL and the data layer above it. Articles cover running and reviewing Drizzle ORM migrations with drizzle-kit, testing PostgreSQL row-level security policies in Jest so a broken policy fails CI instead of production, and evaluating durable workflows in PostgreSQL against a dedicated engine like Temporal. Two long reference sets cover SQL and NoSQL interview questions in depth. Schema, query, and migration examples are runnable, and the trade-off discussions state the workload assumptions behind each recommendation rather than presenting one option as universally correct.
42 NoSQL Database Interview Questions and Answers (2026)
42 NoSQL interview questions covering MongoDB, Redis, and DynamoDB: aggregation pipelines, data structures, GSI vs LSI, and CAP theorem. Updated for 2026.
51 min readZeeshan Tofiq
40 SQL Interview Questions and Answers (2026)
40 SQL and relational database interview questions covering joins, indexes, ACID, window functions, CTEs, MySQL vs PostgreSQL, and query challenges.
47 min readZeeshan Tofiq
pg_durable: Durable Workflows in PostgreSQL vs Temporal and Cron+Queue
Microsoft's pg_durable brings durable workflow execution inside PostgreSQL. Here is the syntax, what it replaces, and an honest comparison against Temporal and cron+queue patterns.
29 min readZeeshan Tofiq
Testing PostgreSQL RLS Policies With Jest (No pgTAP)
Test PostgreSQL row-level security with Jest and node-postgres, no pgTAP required. Catch tenant isolation bugs in CI before a bad grant reaches production.
14 min readZeeshan Tofiq