😂

Prove right now that you’re not a shill for Big Lemmy!

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.

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.

We have porn! But yeah we need more population growth for niche and local communities to really flourish.

I think we should ultimately support algorithm feeds, but they should be free and open algorithms that can be peer reviewed, and also maybe give the users some control over which algorithm is applied and how. The problem with current social algorithms is they operate in the dark and are manipulative, not that they provide relevant content to users.

It depends on how you define “the USA”. If you mean the people of this country, then absolutely they are working against us. If you mean the people with loads and loads of money, then no, they are working as hard as they fucking can for them.

This is fucking hilarious. One of the most legitimataly funny XKCDs I’ve seen.

It’s mostly landing/takeoff records. Big airports have takeoff and landing fees and would keep records such as this for accounting and legal reasons. Being a major airport like LAX means it’s probably mostly private/commercial jets, but also plenty of small time hobbyist aviators are probably wrapped up in this, and would be the only victim here ( general aviation pilots tend to use smaller, local airports but still on occasion hit the big ones).

You apparently haven’t tried calling local government agencies in mid-size cities, or a good chunk of airlines. It’s frustrating and I welcome anything that can help.

I think Nintendo games might be the exception here. You can get a physical copy on release day, put it in and play immediately, and the quality is gonna be at least 8/10, probably higher.

That agents name? George Washington.

Jesus christ 3rd graders with phones.

I’m gonna go out on a limb and say I think this is done to prevent anticompetitive issues. If Google were to profit off of both its own product (youtube / yt music) and also require its competitors to pay it a % of revenue, it would potentially open them up to more anticompetitive lawsuits.

Just for clarity, they already switched protocols (Manifest v3), they just have continued to support the old format (v2) that allows unlock origin to work. They are discontinuing support for v2 next year.

Wow really? I’ve never heard of a CEO not getting options.

Sam probably still controls a ton of shares, so I think effectively this would give them >50% of shares as long as they are partnering.