On 2025/10/28 11:32, Marc Espie wrote:
> sqlite now advertizes a tool that can copy sqlite3 databases even while
> they're live and modified (with or without .wal files in the latest sqlite3
> version)
> 
> This is a straightforward port, mainly requires grabbing the full sqlite3
> src zip, and reaching out to compile only sqlite3_rsync.
> 
> Unless people want to tweak the sqlite3 port proper to artificially
> enable this tool, splitting the build that way feels simpler and saner.

I'd prefer to keep it self-contained rather than have another port to
keep in-sync with changes ...

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/sqlite3/Makefile,v
diff -u -p -r1.141 Makefile
--- Makefile	30 Aug 2025 11:00:11 -0000	1.141
+++ Makefile	28 Oct 2025 11:11:29 -0000
@@ -1,6 +1,8 @@
 COMMENT=	embedded SQL implementation
 
-DISTNAME=	sqlite-autoconf-3500400
+DISTNAME=	sqlite-src-3500400
+REVISION=	0
+EXTRACT_SUFX=	.zip
 PKGNAME=	sqlite3-3.50.4
 
 # XXX needs bumps every time :-/
@@ -31,17 +33,16 @@ BUILD_DEPENDS=	converters/sqlite2mdoc \
 		${MODTCL_BUILD_DEPENDS}
 
 CONFIGURE_STYLE= simple
-CONFIGURE_ARGS=	--disable-static-shell \
-		--soname=${LIBsqlite3_VERSION} \
+CONFIGURE_ARGS=	--soname=${LIBsqlite3_VERSION} \
 		--prefix=${PREFIX} \
 		--sysconfdir=${SYSCONFDIR} \
 		--mandir=${PREFIX}/man \
 		--localstatedir=${LOCALSTATEDIR} \
+		--with-tclsh=${MODTCL_BIN} \
 		--enable-all
 
 CONFIGURE_ENV=	CCACHE=None \
-		CFLAGS='${CFLAGS}' \
-		autosetup_tclsh=${MODTCL_BIN}
+		CFLAGS='${CFLAGS}'
 
 CFLAGS+=	-DSQLITE_ENABLE_UNLOCK_NOTIFY \
 		-DSQLITE_ENABLE_DBSTAT_VTAB \
@@ -51,6 +52,9 @@ CFLAGS+=	-DSQLITE_ENABLE_UNLOCK_NOTIFY \
 MAKE_FLAGS=	LDFLAGS.rpath="-Wl,-rpath,${PREFIX}/lib"
 # don't strip the binary
 MAKE_FLAGS+=	INSTALL.strip.0="${INSTALL_PROGRAM}"
+
+ALL_TARGET=	all sqldiff sqlite3_rsync
+INSTALL_TARGET=	install install-diff install-rsync
 
 post-install:
 		rm ${PREFIX}/lib/libsqlite3.so{,.0}
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/sqlite3/distinfo,v
diff -u -p -r1.81 distinfo
--- distinfo	30 Aug 2025 11:00:11 -0000	1.81
+++ distinfo	28 Oct 2025 11:11:29 -0000
@@ -1,2 +1,2 @@
-SHA256 (sqlite-autoconf-3500400.tar.gz) = o9tYehuS7l3awvZrPttBsm+chnJ1eC1Gw6CIl31qWxg=
-SIZE (sqlite-autoconf-3500400.tar.gz) = 3173050
+SHA256 (sqlite-src-3500400.zip) = t7TcBg82BTkC+2WzRLu+1ZLmSyKRomrAb+d+7Al4UOk=
+SIZE (sqlite-src-3500400.zip) = 14393367
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/sqlite3/pkg/PLIST,v
diff -u -p -r1.18 PLIST
--- pkg/PLIST	16 Jul 2025 18:43:49 -0000	1.18
+++ pkg/PLIST	28 Oct 2025 11:11:29 -0000
@@ -1,5 +1,7 @@
 @pkgpath databases/sqlite3,-main
+@bin bin/sqldiff
 @bin bin/sqlite3
+@bin bin/sqlite3_rsync
 include/sqlite3.h
 include/sqlite3ext.h
 @static-lib lib/libsqlite3.a