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.

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.

I work in tech, and have had multiple employees claim they only have “dumb” phones for what I’m pretty sure is this exact reason. And I never blame them, just put the heat on IT to find a solution.

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.

Bro just dropped a whole dissertation. Great comment.

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.

Or a movement to get people off whatsapp and into signal.

Honestly the 1.2 TB I’m the early 90s is an insanely impressive figure to me. I mean in that era a gigabyte seemed like an obscene amount of data, the interat ran at less than 56 kbps, and I don’t think I had a 1GB drive in my hime PC until almost the turn of the millennium. Sending and storing that much from venus is a huge accomplishment.

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.

This headline has been on daily repeat since like 2015 with that clown. It’s like the YouTube thumbnail face of trump headlines.

Google could be broken up into

• search
• chrome / gsuite
• YouTube
• gcloud
• ads
• android. And I’m sure more

MS

• windows / office
• azure
• xbox
• bing
  …I’m too tired to keep going lol

If those had to all survive independently and couldn’t leech off profits of the parent organization we could have true competition. Instead you just need one super-profitable arm of a company than loss-lead your way into other verticals and out-compete everyone else because you don’t have to turn a profit, at least while the competition is still clinging on.

Hopefully it’s a positive feedback loop situation here. More nebula subscribers-> more revenue -> more creators -> more subscribers. It’s good that it’s owned and ran by some creators so hopefully they stay true to their cause here.

Wasn’t there like a testimony from an FBI guy about the pee tapes or something though? I think there was no hard evidence, but the pee tapes at least have to some plausibility.