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.