Moved to ButtDrugs@lemmy.zip

  • 5 Posts
  • 135 Comments
Joined 2 years ago
cake
Cake day: August 7th, 2023

help-circle











  • Storing large volumes of a text in a database column without optimization, then searching for small strings within it. It causes the database to basically search character by character to find a match by reading everything from disk. If you use indexes the database can do a lot of really incredible optimization to make finding values mich faster, and honestly string searching is better suited to a non-relational DB engine (which is why search engines don’t use relational DBs).

    Cartesian explosion is where you join related data together in a way that causes your result set to be wayyyy bigger than you expect. For example if you try to search through blog posts, but then also decide to bring in comments to search, then bring in the authors of those comments and all their comments from other posts. Result sets start to grow exponentially in that way, so maybe if you only search a few thousand blog posts you might be searching through millions of records because you designed your queries poorly.







  • Fuck the AI “boom”, but this is the best legitimate use of it around, summarizing annoying videos or long documents. Here’s an AI summary.

    Here is a summary of the video:

    • Canada, rich in energy resources, has historically been a key energy supplier to the United States [00:00].
    • However, due to protectionist tariffs imposed by the U.S., Canada is now diversifying its energy exports towards European and Asian markets [00:30].
    • This shift could have implications for the U.S., potentially weakening its global balance of power and energy security [00:39].
    • Canada’s new commodity pacts with the European Union and Asia could redirect the flow of low-cost heavy oil, natural gas, and critical minerals away from the U.S. [00:46].
    • The European Union is one of the world’s largest economies and Canada’s second-largest trading partner, offering significant opportunities for growth [03:47].
    • A comprehensive trade agreement between Canada and the EU aims to reduce Canada’s dependence on the U.S. market [04:04].
    • If Canada’s energy exports shift to the EU and Asia, the U.S. could face disadvantages such as higher energy costs and reduced bargaining power [06:16].
    • Canada is focusing on key commodities to strengthen its economy and become indispensable to U.S. interests [07:04].
    • Canadian oil and gas exports support U.S. energy reserves, lower consumer costs, and aid in expanding international energy exports [08:51].
    • Canada’s increasing capacity to ship oil to tidewater markets allows it to support global allies like South Korea and Japan [10:32].
    • Canadian natural gas can help ensure abundant domestic supplies in the U.S. and free up space for exports to allies [10:48].
    • Canada is poised to become a major liquefied natural gas supplier, particularly to strategic Asian allies [11:27].
    • Low-cost Canadian electricity can power various U.S. endeavors, and new projects aim to boost electricity exports while saving costs [12:03].
    • The rapid growth of AI technology in the U.S. is expected to drive a sharp increase in electricity consumption, which Canada can help meet [12:56].
    • Canada’s strategic move to diversify its energy exports could potentially change the geopolitical balance in terms of global energy security [13:13]. Would you like to ask about another video?