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.
I’d imagine there will be legal asylum challenges in some EU countries for LBTQ+ people, i wouldn’t be surprised if a court upheld them and granted asylum for Americans. Which is the sad and scary reality of the current state of things.
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.
Yoi should mark this as spoilers.
That’s a sweet icon pack
I’m 9 books into WoT right now (its good shit) and the overlap between the Dune series is pretty interesting to say the least. Rand -> Paul, Aes Sedai -> Benne Gesserit, Aiel -> Fremen, I mean there’s a dozen more comparisons I could make too. The lack of Turbo Pussies and chair dogs is a let down though.
There’s a lot of incredible American- made cheeses, usually from more local cheese makers. Wisconsin and Vermont are the most fampus for their cheeses, but every state probably has good cheesemakers and there are some pretty good national brands. But the main cheese section at your typical grocery store is mostly just mass-produced cheap cheese that is probably more what you’re referring too, which is fine for most uses (e.g. cooking) but eaten alone i would describe as perfectly fine but not great. A lot of grocery stores have a nicer cheese section, but it’s usually in a section of the store more with other small bites.
Cleveland has a famous injury lawyer that billboards have just slowly evolved into this: 
This is fucking hilarious. One of the most legitimataly funny XKCDs I’ve seen.
They could mold each block, cast concrete into the mold, and use that as the base for the stones.
I’ve only seen the first one and I’m pretty sure they made that clear in the first one.
Sorry, best we can do is folks who hold up little signs that say “lies” during speeches.