Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 30 Jan 2026 08:03:16 +0000
From:      Yuri Victorovich <yuri@FreeBSD.org>
To:        ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org
Subject:   git: 9da111afbf6d - main - databases/duckdb: Add options for extension mysql and postgres
Message-ID:  <697c65c4.21bbb.5ceb2bc6@gitrepo.freebsd.org>

index | next in thread | raw e-mail

The branch main has been updated by yuri:

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

commit 9da111afbf6d963deb6e94efa64320073538a3c9
Author:     Yuri Victorovich <yuri@FreeBSD.org>
AuthorDate: 2026-01-30 06:29:22 +0000
Commit:     Yuri Victorovich <yuri@FreeBSD.org>
CommitDate: 2026-01-30 08:03:13 +0000

    databases/duckdb: Add options for extension mysql and postgres
    
    Unfortunately both fail to build at the moment.
---
 databases/duckdb/Makefile | 21 +++++++++++++++++----
 databases/duckdb/distinfo |  8 +++++++-
 2 files changed, 24 insertions(+), 5 deletions(-)

diff --git a/databases/duckdb/Makefile b/databases/duckdb/Makefile
index f7decc8ccc13..dba48d4a0b42 100644
--- a/databases/duckdb/Makefile
+++ b/databases/duckdb/Makefile
@@ -1,6 +1,9 @@
 PORTNAME=	duckdb
 DISTVERSIONPREFIX=	v
 DISTVERSION=	1.4.4
+PORTREVISION=	1
+MASTER_SITES=	https://github.com/postgres/postgres/archive/refs/tags/:postgres_sources
+DISTFILES=	REL_15_13.tar.gz:postgres_sources
 CATEGORIES=	databases
 
 MAINTAINER=	yuri@FreeBSD.org
@@ -21,6 +24,8 @@ GH_TUPLE=	\
 		duckdb:duckdb-fts:39376623630a968154bef4e6930d12ad0b59d7fb:fts/extension/fts \
 		duckdb:duckdb-httpfs:13f8a814d41a978c3f19eb1dc76069489652ea6f:httpfs/extension/httpfs \
 		duckdb:duckdb-inet:fe7f60bb60245197680fb07ecd1629a1dc3d91c8:inet/extension/inet \
+		duckdb:duckdb-postgres:b9fce43bc5d36bc6db70844f28b7b146e756eb22:postgres/extension/postgres_scanner \
+		duckdb:duckdb-mysql:35d1b2cd51800096271802cfedf68e13bf7fa8cb:mysql/extension/mysql_scanner \
 		duckdb:duckdb-spatial:f129b24b4ddd4d98cfc18f88be5a344a79040e7b:spatial/extension/spatial \
 		duckdb:duckdb-sqlite:0c93d610af1e1f66292559fcf0f01a93597a98b6:sqlite/extension/sqlite_scanner \
 		duckdb:duckdb-sqlsmith:e6e6750ceb91e1869b2c736abb70d818bac73e9a:sqlsmith/extension/sqlsmith \
