Symfony search with tags
<p>We're building an application that has multiple different entities that are pretty simple with name &amp; description and some specific stuff.</p>

<p>Now we want to add tags, for the purpose of adding extra search keywords. (There will also be a tag cloud somewhere, but that's easy)</p>

<p>I've been reading up on different ways to do a proper search. Solutions like lucene, elastic, mysql fulltext match against and more.</p>

<p>Does anyone have any experience to share on the best solution for an application like this? </p>

<ol>
<li>Should I put the tags in the same table in a string/array field? Use a seperate table? I've also found <a href="https://github.com/FabienPennequin/DoctrineExtensions-Taggable" rel="nofollow">DoctrineExtensions-Taggable</a> which seems pretty decent and will make it easy to make a tagcloud too.</li>
<li>For a proper search over name, description &amp; tags, what's the best solution? lucene? elastic? myssql? So far I think the <a href="https://github.com/FriendsOfSymfony/FOSElasticaBundle" rel="nofollow">FOSElasticaBundle</a> looks the most mature, but not sure how to add search on tags there? (see 1) </li>
</ol>

<p>Thanks for the advice!</p>