Feature Request: URL Datatype

[ericmock]

While I realize this could be done using a set of schema constraints, it would be great to have a URL datatype that will automatically check that the entry is a properly formatted URL.

This would prevent n00bs from putting poorly formatted URLs (with things like spaces and single slashes after the colon) into a database.

[fulghum]

Thanks for the feature request @ericmock. It's not standard MySQL, but I could see this being useful.

[ericmock]

I can see you not wanting to get outside of standard MySQL. Seems like MySQL should add this too. Columns that should be URLs are so common.

[timsehn]

My worry here would be breaking clients. We rely really heavily on standard tools like DBeaver, TablePlus, etc being able to connect to Dolt in the same way they would MySQL. My worry would be that some of those would freak out.

That being said, I also want to support an image and video type for the ML use case so we'll eventually cross this bridge.