lemmy/migrations/2024-08-03-155932_increase_post_url_max_length/up.sql

-- Change the post url max limit to 2000
-- From here: https://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers#417184
ALTER TABLE post
    ALTER COLUMN url TYPE varchar(2000);

ANALYZE post (url);
Adding a URL max length lemmy error. (#4960) * Adding a URL max length error. - Also increasing the post.url max length to 2000 (seems standard) - I ran into this when fixing torrent support, which often use longer urls. * Fixing sql_format. 2024-08-04 13:45:53 +00:00			`-- Change the post url max limit to 2000`
			`-- From here: https://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers#417184`
			`ALTER TABLE post`
			`ALTER COLUMN url TYPE varchar(2000);`

Run analyze after changing post.url type (ref #4983) (#5148) * Run analyze after changing post.url type (ref #4983) * rename back --------- Co-authored-by: Dessalines <dessalines@users.noreply.github.com> 2024-11-04 13:16:54 +00:00			`ANALYZE post (url);`