What is the best way to protect a database from spam?

Question

Pls share your thoughts.

Answer 1

@Andrew G
Yeah but you can' t block spammers by email because they are not always stupid bots. By the way also me can create spam if i want

Answer 2

1. Validate inputs before inserting to the database.
2. Use prepared statements
3. Use a captcha, Google's Invisible reCaptcha is the best.
4. Track the IP address of the submitter, so you can verify later if the same person submitted spams.

Answer 3

@Andrew

for number 3, people can use burner emails. I myself use an app to get random emails that last for a short time, then I get another one (called "TempMail" on the playstore)

@Hasan

VPNs, proxies, and TOR can be used to hide IPs and MAC addresses

From a website side of things, its extremely difficult to track users who don't want to be tracked, in many cases you flatout can't

there are counters against every possible means of tracking that a webmaster can deploy

source: as a hobby I study mass surveillance

Answer 4

Protecting a database from spam I think is almost impossible but at least you can delete them automatically or manually. anutomatically I do not know maybe you can create something that can handle a series of variables like frequency of accesses or type of sender.

Answer 5

Without a human supervision or a kind of A.I. it would be very annoying for non-spammers.
edit: machines are not better than humans yet

Answer 6

Pls @Muhammad Aliyu tell us everything

Answer 7

Encrypting database with custom scripts (using our own bots)

Answer 8

Learn more about sql