This guy architects. You also get to a spend a lot of time explaining to non technical folks why their ideas are bad or expensive to build. Lots of being the bad guy.
Honestly privacy and social media don't make sense together at all. With all of these platforms, your privacy = how much you share on them. You can't share sensitive information on any social media (corpo or federated) and expect it to be private.
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?
Yeah I'm a 20-some year FF user and when it started you had to have IE as a backup because not everything was compatible. In the late 2000s through late 2010s everything worked everywhere, then with chromes dominance places have stopped testing or supporting certain things in FF and it feels like history is repeating itself. Unfortunately you need a chromium-based backup realistically for certain sites, but 99.5% of things work totally fine in FF.
This guy architects. You also get to a spend a lot of time explaining to non technical folks why their ideas are bad or expensive to build. Lots of being the bad guy.
I mean water quality was a huge problem for the Paris olynpics.
Sorry, best we can do is folks who hold up little signs that say "lies" during speeches.
As an idiot, I'm curious why Puerto Rico got lumped in with these other countries?
I think that's specific to .world.
I get a gig down but only 50mbps up (fucking spectrum), so I gotta limit seeding the same way or I'd just crush my upload speed all the time.
😂
Prove right now that you're not a shill for Big Lemmy!
Wait can it fix crew necks that get a little shitty?
Honestly privacy and social media don't make sense together at all. With all of these platforms, your privacy = how much you share on them. You can't share sensitive information on any social media (corpo or federated) and expect it to be private.
Man some people on this site lmao. This is called sarcasm and it's funny, they don't actually hate the french.
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.
Substring searches in unindexed large string columns or cartesian explosion caused by shitty joins would be my initial guess.
Connect for Lemmy. Super under- rated.
Also easy to repair. I got one that's like 8 years old and I replaced the blower and a sensor and its super easy and the components are cheap.
I have this same issue. Apparently yes it is downloading as the other comment mentions but I want to use the normal share dialog.
Just the free gemini model, asked my android phone to summarize it.
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:
Yeah I'm a 20-some year FF user and when it started you had to have IE as a backup because not everything was compatible. In the late 2000s through late 2010s everything worked everywhere, then with chromes dominance places have stopped testing or supporting certain things in FF and it feels like history is repeating itself. Unfortunately you need a chromium-based backup realistically for certain sites, but 99.5% of things work totally fine in FF.
Oceania 2: Electric Bugaloo