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
7 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, evaluating durable workflows in PostgreSQL against a dedicated engine like Temporal, and a full PostgreSQL guide for developers arriving from MySQL that maps the syntax, type, indexing, and transaction differences between the two. 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
PostgreSQL for MySQL Developers: The Complete Guide (Syntax, Queries, and Key Differences)
Coming from MySQL? Learn PostgreSQL's syntax, data types, and query differences with real examples, so you can start writing Postgres with confidence.
21 min readZeeshan Tofiq
Redis Explained: What It Is & How to Use It With Node.js
Confused about what Redis actually is? This guide explains Redis in plain English, then shows how to set it up with Docker and use it with Node.js caching.
13 min readZeeshan Tofiq