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 moreBlog
One thing I learn every day
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
Free Semantic Search with Gemini API
Moving beyond keyword matching, semantic embeddings offer a more accurate way to surface related content. Discover how to leverage Google's Gemini API for cost-effective, meaning-based suggestions.
Read more
Moving Beyond Offset Pagination in Production Systems
Moving beyond basic LIMIT and OFFSET allows developers to handle massive datasets more efficiently while maintaining high performance and data consistency.
Read more