{"repo":"supabase/pg_net","free":true,"listed":false,"github":"https://github.com/supabase/pg_net","clone":"git clone https://github.com/supabase/pg_net.git","description":"A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL","language":"Python","stars":367,"topics":["postgres","postgresql","supabase","http-client","postgresql-extension","sql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"PG NET A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL . Requires libcurl = 7.83. Compatible with PostgreSQL = 12. --- Contents - Introduction - Technical Explanation - Installation - Configuration - Requests API - Monitoring requests - GET requests - POST requests - DELETE requests - Practical Examples - Syncing data with an external data source using triggers - Calling a serverless function every minute with PG CRON - Retrying failed requests - Contributing --- Introduction The PG NET extension enables PostgreSQL to make asynchronous HTTP/HTTPS requests in SQL. It eliminates the need for servers to continuously poll for database changes and instead allows the database to proactively notify external resources about significant events. It seamlessly integrates with triggers, cron jobs (e.g., PG CRON), and procedures, unlocking numerous possibilities. Notably, PG NET powers Supabase's Webhook functionality, highlighting its robustness and reliability. Common use cases for the PG NET extension include: - Calling external APIs - Syncing data with outside resources - Calling a serverless function when an event, such as an insert, occurred However, it is important to note that the extension has a few limitations. Currently, it only supports three types of asynchronous requests: - async http GET requests - async http POST requests with a JSON payload - async http DELETE requests Ultimately, though, PG NET offers developers more flexibili","default_branch":null,"files":null,"tree":[],"storefront":"/r/supabase","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/supabase/pg_net/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}