4 ms·
This is incredibly helpful. However, I wish there's something in reverse: Redis as a MySQL storage engine. The most obvious useful things is that you can save
by est 14y ago
This is incredibly helpful.
However, I wish there's something in reverse: Redis as a MySQL storage engine. The most obvious useful things is that you can save a `tags` table without m2m tables, juse use Redis sets.
- geon 14y agoI believe Postgres supports something like that.
- fdr 14y agoOne might choose to use the array datatype, combined with GiST, GIN, and/or expression based indexes, depending on the workload. That would be somewhat more lucid in most situations than a string packed into an attribute.
- sopooneo 14y agoWhy have an m2m table? Just have a table with two columns: post_id (or whatever is being tagged) and tag (varchar). If you want to present a list of possible tags just query for uniques. I may be missing something, so please correct me if there is a better way or I am misunderstanding your point.
- est 14y agothere are three design patterns for tags in a table based db http://forge.mysql.com/wiki/TagSchema http://forge.mysql.com/wiki/TagSchema
- ericcoleman 14y agoLink is dead... Just redirects to dev.mysql.com Cache link, since I can't find it on dev.mysql.com: http://webcache.googleusercontent.com/search?q=cache:II_A7LFmN-UJ:forge.mysql.com/wiki/TagSchema+http://forge.mysql.com/wiki/TagSchema&cd=1&hl=en&ct=clnk&gl=us http://webcache.googleusercontent.com/search?q=cache:II_A7LF...