Many-to-many? That is, can a comment have many different hashtags? And a hashtag can be associated with many comments?
Best practice for many-to-many: CREATE TABLE xyz ( hashtag VARCHAR(...) NOT NULL, comment_id ... NOT NULL, PRIMARY KEY (hashtag, comment_id), INDEX(comment_id, hashtag) ) ENGINE = InnoDB; One might want to "normalize" the hashtags, but it does not seem warranted in this situation. > -----Original Message----- > From: Hank [mailto:hes...@gmail.com] > Sent: Friday, October 19, 2012 8:58 AM > To: MySql > Subject: Schemas for storing and reporting on hashtags > > Are there any established "best practices" or schemas for incorporating > twitter-like hashtags into a database ? > > Let's say I have a blog with a commenting system, and I want to allow > people to add hashtags to the comments. > > I could certainly create one on my own (it's not that difficult), but > I'd like to see what other people have done in terms of storage and > features. > > I'm also looking for a solid basic implementation, not something overly > complex. > > Thanks, > > -Hank > > (query, mysql) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
