Amina Okanovic·Oct 3The Expensive Part of Entity Resolution Is the Step Nobody Budgets Time ForAn investing knowledge graph pulls company data from a Bloomberg-style feed, a regional-language news service, and a handful of smaller…
Amina Okanovic·Oct 3A Bloated PostgreSQL Table and a Fast One Can Be the Same TableAn engineer checks pg_stat_user_tables on a busy orders table and finds n_dead_tup sitting at several times n_live_tup — a table that's…
Amina Okanovic·Sep 25The Real Failure Mode of a Graph RAG System Is Retrieval That Never StopsA Graph RAG system built over a 50-million-row supply chain knowledge graph starts simple: given a query, find the entities it mentions…
Amina Okanovic·Sep 25Your Data-Quality Tool’s SELECT * Is a BigQuery Cost Bug Wearing a Debugging FeatureA data-quality check on a 48-column, 5-billion-row BigQuery table fails: one column, amount, has 21 rows with negative values it shouldn't…
Amina Okanovic·Sep 23A Data-Drift Detector Passed 56 Fault-Injection Tests. The One Test Expecting Silence Failed.The team behind Upstrace, an open-source, MIT-licensed column-level drift detector for dbt projects, runs it against a benchmark of 56…
Amina Okanovic·Sep 23The Model Change Was the Easy Part: What Netflix Had to Log Before It Could Trust the ResultNetflix was about to ship its largest TV home-screen redesign in a decade. The redesign made one artwork canvas — short-panel — the…
Amina Okanovic·Sep 21One Connection Per Tenant Does Not Isolate DuckDB, and the Latency Numbers Hide ItYou have a few hundred gigabytes of Parquet and a DuckDB file that answers questions about it in milliseconds. Six internal teams want SQL…
Amina Okanovic·Sep 20PostgreSQL Will Let You Invent a Type, Right Up Until It Asks for a C CompilerA partner feed lands a million order rows a day, and the order date arrives as 03/15/2021. Someone stores it in a text column because that…
Amina Okanovic·Sep 20The Compact Model Was the Slow One: Storing Sparse Device Capabilities for AnalyticsA streaming platform wants to answer one question before it ships a feature: how many devices out there can actually run it? Spatial audio…A response icon1A response icon1
Amina Okanovic·Sep 19A FLOAT Ledger Column Fails Two Different Ways, and Neither Looks Like a BugA payments team processing around 10 million transactions a day stores order_amount as DOUBLE PRECISION in Postgres, because it's the type…