MirahLabs Engineering Blog
Technical insights, tutorials, and architectures written by our design and backend engineers.
Vector Search at Scale: Hierarchical Navigable Small World (HNSW) Indexes
Similarity searches on millions of high-dimensional vectors are computationally expensive. Learn how HNSW graph indexes make nearest-neighbor search sub-millisecond.
PostgreSQL Performance Tuning: Indexes, Query Plans, and Connection Pooling
PostgreSQL is incredibly powerful but requires thoughtful configuration for high-traffic production workloads. This guide covers index strategies, query plan analysis with EXPLAIN, and PgBouncer connection pooling.
Database Isolation Levels: Read Uncommitted, Read Committed, Repeatable Read, and Serializable
Understand transaction isolation in relational databases. Learn how isolation levels prevent dirty reads, non-repeatable reads, and phantom reads.
Understanding Serverless Databases: Amazon Aurora Serverless v2 vs. CockroachDB
Serverless databases decouple storage and compute to scale automatically. Compare Amazon Aurora Serverless v2 and CockroachDB Serverless for elasticity and global distribution.