@@ -45,9 +50,11 @@ OPTIONS_GROUP=			EXTENSIONS
 OPTIONS_GROUP_EXTENSIONS=	AUTOCOMPLETE DELTA ICU JSON PARQUET TPCDS TPCH # in-tree extensions (in extension/)
 OPTIONS_GROUP_EXTENSIONS+=	${GH_TUPLE:C/.*extension\///:tu} # out-of-tree extensions (from GH_TUPLE)
 
-DELTA_BROKEN=	Fetches from git during build
-SPATIAL_BROKEN=	Build requires unofficial-sqlite3 dependency
-EXCEL_BROKEN=	https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292757
+DELTA_BROKEN=			Fetches from git during build
+SPATIAL_BROKEN=			Build requires unofficial-sqlite3 dependency
+EXCEL_BROKEN=			https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292757
+MYSQL_SCANNER_BROKEN=		https://github.com/duckdb/duckdb-mysql/issues/207
+POSTGRES_SCANNER_BROKEN=	https://github.com/duckdb/duckdb-postgres/issues/401
 
 EXTENSIONS_DESC=		Extensions:
 
@@ -70,14 +77,20 @@ CMAKE_ARGS+=	-DSKIP_EXTENSIONS=jemalloc # temporary? see https://github.com/duck
 SQLITE_SCANNER_CXXFLAGS=	-I${WRKSRC}/extension/sqlite_scanner/src/include # workaround for the header not being found
 ENCODINGS_CXXFLAGS=		-I${WRKSRC}/extension/encodings/src/include # workaround for the header not being found
 HTTPFS_CXXFLAGS=		-I${WRKSRC}/extension/httpfs/src/include # workaround for the header not being found
+POSTGRES_SCANNER_USES=		localbase
+POSTGRES_SCANNER_CXXFLAGS=	-I${WRKSRC}/extension/postgres_scanner/src/include # workaround for the header not being found
+MYSQL_SCANNER_USES=		mysql:client
 
 TPCE_DESC=			Enable building of the TPC-E tool
 TPCE_CMAKE_BOOL=		BUILD_TPCE
 
 VSS_CXXFLAGS=			-I${WRKSRC}/extension/vss/src/include # workaround for the header not being found
 
-post-extract: # remove the jemalloc extension directory just in case
+post-extract:
+	# remove the jemalloc extension directory just in case
 	@${RM} -r ${WRKSRC}/extension/jemalloc
+	# create symlink to Postgres sources for the postgres_scanner extension
+	@${LN} -s ${WRKDIR}/postgres-REL_15_13 ${WRKSRC}/extension/postgres_scanner/postgres
 
 post-patch: # remove cmake files of out-of-tree extensions to build them like in-tree extensions (avoid fetching from git)
 	@${RM} ${WRKSRC}/.github/config/extensions/*.cmake
diff --git a/databases/duckdb/distinfo b/databases/duckdb/distinfo
index cd68450a760e..437543f78bdb 100644
--- a/databases/duckdb/distinfo
+++ b/databases/duckdb/distinfo
@@ -1,4 +1,6 @@
-TIMESTAMP = 1769491985
+TIMESTAMP = 1769753638
+SHA256 (REL_15_13.tar.gz) = e6d02d9da913ae9a4c528a5cfcbb2f29a5666b65ef4c06c533ce7ee77c5dd5ac
+SIZE (REL_15_13.tar.gz) = 25439632
 SHA256 (duckdb-duckdb-v1.4.4_GH0.tar.gz) = 43645e15419c6539bae6915ba397de6569e4a7ca0d502be95d653a78fdb0bece
 SIZE (duckdb-duckdb-v1.4.4_GH0.tar.gz) = 98344585
 SHA256 (duckdb-duckdb-encodings-b5a547ec74fad87698ed3142033d7b9cf86e0b2f_GH0.tar.gz) = cc331c6336c3ec95f3ed97040c89407dc7c2f68f7a02a3e679606dfe97dcf66e
@@ -11,6 +13,10 @@ SHA256 (duckdb-duckdb-httpfs-13f8a814d41a978c3f19eb1dc76069489652ea6f_GH0.tar.gz
 SIZE (duckdb-duckdb-httpfs-13f8a814d41a978c3f19eb1dc76069489652ea6f_GH0.tar.gz) = 105955
 SHA256 (duckdb-duckdb-inet-fe7f60bb60245197680fb07ecd1629a1dc3d91c8_GH0.tar.gz) = 7da5ce401ccfd9ff9809d14b4664c8c59d4e8c0adae5f2b47ee251dd70adf832
 SIZE (duckdb-duckdb-inet-fe7f60bb60245197680fb07ecd1629a1dc3d91c8_GH0.tar.gz) = 63831
+SHA256 (duckdb-duckdb-postgres-b9fce43bc5d36bc6db70844f28b7b146e756eb22_GH0.tar.gz) = 6a454405b93b6c9e1472c751f72585be7276197614495a8a3989cb8e60ffdbbe
+SIZE (duckdb-duckdb-postgres-b9fce43bc5d36bc6db70844f28b7b146e756eb22_GH0.tar.gz) = 259079
+SHA256 (duckdb-duckdb-mysql-35d1b2cd51800096271802cfedf68e13bf7fa8cb_GH0.tar.gz) = 942a3fcf3242155ac30509699778359a5c11c50c5e533b123b65e5e8631b399e
+SIZE (duckdb-duckdb-mysql-35d1b2cd51800096271802cfedf68e13bf7fa8cb_GH0.tar.gz) = 2130737
 SHA256 (duckdb-duckdb-spatial-f129b24b4ddd4d98cfc18f88be5a344a79040e7b_GH0.tar.gz) = cdeb3b4c5c88242cf0a93a06eb86ba2115ee7ef577d0738a90d6e6ef0f1b7117
 SIZE (duckdb-duckdb-spatial-f129b24b4ddd4d98cfc18f88be5a344a79040e7b_GH0.tar.gz) = 44439078
 SHA256 (duckdb-duckdb-sqlite-0c93d610af1e1f66292559fcf0f01a93597a98b6_GH0.tar.gz) = 9ee19b82d3bb931ba96c5afaab4d2bae9ca0e07717ada3bdd99be2225effdd70


home | help

Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?697c65c4.21bbb.5ceb2bc6>