Building Prefix Search Autocomplete Using Trigram Indexing
Implementing a high-performance autocomplete system using native PostgreSQL features like trigram indexing for prefix matching and typo tolerance.
Read moreBlog
One thing I learn every day
Difference Between zip and gzip Compression Formats
While both formats reduce file sizes, they handle archiving and data organization in fundamentally different ways that affect your workflow and compression efficiency.
Read more
A Real-World Concurrency Bug Caused by LibreOffice Profile Locking
Discover how shared user profile locks cause silent failures in concurrent LibreOffice headless jobs and learn to isolate processes using unique environment configurations.
Read more
Building a Blog Post Similarity Graph: A Physics Simulation Journey
A deep dive into building an interactive, physics-driven graph that uses semantic embeddings and force-directed simulation to map related blog posts.
Read more
Batch Based Approaches to Updating Large Tables in PostgreSQL
Batch processing updates prevents long-held locks and database pressure in large tables, using either integer ID increments or state-based filtering to manage performance.
Read more
Do You Really Need WebSockets for Streaming Data
Modern web infrastructure allows for efficient unidirectional data streaming over HTTP, often making it a simpler and more scalable alternative to WebSockets for real-time needs.
Read more