Pre-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. EacSep 10 · 6 min readadarshgowda.hashnode.dev
Fan-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 standaSep 1 · 6 min readadarshgowda.hashnode.dev
Where 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, Aug 25 · 6 min readadarshgowda.hashnode.dev
One 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.Aug 20 · 7 min readadarshgowda.hashnode.dev
Best 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...Jan 2, 2023 · 2 min readadarshgowda.hashnode.dev