Re: Proposal to add a new URL data type.

On 05/12/2024 15:59, Peter Eisentraut wrote:
> On 05.12.24 15:01, Alexander Borisov wrote:
>> Postgres users often store URLs in the database.  As an example, they
>> provide links to their pages on the web, analyze users posts and get
>> links for further storage and analysis.  Naturally, there is a need to
>> compare, sort, build indexes, get statistics on individual parts of
>> the URL: hosts, protocols, path and so on.
>>
>> Adding a new URL type will standardize the work with URLs in Postgres
>> and provide simple tools for manipulating the new type.
>
> Have you seen this: https://github.com/petere/pguri ?
>
> The difference there is that it uses an external library for parsing 
> the URLs, which makes the code much smaller.  Overall, the 
> functionality looks pretty similar to yours at first glance.

+1 for adding this to contrib