openphoto/frontend — comment on commit 0c5c6cdf3bce51897af474375ec56afa5b8910cb
File: src/configs/upgrade/db/mysql/mysql-schema-1.0.0.sql line 100
By jmathai:

Tags as `TEXT` has two problems.

1. The minimum word length is 4 by default so user's will need access to my.cnf to use tags < 4 characters.
1. Keeping track of private and public tags is more difficult.

I think we should still keep a list of tags in this table. We can change this to `VARCHAR` since it doesn't need a `FULL TEXT` index on it. This would be used specifically for display purposes. It will be easier than doing a `JOIN` and processing the resultset to flatten it to 1 row per photo.