When MySQL 8 Stopped Respecting Implicit Ordering
Upgrading to MySQL 8 reveals hidden dependencies on implicit row ordering as the optimizer gains flexibility. Explicitly defining query order ensures consistency in data retrieval.
Read moreBlog
One thing I learn every day
Implementing Typo-Tolerant Search with PostgreSQL
Improve search UX by combining prefix matching with fuzzy similarity thresholds to handle common user input errors in PostgreSQL autocomplete features.
Read more
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 more
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