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
