git: ae09fb5df889 - main - databases/pgschema: Add new port

From: Jimmy Olgeni <olgeni_at_FreeBSD.org>
Date: Mon, 22 Sep 2025 08:52:19 UTC
The branch main has been updated by olgeni:

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

commit ae09fb5df8897284dae4e15a8591200a18aebf5c
Author:     Jimmy Olgeni <olgeni@FreeBSD.org>
AuthorDate: 2025-09-16 07:06:55 +0000
Commit:     Jimmy Olgeni <olgeni@FreeBSD.org>
CommitDate: 2025-09-22 08:51:42 +0000

    databases/pgschema: Add new port
    
    pgschema is a Terraform-style, declarative schema migration workflow for
    PostgreSQL databases. It enables you to manage database schema changes
    through code with a declarative approach that tracks schema state and applies
    only necessary changes.
    
    Supports PostgreSQL versions 14, 15, 16, and 17.
    
    WWW: https://github.com/pgschema/pgschema
---
 databases/Makefile           |  1 +
 databases/pgschema/Makefile  | 21 +++++++++++++++++++++
 databases/pgschema/distinfo  |  5 +++++
 databases/pgschema/pkg-descr | 11 +++++++++++
 4 files changed, 38 insertions(+)

diff --git a/databases/Makefile b/databases/Makefile
index 54c098c83642..44c684d221db 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -577,6 +577,7 @@
     SUBDIR += pgroonga
     SUBDIR += pgrouting
     SUBDIR += pgsanity
+    SUBDIR += pgschema
     SUBDIR += pgtcl
     SUBDIR += pgtop
     SUBDIR += pguri
diff --git a/databases/pgschema/Makefile b/databases/pgschema/Makefile
new file mode 100644
index 000000000000..b879d73b9440
--- /dev/null
+++ b/databases/pgschema/Makefile
@@ -0,0 +1,21 @@
+PORTNAME=	pgschema
+DISTVERSIONPREFIX=	v
+DISTVERSION=	1.0.3
+CATEGORIES=	databases
+
+MAINTAINER=	olgeni@FreeBSD.org
+COMMENT=	Terraform-style declarative schema migration workflow for Postgres
+WWW=		https://github.com/pgschema/pgschema
+
+LICENSE=	PGSCHEMA
+LICENSE_NAME=	pgschema Community License v1.0
+LICENSE_FILE=	${WRKSRC}/LICENSE
+LICENSE_PERMS=	dist-mirror pkg-mirror auto-accept
+
+USES=		go:1.24,modules
+
+GO_MODULE=	github.com/pgschema/pgschema
+
+PLIST_FILES=	bin/pgschema
+
+.include <bsd.port.mk>
diff --git a/databases/pgschema/distinfo b/databases/pgschema/distinfo
new file mode 100644
index 000000000000..95689c69754b
--- /dev/null
+++ b/databases/pgschema/distinfo
@@ -0,0 +1,5 @@
+TIMESTAMP = 1757760575
+SHA256 (go/databases_pgschema/pgschema-v1.0.3/v1.0.3.mod) = 81d2936263ce2f1f21b9ab58271744e0bb716ff0b334e4be0d91f2a914ae363b
+SIZE (go/databases_pgschema/pgschema-v1.0.3/v1.0.3.mod) = 3364
+SHA256 (go/databases_pgschema/pgschema-v1.0.3/v1.0.3.zip) = a2d9519ca6f48e5f9716bc86e8b70051fbbb418f930ce9f6ed3b45506f120895
+SIZE (go/databases_pgschema/pgschema-v1.0.3/v1.0.3.zip) = 1079582
diff --git a/databases/pgschema/pkg-descr b/databases/pgschema/pkg-descr
new file mode 100644
index 000000000000..89f77e2fd77d
--- /dev/null
+++ b/databases/pgschema/pkg-descr
@@ -0,0 +1,11 @@
+pgschema is a Terraform-style, declarative schema migration workflow for
+PostgreSQL databases. It enables you to manage database schema changes
+through code with a declarative approach that tracks schema state and applies
+only necessary changes.
+
+Key features:
+- Declarative schema management similar to Terraform
+- Supports PostgreSQL versions 14, 15, 16, and 17
+- Tracks schema state and applies incremental changes
+- Provides table creation with LIKE syntax
+- Clean, code-driven database migration workflow