Imported from @nicholaschiang's original Linear issue TS-48.
Twitter shouldn't be able to track TS users: the shortened t.co links in the tweet text content shouldn't actually link to the t.co link but the expanded_url directly so as to avoid Twitter being able to track the link being opened.
Doing this will require a left outer join urls on urls.tweet_id = tweets.id and an inner join links on links.id = urls.link_id to get the expanded_url for each of the links in a tweet.
Imported from @nicholaschiang's original Linear issue TS-48.
Twitter shouldn't be able to track TS users: the shortened
t.co
links in the tweet text content shouldn't actually link to thet.co
link but theexpanded_url
directly so as to avoid Twitter being able to track the link being opened.Doing this will require a
left outer join urls on urls.tweet_id = tweets.id
and aninner join links on links.id = urls.link_id
to get theexpanded_url
for each of the links in a tweet.