git: 2d2c75682656 - main - databases/pg_incremental: New Port

From: Torsten Zuehlsdorff <tz_at_FreeBSD.org>
Date: Mon, 23 Dec 2024 21:38:49 UTC
The branch main has been updated by tz:

URL: https://cgit.FreeBSD.org/ports/commit/?id=2d2c756826560f692a85d680cc4ddf9265bf3562

commit 2d2c756826560f692a85d680cc4ddf9265bf3562
Author:     Torsten Zuehlsdorff <tz@FreeBSD.org>
AuthorDate: 2024-12-23 21:37:27 +0000
Commit:     Torsten Zuehlsdorff <tz@FreeBSD.org>
CommitDate: 2024-12-23 21:38:36 +0000

    databases/pg_incremental: New Port
    
      pg_incremental is a simple extension that helps you do fast, reliable,
      incremental batch processing in PostgreSQL.
    
      With pg_incremental, you define a pipeline with a parameterized query. The
      pipeline is executed for all existing data when created, and then periodically
      executed. If there is new data, the query is executed with parameter values that
      correspond to the new data. Depending on the type of pipeline, the parameters
      could reflect a new range of sequence values, a new time range, or a new file.
    
    Sponsored by:   P. Variablis GmbH
---
 databases/Makefile                 |  1 +
 databases/pg_incremental/Makefile  | 24 ++++++++++++++++++++++++
 databases/pg_incremental/distinfo  |  3 +++
 databases/pg_incremental/pkg-descr |  8 ++++++++
 databases/pg_incremental/pkg-plist |  3 +++
 5 files changed, 39 insertions(+)

diff --git a/databases/Makefile b/databases/Makefile
index 6c77c204f156..1402842af297 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -553,6 +553,7 @@
     SUBDIR += pg_ed25519
     SUBDIR += pg_filedump
     SUBDIR += pg_hashids
+    SUBDIR += pg_incremental
     SUBDIR += pg_partman
     SUBDIR += pg_qualstats
     SUBDIR += pg_repack
diff --git a/databases/pg_incremental/Makefile b/databases/pg_incremental/Makefile
new file mode 100644
index 000000000000..557b83145967
--- /dev/null
+++ b/databases/pg_incremental/Makefile
@@ -0,0 +1,24 @@
+PORTNAME=	pg_incremental
+PORTVERSION=	1.0.1
+DISTVERSIONPREFIX=	v
+CATEGORIES=	databases
+
+MAINTAINER=	tz@FreeBSD.org
+COMMENT=	Incremental Data Processing in PostgreSQL
+WWW=		https://github.com/CrunchyData/pg_incremental
+
+LICENSE=	PostgreSQL
+
+RUN_DEPENDS=	pg_cron>=1.6.4:databases/pg_cron
+
+USES=		gmake pgsql:10+
+
+WANT_PGSQL=	server
+
+USE_GITHUB=	yes
+GH_ACCOUNT=	CrunchyData
+
+INSTALL_TARGET=	install-strip
+MAKE_ARGS=	INSTALL="${INSTALL} -c"
+
+.include <bsd.port.mk>
diff --git a/databases/pg_incremental/distinfo b/databases/pg_incremental/distinfo
new file mode 100644
index 000000000000..450d2159d830
--- /dev/null
+++ b/databases/pg_incremental/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1734989195
+SHA256 (CrunchyData-pg_incremental-v1.0.1_GH0.tar.gz) = e3312c9a9bd9933637e73062c1bec7113372fcda68f40aebe94200e3b72be51c
+SIZE (CrunchyData-pg_incremental-v1.0.1_GH0.tar.gz) = 17567
diff --git a/databases/pg_incremental/pkg-descr b/databases/pg_incremental/pkg-descr
new file mode 100644
index 000000000000..2226ffd56556
--- /dev/null
+++ b/databases/pg_incremental/pkg-descr
@@ -0,0 +1,8 @@
+pg_incremental is a simple extension that helps you do fast, reliable,
+incremental batch processing in PostgreSQL.
+
+With pg_incremental, you define a pipeline with a parameterized query. The
+pipeline is executed for all existing data when created, and then periodically
+executed. If there is new data, the query is executed with parameter values that
+correspond to the new data. Depending on the type of pipeline, the parameters
+could reflect a new range of sequence values, a new time range, or a new file.
diff --git a/databases/pg_incremental/pkg-plist b/databases/pg_incremental/pkg-plist
new file mode 100644
index 000000000000..793d0c867585
--- /dev/null
+++ b/databases/pg_incremental/pkg-plist
@@ -0,0 +1,3 @@
+lib/postgresql/pg_incremental.so
+share/postgresql/extension/pg_incremental--1.0.sql
+share/postgresql/extension/pg_incremental.control