pgsql-http
pgsql-http copied to clipboard
pramsey
HTTP client for PostgreSQL, retrieve a web page from inside the database.
async calls
Hi. Right now I'm working on an entirely stored procedure based coordination framework called pgtask. Think of it as a centralized cron for controlling database task execution in complex environments;...
The GUC system doesn't require the variable names to be preconfigured if they are under a prefix, so the following works: ``` http=# set http.foobar = 'this'; SET http=# show...
Use case: Sending emails via Mailgun. https://documentation.mailgun.com/en/latest/user_manual.html#sending-via-api https://curl.haxx.se/libcurl/c/curl_mime_init.html
I think PostgreSQL 17 is ahead enough that it's worthwhile to start testing. So far no compile issues.
Huge thanks for this library. Adding _how can we set ssl certificate_ would made our readme.md well documented. ``` create extension http; SELECT http_set_curlopt('CURLOPT_CAINFO', 'C:/Program Files/PostgreSQL/15/ssl/certs/ca-bundle.crt'); SET http.timeout_msec = 5000;...
Hi, I know this is probably a long shot and not many people would use this, but I figure I'll ask just in case. Would you consider including the information...
Hi all, I have a use case where I would like to use the CURLOPT_SSLKEY_BLOB & CURLOPT_SSLCERT_BLOB instead of CURLOPT_SSLKEY & CURLOPT_SSLCERT pointing to files on filesystem. It would be...
To satisfy ogr_fdw, I can register a windows system environment variable: CURL_CA_BUNDLE = C:\Program Files\PostgreSQL\15\ssl\certs\ca-bundle.crt So I don't have to set it each time I need to reach a https...
Hi, when try to do a post request with binary data as: http(('POST', url, headers, 'application/octet-stream', http.bytea_to_text(data))::http.http_request); It's failed to upload whole data , only few bytes received on server....
Watch out for lifetimes of objects, in particular need to switch into top memory context for the long-lived elements (context) while staying in statement context for short-lived objects.