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.



Reply via email to