How do we prevent Spam?

[nelsonic]

An inevitable consequence of having a free-text entry form on a website is that "spam bots" will find it and attempt to submit spam in the hope of either linking back to their ("enlargement") content or worse compromising our server so they can use it to send more spam. 😧

We need to be aware of this reality early on and plan for it.
For the first iteration we can just create a simple form and post it online, but we need to be vigilant to protect against SQL and Script injection and prevent people from posting links.
So any links will be stored as text and not displayed with an <a> tag. 🔏

Further down the line we will need to investigate using a 3rd Party Spam Detection service.
If someone has time to start doing this soon, it would be good to get it done before the Spambots discover our site/service. ⏳