Handling unique indexes on large data in PostgreSQL

It is ok to ask a lot of questions, it is ok to be skeptic of friendly interactions, it is ok to be suspicious. These behaviors are not social anxiety, not psychosis, not anti-social. They are, in fact, desirable human aspects that contribute to the larger group.

There is no automated detection, no magic way of keeping these new threats away. They work by exploring humans in vulnerable states. We need kind humans that are less vulnerable to those things.

jaredcwhite•1h ago

Are you real?

Are you a human?

Is that real text you typed out?

Does anything you're saying have any meaning?

----

That is essentially what you are asking for. Every single online interaction immediately viewed as entirely suspect, with people having to go out of their way to prove they are…people.

Well perhaps you're right that this is where online culture is headed, but we don't have to like it. I hate it. I hate it so bad.

praptak•4h ago

I don't believe a purely technical solution exists. This needs to get political, ideally making it a crime to use technology in this way. The scope is much broader and more dangerous than niche forums. This shit has the potential to kill the ability of societies to discuss policy in a meaningful way.

burnt-resistor•1h ago

This will likely lead to the requirements of identity verification and a small bond as collateral for the privilege of online participation in a particular forum. Idealistic, unenforceable laws won't help.

chatmasta•3h ago

> Unavailable Due to the UK Online Safety Act

https://archive.is/y9JyC

lavelganzu•11m ago

Money is an imperfect but real solution. The simple thing is to charge a small sign-up fee. Obviously this dramatically increases the barrier to entry for real humans. But it should cut the spam even more sharply.