I am currently working to code tagging capabilities in my blogging system and I have hit a fork in the road on how I should implement this;
1.Add a field in the blog db called tags and have tags listed there using a comma as a delimiter, which would mean separating of the tags would come on the page load.
2.after posting, separate the tags into its own database linking the tag to the blog via the blog unique id.
I have been jumping back and fourth on how to implement this, and a part of me sees #1 slowing down page loads because of the separating functions.
Opinion anyone? is it better to create a separate db for tags or keep the tags with the blog itself?
Thanks 🙂