Opensearch will be the most performant. Anything sql will likely start to stumble with lots of stories or really long stories where this is exactly what lucene based search engines (solr, elastic, opensearch) are designed to do. Could an SQL solution solve your problem, yes, but it may be a bit on the slow side as your amount of stories and size grows.
It’s been reasonably active here definitely not reddit in it’s prime, I haven’t found it worthwhile to self host lemmy but others may chime in that do. I’ve got a few other things I’m hosting on my Dell r720xd matrix, jellyfin, wireguard, next cloud, gonic and other minor things.
What about just old school cash?
They didn’t before this only affects code changes going from AOSP to Google’s private branch, which is going away. Code from Google’s private branch to AOSP is unaffected. Custom ROMs are all just down stream consumers of AOSP repository anyways.
It’s been mostly this way for a while reason why it takes a little bit before lineageos releases the next version. AOSP is just fully down stream. What will be concerning is when those releases get longer and longer. As another comment said we all just need to figure out linux phones. Been eyeing a pine phone for a while now should probably pull the trigger.
Probably saw this in passing. It doesn’t seem to indicate fully broken just this instance.
https://www.reddit.com/r/math/comments/wc4gkx/supersingular_isogeny_diffiehellman_broken/
Similar to a diffie-hellman key exchange maybe? https://en.m.wikipedia.org/wiki/Diffie–Hellman_key_exchange
I believe this has been broken but that is the general gist.
I believe I understand what you want. “Zero” login. So when a user comes to your site or first boots up your app a private key gets generated locally. It will then do a handshake with the server, where that the server understands that these encrypted messages are from this user, this uniquely identifies the user, and also can be used for e2e.
Reference https://dev.to/spalladino/a-beginners-intro-to-coding-zero-knowledge-proofs-c56
How do you check?
What does it say if you have your favorite job while listening to your favorite song and still love both?
Puerto Rico in reality “good now everyone can stop asking us to be the 51st”
Why have impeachment if there is no consequences? Just mind boggling.