From nobody Mon Dec 23 21:38:49 2024 X-Original-To: dev-commits-ports-all@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4YHBGx6XHGz5hSn9; Mon, 23 Dec 2024 21:38:49 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R10" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4YHBGx4yJvz4GZ3; Mon, 23 Dec 2024 21:38:49 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1734989929; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=HEABkSNDIy8BluFxa0wlKGCAYfEKOSvEk4Uh2oYrXzM=; b=BYem+UPnp97uSSFXA8jzHYUaMs87Ly1U8EiY/69aZ4bql+dtQK5lZxkLHkDtHQeCoVxUaW QMTtKfJdLoy7MhgXfkxtezzrpCN3X5YVkH4N9CmWAdcCV/ADuH+GOn+c+6vmtWXZ/QSNUD UYARGhDqQCFdfX+9ZtJe44hTrN8v4fyI22y2Qd9d34RSGXNZIqZLCl/8DT+28bbA9YYuKJ PzozTLZVy0vjfJ+qIN/B6xLo9aHf8MdSvVuw20C9KNWa2sXdvjS+g+O9piHbO7GEV3vQ+6 LmWpXGla1lAgXobQOXTOWHrP4P9Ns3FZfFe+LgYOPvAhb2sKRlp0kHE+BuOmog== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1734989929; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=HEABkSNDIy8BluFxa0wlKGCAYfEKOSvEk4Uh2oYrXzM=; b=GugPX1cFq0fmVcAtRFvSS/EVWSSOmc5IbbV0sWCXnlH5j2h/t6+qzZ23GFAbMl/fyUldSM 9jlmx7iRrpoS08coWY1ENAMcPjl+bUTqbdRxLKyamf7PEhtxZ7UDY2hwlTB4dL7CwbOoE+ DbFLzNRkm8pqNmvRQYgLVx9YU8RMwupyvRIKc2PgycW/SXsJ1zLR28wPQg1NH1D4xKVGk1 +yOnHDYfvE9NJeOcKdFhpanMvHO6/xdx0CJk8EaurynI31ZYS46aQkEdBq03P88vUxIR56 M4+DzD8nxeLk0pg6XEXTs4RNGt6S4sax+XkRMtUMiEmW01GfNwFiPGQ7mIj0Pg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1734989929; a=rsa-sha256; cv=none; b=MwZR3RorBqZB0QpNaZOQ4tIRwwUS7luDyZBxaFCn0pBZ6udx80Dcl2dqm/0xEh812JvlPa hpiAVtowlBqS6AhLBqndcryDi2Ygna7gzlKxVQjhWEyAWDBkj+BIwMniPCOK/Zy9Dn6ebQ lpIUvckJ8RnLyoSONnAwan1VFAyAF6sPX+UHW97EJ7DEGcsj4s+p+GeXzFpN38QAcGMnWF DoNPdi/N8bmkWnYk/j2YqXQ/k09xNbNvWMVZaeKjA3Q44HbN8eV7MDAe2wJeEZJgIEvE/L ML+9D1u2fDwU6JorRoA/y1tgySeBI84dTsCviduBjgJBGiTQ5nh58PvgIlSW7Q== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4YHBGx4Ymdz19cB; Mon, 23 Dec 2024 21:38:49 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.18.1/8.18.1) with ESMTP id 4BNLcnSg066411; Mon, 23 Dec 2024 21:38:49 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 4BNLcn5u066408; Mon, 23 Dec 2024 21:38:49 GMT (envelope-from git) Date: Mon, 23 Dec 2024 21:38:49 GMT Message-Id: <202412232138.4BNLcn5u066408@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Torsten Zuehlsdorff Subject: git: 2d2c75682656 - main - databases/pg_incremental: New Port List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-all@freebsd.org Sender: owner-dev-commits-ports-all@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: tz X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 2d2c756826560f692a85d680cc4ddf9265bf3562 Auto-Submitted: auto-generated The branch main has been updated by tz: URL: https://cgit.FreeBSD.org/ports/commit/?id=2d2c756826560f692a85d680cc4ddf9265bf3562 commit 2d2c756826560f692a85d680cc4ddf9265bf3562 Author: Torsten Zuehlsdorff AuthorDate: 2024-12-23 21:37:27 +0000 Commit: Torsten Zuehlsdorff 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 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