Technical Writing
Notes, guides, and engineering deep dives from real-world backend, cloud, and system design work.
Indexes Lied to Me: and other lessons from the world of databases
A practical guide for enginners who know indexes exists but want to understand how they work, when planner ignores them and how to stop shooting yourself in the foot with too many of them.
A Trie-ing Effort: Leveraging Prefix Trees for Smart Lookup
Discover how tries power autocomplete, longest prefix match, and smart lookup in real-world backend services.
AWS:SSM Connect to private ec2 instances
Learn how to connect to ec2 instances without ssh, using aws ssm.
PostgreSQL Cron Jobs
Learn how to schedule cron jobs in PostgreSQL.
Building a realtime database listener: Using socket.io and pg_notify
Building realtime web applications with socket and database triggers using pg_notify in a Node.js application.