项目
在 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.
实测星标增长
- 24小时
- 0
- 7天
- 正在收集历史
- 15天
- 正在收集历史
- 1个月
- 正在收集历史
各周期内的星标净变化,周期相互重叠,并非每日新增。缺失的测量保持空白。星标代表关注度,不代表软件质量。
关于
Execute SQL now and get the results later.
数据README.md
原文pg_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"
}
探索相关项目
加载中…