Another way Reddit minimizes joins is by using denormalization.
They took all the metadata fields required for displaying an image post and put them together into a single JSONB field. Instead of fetching different fields and combining them, they can just fetch that single JSONB field.
This made it much more efficient to fetch all the... See more
New prompts dropped @ingo This is very important to my career. You’d better be sure. Are you sure that’s your final answer? Believe in your abilities and strive for excellence. Your hard work will yield remarkable results. Are you sure that's your final answer? It might be worth taking another look.
The VTA in the brain contains neurons that send axons, which send out dopamine. This builds the core pathway for reward. The break for the dopamine release is the prefrontal cortex. Dopamine is a two path process in balancing pleasure and pain. If you get excited in a anticipatory way, the pathway starts firing and creates a desire to move and act.... See more
It’s underdigitized. According to the McKinsey Industry Digitalization Index, only the agriculture sector is less digitized than construction. The typical IT spend for construction companies is 1-2% of the revenue, compared with the 3-5% average across industries. Moreover, there are many barriers to digital technology adoption including skill... See more
Snowflake is easy to use. As you mature and scale, Databricks becomes a strong competitor capable of more use cases. I consider both to have a reasonable moat against AI/LLMs, which is data governance with data lineage. I expect that moat to last at least a few years... even though most companies aren’t mature enough to have a strong data... See more