Skip to content
프로젝트

ChuckHend/pg_later has 376 GitHub stars and 14 forks. GitHot measured 0 stars in 24 hours. Last checked 2026-11-22 16:31 UTC. Last push 2025-11-13.

이 수치를 측정하는 방법

측정된 스타 증가

in 24h
0
in 7 days
기록 수집 중
in 15 days
기록 수집 중
in 1 month
기록 수집 중

서로 겹치는 기간의 순증가량이며 일별 합계가 아닙니다. 측정값이 없으면 비워 둡니다. 스타는 관심도를 나타내며 품질을 보장하지 않습니다.

소개

Execute SQL now and get the results later.

데이터

README.md

Original

pg_later

Execute SQL now and get the results later.

A postgres extension to execute queries asynchronously. Built on pgmq.

PostgreSQL PGXN version

Installation

Run with docker

docker run -p 5432:5432 -e POSTGRES_PASSWORD=postgres ghcr.io/chuckhend/pglater-pg:latest

If you'd like to build from source, you can follow the instructions in CONTRIBUTING.md.

Using the extension

Initialize the extension's backend:

CREATE EXTENSION pg_later CASCADE;

SELECT pglater.init();

Execute a SQL query now:

select pglater.exec(
  'select * from pg_available_extensions order by name limit 2'
) as job_id;
 job_id 
--------
     1
(1 row)

Come back at some later time, and retrieve the results by providing the job id:

select pglater.fetch_results(1);
 pg_later_results
--------------------
{
  "query": "select * from pg_available_extensions order by name limit 2",
  "job_id": 1,
  "result": [
    {
      "name": "adminpack",
      "comment": "administrative functions for PostgreSQL",
      "default_version": "2.1",
      "installed_version": null
    },
    {
      "name": "amcheck",
      "comment": "functions for verifying relation integrity",
      "default_version": "1.3",
      "installed_version": null
    }
  ],
  "status": "success"
}

관련 프로젝트 살펴보기

불러오는 중…