Here's an update to the latest sqlite3 release. With the release of 3.49.0,
they changed to build system to something that isn't compatible with our
CONFIGURE_STYLE=gnu anymore, so we need an explicit do-configure target now.

The configuration should be equivalent to the current one, and the result
works with mozilla and deno. x11/gnome/tracker was removed and I don't know
who else uses the fts5 extension.

Opinions? OK?
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/sqlite3/Makefile,v
diff -u -p -r1.135 Makefile
--- Makefile	27 Feb 2025 15:44:32 -0000	1.135
+++ Makefile	27 Feb 2025 16:13:13 -0000
@@ -1,11 +1,11 @@
 COMMENT=	embedded SQL implementation
 
-DISTNAME =	sqlite-autoconf-3480000
-PKGNAME=	sqlite3-3.48.0
-REVISION=	1
+VERSION =	3.49.1
+DISTNAME =	sqlite-autoconf-3490100
+PKGNAME=	sqlite3-${VERSION}
 
 # XXX needs bumps every time :-
-SHARED_LIBS +=  sqlite3                   37.31 # 8.6
+SHARED_LIBS +=  sqlite3                   37.32 # 8.6
 # sqlite suggests that users might like to assert() that library and header
 # versions match, so bumps are needed even if function signatures don't change.
 # ... at the current time the only one noticed is a < check (in subversion)
@@ -25,22 +25,38 @@ SITES =		${HOMEPAGE}2025/
 
 DEBUG_PACKAGES=	${BUILD_PACKAGES}
 
-CONFIGURE_STYLE= gnu
-CONFIGURE_ARGS=	--disable-static-shell
+CONFIGURE_ARGS=	--disable-static-shell \
+		--soname=${LIBsqlite3_VERSION} \
+		--prefix=${PREFIX} \
+		--sysconfdir=${SYSCONFDIR} \
+		--mandir=${PREFIX}/man \
+		--localstatedir=${LOCALSTATEDIR}
 
-# for x11/gnome/tracker
+CONFIGURE_ENV =	CCACHE=None \
+		CFLAGS='${CFLAGS}'
+
+# originally for x11/gnome/tracker
 CONFIGURE_ARGS +=	--enable-fts5
 
 # for mozilla
 CFLAGS+=	-DSQLITE_ENABLE_UNLOCK_NOTIFY \
-		-DSQLITE_ENABLE_FTS3 \
 		-DSQLITE_ENABLE_DBSTAT_VTAB \
-		-DSQLITE_ENABLE_COLUMN_METADATA=1 \
-		-DSQLITE_ENABLE_SESSION \
-		-DSQLITE_ENABLE_PREUPDATE_HOOK
+		-DSQLITE_ENABLE_COLUMN_METADATA
+
+CONFIGURE_ARGS +=	--enable-fts4 \
+			--enable-fts3
+
+# for deno
+CONFIGURE_ARGS +=	--enable-session
 
 BUILD_DEPENDS =	converters/sqlite2mdoc
+do-configure:
+		cd ${WRKSRC} && \
+		${CONFIGURE_ENV} ./configure ${CONFIGURE_ARGS}
+
 post-install:
+		mv ${PREFIX}/lib/libsqlite3.so.{${VERSION},${LIBsqlite3_VERSION}}
+		rm ${PREFIX}/lib/libsqlite3.so{,.0}
 		${INSTALL_DATA_DIR} ${PREFIX}/man/man3
 		${LOCALBASE}/bin/sqlite2mdoc -p ${PREFIX}/man/man3 ${PREFIX}/include/sqlite3.h
 		# fix the .pc file
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/sqlite3/distinfo,v
diff -u -p -r1.78 distinfo
--- distinfo	29 Jan 2025 17:34:14 -0000	1.78
+++ distinfo	27 Feb 2025 16:13:13 -0000
@@ -1,2 +1,2 @@
-SHA256 (sqlite-autoconf-3480000.tar.gz) = rJkvf8o5id5+0f6ZwWNj+Eh5TIwyoVja/U65J6LgL9U=
-SIZE (sqlite-autoconf-3480000.tar.gz) = 3337615
+SHA256 (sqlite-autoconf-3490100.tar.gz) = EGZC2MyzbF9zI7ZOQVLptxn3wCFaz1v+rD1ef5e1klQ=
+SIZE (sqlite-autoconf-3490100.tar.gz) = 3226385
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/sqlite3/pkg/PLIST,v
diff -u -p -r1.16 PLIST
--- pkg/PLIST	27 Oct 2024 16:09:03 -0000	1.16
+++ pkg/PLIST	27 Feb 2025 16:13:13 -0000
@@ -3,7 +3,6 @@
 include/sqlite3.h
 include/sqlite3ext.h
 @static-lib lib/libsqlite3.a
-lib/libsqlite3.la
 @lib lib/libsqlite3.so.${LIBsqlite3_VERSION}
 lib/pkgconfig/sqlite3.pc
 @man man/man1/sqlite3.1

• sqlite3-3.49.1.diff (3K)