Aditya Mishra
Principal Engineer & AI Engineer
The Doorbell, Not the Parcel: Realtime Chat Without WebSockets
How inbound WhatsApp messages reach an open chat screen using SSE, Redis pub/sub, and events that ring a doorbell instead of carrying data.
July 16, 2026·8 min read
The Blind Index: Prefix Search Without Plaintext
How to build prefix-search over encrypted messages in Postgres using blind indexing and n-gram tokens, without storing any plaintext.
April 10, 2026·10 min read
The Boring Answer to MCP Context Bloat
How to build prefix-search over encrypted messages in Postgres using blind indexing and n-gram tokens, without storing any plaintext.
April 3, 2026·10 min read
Searchable PII Encryption in Postgres
How we encrypted PII so a leaked database dump reveals nothing, while prefix search, sorting, and filtering all kept working.
February 10, 2026·6 min read
Notes on Data Archival: Keeping Postgres Lean Without Downtime
Freeing up an RDS running out of disk space by archiving 8M rows to S3, and the three gotchas that stood in the way: concurrent index creation, hourly batching, and VACUUM FULL.
June 21, 2024·6 min read