프로젝트
GitHub에서 보기
ChuckHend/pg_later
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
Originalpg_later
Execute SQL now and get the results later.
A postgres extension to execute queries asynchronously. Built on pgmq.
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"
}
관련 프로젝트 살펴보기
불러오는 중…