Tagging is a Bitch

    After reading some different ways to implement tagging, I was amazed at how annoying it actually is to implement. Some implementations are dramatically faster, but they also limit what you can do with them. Since I want to implement tagging in ircwall in the simplest way for me to maintain, and around the limitations of DataMapper (primarily how it doesn't use JOIN's and instead executes another query to fetch data from another table, but that's how ORM's work).

    So, with that in mind, in terms of simplicity and performance, using a seperate 'tags' table and doing a one:many relationship to it from your other table is probably the best. In tems of performance, it's not exactly the best, but it's far from a slouch, so if you want to implement tagging as simply as possible, I'd say that's probably the way to do it.

Comments

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. Beside the tag style "<foo>" it is also possible to use "[foo]".

More information about formatting options