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
