pguri
pguri copied to clipboard
petere
uri type for PostgreSQL
Added uri_query_json() function, to make individual uri query parameters conveniently accessible using json. This is somewhat clumsy otherwise. JSON is natural for this and also allows for repeating keys. Uriparser...
Hi, when building on Debian 11 you also need to install `postgresql-server-dev-13` otherwise the build will fail due to missing postgres.h: ``` make gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels...
Required to release on PGXN. Looks like you have [an account](https://pgxn.org/user/petere) @petere, but haven't used it in a while. :-) See the [HOWTO](https://manager.pgxn.org/howto) if you need a refresher, probably just...
Hello, I am trying to create a PG table such that: CREATE TABLE websites ( id serial primary key, site_link uri, site_sha1 uuid NOT NULL DEFAULT uuid_generate_v5(uuid_ns_url(), site_link), site_md5 uuid...
Hello, When inserting urls with accents, I run into the following error: ``` insert into urljson values ('http://www.example.com/évidemment', 200, 'text/html; charset=UTF-8', 33055); ERROR: invalid input syntax for type uri at...
And release on PGXN? ``` { "name": "uri", "abstract": "A URI type for PostgreSQL", "description": "This is an extension for PostgreSQL that provides a uri data type. The actual URI...
An interesting and useful thing to do with URIs is setting various parts of the URI, without changing other parts, say changing only the host ot the or query string....
It would be nice to have a data type `url`, which validates the scheme against `http`/`https`. It would be nicer if this extension had support for hostname validation against TLDs.
Hi @petere , Latest pguri release fails to build against v16. Some of the errors are probably GCC 13.2 errors as well. All are below. Can you please take a...
