[–] 10 points 1 year ago

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.

  • source
  • parent
  • context
  • [–] 14 points 1 year ago

    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.

  • source
  • [–] 1 point 1 year ago

    Most companies implement for malicious link control. They can actively scan as needed and they can prevent users from going to any links deemed malicious. It also adds tracking for amount of clicks on a specific URL. There are more nefarious uses that others have stated redirection for paid links to them and user profile building for ad targeting

  • source
  • parent
  • context
  • [–] 8 points 1 year ago (4 children)

    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

  • source
  • view more: ‹ prev next ›