I’d like to create
Post functionality similar to Facebook. I’d like users to be able to mention others and for the mention to hyperlink to a users page.
What is the best way to save this text? The approach that I’m thinking is to save the text along with the hyperlink in a text field in PostgreSQL.
"Thanks <a href="/johnny">Johnny</a>"
However, this approach lacks structure. For example, there is no database entry relating johnny to mentions.
What’s the best way to save this data?