Skip Navigation
InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)BU
Posts
4
Comments
117
Joined
2 yr. ago
  • 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.

  • 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.

  • I would add that hollywood just doesn't know how to write strong multi-women content. It seems like every show or movie that is led by a majority female cast has a bunch of one-note women doing cliche bullshit. They really struggle to write deep, nuanced, flawed women in roles where that's what the story needs. As to why, sure it's patriarchy, but they keep putting out duds and using it essentially say "audiences don't want female-led content"..

  • 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.

  • Privacy @lemmy.ml
    ButtDrugs @lemm.ee

    Spam Call Screening that doesn't "phone home"?

    Are there any phone screening apps for Android that don't rely on a 3rd party service, something that functions more along the lines of ublock or similar?

  • 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.

  • Ohio @midwest.social
    ButtDrugs @lemm.ee
    BestOfLemmy @lemmy.world
    ButtDrugs @lemm.ee

    ubermeiester drops in with a dissertation to the question of "why does vegeta have boobs?"

    Asklemmy @lemmy.ml
    ButtDrugs @lemm.ee

    How the fuck can I kill 20 hours?

    My 13 hour flight just got delayed 7 hours, I'm stuck at my second airport, and I dont think I'm gonna make it. I have some movies and audio books on my phone, but really only anticipated having to burn the flight time via napping and some media, not 7 hours leading up to it, and I'm pretty sure I'm gonna mentally burn out on passive media.

    • I have media on my phone - movies, shows and audio books, but I can only do about 2-3 hours at a stretch before I burn out on those things.
    • I have wifi and power both on the ground and on the plane, although I'm sure the connection once we get going isn't going to be performance enough for online games.
    • I have a phone and headset but didn't bring a laptop because it was just extra bulk I didn't think I'd need. I don't have a switch or steam deck or anything neat.
    • I have access to the airport lounge, so drinks are free, and I get free drinks on the plane. I don't want to get wasted or have to pee constantly, so my plan is to [jim lahey it](