Re: Proposal to add a new URL data type. - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Proposal to add a new URL data type.
Date
Msg-id bd31499f-3185-4923-a4ea-7610a0985209@eisentraut.org
Whole thread Raw
Responses Re: Proposal to add a new URL data type.
Re: Proposal to add a new URL data type.
List pgsql-hackers
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.




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: attndims, typndims still not enforced, but make the value within a sane threshold
Next
From: "Euler Taveira"
Date:
Subject: Re: doc: Mention clock synchronization recommendation for hot_standby_feedback