!gnusocial has a limit on 255 characters for many things that shouldn't have that (like URLs). This gets even worse if we want real UTF-8 encoding (#MySQL doesn't implement true UTF-8 by default and their "utf8mb4" is required for emojis). Then we can use max 191 characters - meaning we'll easily run into collisions when shortening the indexes.

So I guess I'll have to make it so all URLs are stored in TEXT fields and the indexes are sha256 sums of them or something.