Tagging with PostgreSQL
I’ve been looking at the well known and documented ways to do tagging. https://stackoverflow.com/questions/2885564/ways-to-implement-tags-pros-and-cons-of-each http://howto.philippkeller.com/2005/04/24/Tags-Database-schemas/ I was undecided between MySQLicious and Toxi methods. For my use case I currently just retrieve all the tags anyway, so MySQLicious seems like the way to go. We have an item which has tags associated with it. Currently we fetch all items and as such with them all possible tags. We then do tag filtering/searching on the client side. However as we scale fetching…