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