php - Symfony search with tags -

we're building application has multiple different entities pretty simple name & description , specific stuff.

now want add tags, purpose of adding search keywords. (there tag cloud somewhere, that's easy)

i've been reading on different ways proper search. solutions lucene, elastic, mysql fulltext match against , more.

does have experience share on best solution application this?

1. should put tags in same table in string/array field? use seperate table? i've found doctrineextensions-taggable seems pretty decent , make easy make tagcloud too.
2. for proper search on name, description & tags, what's best solution? lucene? elastic? myssql? far think foselasticabundle looks mature, not sure how add search on tags there? (see 1)

thanks advice!

"what's best..." not way ask here , either opinionated answers or none @ all.

so here opinionated answer:

if have small set can surely run mysql , match against (you need teach doctrine how use it!). it's straight forward thing because have doctrine , need teach little bit of stuff. yeah, gedmo taggable , bit of own doctrine extension , have queries.

if searchable database larger want switch proper search engine elastic or solr or whatever else.

what need there called "faceted search" (or in elasticsearch called "aggregations" nowadays).

more infos faceted search find on wikipedia example.

yes, proper search engine cooler , faster , flashy, if work on on schedule , first time, might not best solution.