This pull request adds a user_agent column to the clicks table, so we can keep track of where clicks are coming from and potentially filter out non-user sources, like iMessage previews or other crawlers.
Since it seems like some user agent strings can potentially be quite long, I've truncated values placed in this column to 255 characters, which is more than enough for the Facebook/Twitter/iMessage user agent we're looking to filter and most other "normal" values.
This pull request adds a
user_agentcolumn to the clicks table, so we can keep track of where clicks are coming from and potentially filter out non-user sources, like iMessage previews or other crawlers.Since it seems like some user agent strings can potentially be quite long, I've truncated values placed in this column to 255 characters, which is more than enough for the Facebook/Twitter/iMessage user agent we're looking to filter and most other "normal" values.
References #37.