Change original_url field size to use one which allows bigger sizes

[Zaczero]

Summary

I need to shorten VERY long URLs (which work fine in Firefox/Chromium).
However, I face a Shlink limitation because it doesn't allow for URLs longer than 2048 characters (2KB).
I would love to be able to lift this limitation, for example, during database creation (ENV parameter?).

References

• Chrome limits URLs to a maximum length of 2MB
• Postgres TEXT for variable unlimited length
• Too long longUrl #507

[acelaya]

I'm afraid it's not easy to set database params dynamically, in a way that it's not confusing for users which would expect to be able to change that at any point in time (as it happens with the rest of the config options).

I could explore making it the biggest possible text type on every database, but that could have some impact, specially on existing instances, so I need to investigate it a bit further.

[Zaczero]

Major database solutions will only allocate as much space as needed. For example, you can check out the MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/char.html. The only thing to consider would be the possibility for abuse.

[acelaya]

Column type for long URLs has been changed to TEXT, allowing for much longer values.

This change will be released with Shlink 4.0.0

[Zaczero]

Thank You!