AAA Adarshinadarshgowda.hashnode.dev·1d ago · 6 min readPre-aggregation gets you 100× — until someone applies a filterYou have a dashboard over a large fact table. Tens of millions of new rows a month, thirty tiles on the page, and every tile is an aggregate: orders by channel, revenue by region, units by device. Eac00
AAA Adarshinadarshgowda.hashnode.dev·Sep 1 · 6 min readFan-out reads: query count matters more than query latencyA page loads thirty tiles. Each tile is a query. The page is slow, so you do the obvious thing: profile it, find the slowest query, and make it twice as fast. The page barely moves. This is the standa00
AAA Adarshinadarshgowda.hashnode.dev·Aug 25 · 6 min readWhere generated files live in a multi-replica serviceA lot of features have the same shape. A request asks for something expensive. A background job produces it. A later request hands it over. Data exports, generated reports, rendered PDFs, thumbnails, 00
AAA Adarshinadarshgowda.hashnode.dev·Aug 20 · 7 min readOne database is a cost, not a simplificationMost features arrive needing one kind of storage. Occasionally one arrives needing two, and that's where a specific bad decision gets made — almost always for a good reason. The shape is recognisable.00
AAA Adarshinadarshgowda.hashnode.dev·Jan 2, 2023 · 2 min readBest Open Source Programs For Students.What is open source? Before discussing Open Source Programs, let’s understand what Open Source is. Open-source software is code designed to be publicly accessible — anyone can see, modify and distribute the code. The software is then released under a...00
