title: How to implement tag system
body: <p>I was wondering what the best way is to implement a tag system, like the one used on SO. I was thinking of this but I can't come up with a good scalable solution.</p>
  
  <p>I was thinking of having a basic 3 table solution: having a <code>tags</code> table, an <code>articles</code> tables and a <code>tag_to_articles</code> table.</p>
  
  <p>Is this the best solution to this problem, or are there alternatives? Using this method the table would get extremely large in time, and for searching this is not too efficient I assume. On the other hand it is not that important that the query executes fast.</p>