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/)RU
Posts
29
Comments
713
Joined
2 yr. ago

Comic Strips @lemmy.world

Child trafficking

  • I kinda hate the push towards passkeys. If you have two factor Auth, going to passkeys makes you go back to 1 factor, aka less secured.

    There's also more and more 2FA fatigue attacks going on, and they can affect passkeys too, and if you don't have a 2FA that involves the user writing a code on the 2FA device, passkeys could be quite possibly worse than passwords

  • This is also part of my death, because it's much easier to not deadlock when you are FIFO.

    Personally I went for the nuclear option, and any transaction is sent as a tokio task to make sure the transaction keeps getting polled despite other futures getting polled. Coupled with a generous busy timeout timer (60secs) and Wal mode, it works pretty well.

    Probably should also put the mutex strategy (perhaps a tokio semaphore instead?) although due to lifetimes it might be hard to make a begin() function on my DB pool wrapper.

    ... Congratulations. You nerd snipped me. Time for it to go on the todo stack.

    Hyped for it too, but wouldn't use until sqlx suport. Compile time checked queries are just so good. I don't use rustsqlite for that reason alone (you often don't need async SQLite anyways)

  • Tbh trigger performance isn't that much of a concern unless you need to write lots of data, which most usage don't need.

    Also try check statements instead or even re-evaluate your schema to prevent them if you really need to.

    Personally my death would be multiple write transaction deadlocks. Sadly it doesn't play that well with async code, like with sqlx (rust).

  • Lemmy Shitpost @lemmy.world

    It's that time of the year again

    Rance @jlai.lu

    L'avion de Paris - Pau

    Comic Strips @lemmy.world

    Mimi #8: New show

    Comic Strips @lemmy.world

    Mimi #7: First Day of Class

    Comic Strips @lemmy.world

    Mimi #67: Flat

    Comic Strips @lemmy.world

    Mimi #6: Don't forget

    Comic Strips @lemmy.world

    Mimi #3: Proposal

    Atheist Memes @lemmy.world

    Last resort

    Flork of Cows Comics @lemmy.world

    Horse racing

    Comic Strips @lemmy.world

    Mimi #66: Gift

    Comic Strips @lemmy.world

    Mimi #2: Genie

    Comic Strips @lemmy.world

    Mimi #1: Shrimp fried rice

    Comic Strips @lemmy.world

    Mimi #65: Plot twist

    Comic Strips @lemmy.world

    Mimi #64: Recycle

    Flork of Cows Comics @lemmy.world

    04/06/2025

    Fuck AI @lemmy.world

    Made for terrible comic day

    Blender @lemmy.world

    Are memes allowed if you made it in blender?

    Fediverse @lemmy.world

    Any fediverse like discord clones?

    Factorio @lemmy.world

    TIL that pass through connections can pass through any fluid, not just electrolyte