On Sat, 30 May 2026 13:20:46 -0700 Mark Millard <[email protected]> wrote:
> On 5/30/26 12:44, Mark Millard wrote: > > On 5/30/26 06:15, void wrote: > >> On Fri, May 29, 2026 at 09:15:42AM -0700, Mark Millard wrote: > >> > >>> Note: the above are general comments that suggest the result may not be > >>> surprising. I did not analyze the specifics for the timing related to > >>> db5 and pcre . > >> > >> pcre was EoL'd on 2021-06-21 going by > >> https://www.pcre.org/original/changelog.txt > >> and marked deprecated on 29 Feb 2024 in > >> https://www.freshports.org/devel/pcre/ > >> > >> db5, according to https://www.freshports.org/databases/db5/ > >> > >> Deprecated: EOLd, potential security issues, maybe use db18 instead > >> This port expired on: 2022-06-30 > > > > The builders do not change what they build until after the ports are > > updated, for sure . . . > > > > That FreeBSD never disabled or deleted those ports tells me that folks > > were not willing/able to deal with the related handling (updating or > > disabling/deleting) of some or all of: > > > > (Note: these might not include the full transitive closure of what all > > ends up dependent via what is listed.) > > > > # pkg rquery -r FreeBSD-ports "%ro" devel/pcre | sort -u > > audio/libmp3splt > > audio/vimpc > > audio/zrythm > > benchmarks/octave-forge-benchmark > > biology/ncbi-cxx-toolkit > > databases/dbtool > > databases/sqlite-ext-pcre > > deskutils/hs-arbtt > > deskutils/xneur > > devel/aifad > > devel/bitkeeper > > devel/coccinelle > > devel/cppcheck > > devel/libast > > devel/libklel > > devel/libr3 > > devel/libslang2 > > devel/ocaml-pcre > > devel/regexx > > devel/shedskin > > devel/swig40 > > devel/tup > > dns/dnshistory > > editors/mp > > editors/ted > > emulators/open-simh > > emulators/xcpc > > games/ezquake > > games/ivan > > games/ldmud > > games/mvdsv > > graphics/blender4 > > graphics/gource > > graphics/opencollada > > lang/crystal > > lang/nim > > mail/cyrus-imapd25 > > mail/cyrus-imapd30 > > mail/cyrus-imapd32 > > mail/cyrus-imapd34 > > mail/cyrus-imapd36 > > mail/cyrus-imapd38 > > mail/rmilter > > mail/sentinel > > math/cadabra2 > > math/octave > > math/octave-forge-actuarial > > math/octave-forge-apa > > math/octave-forge-audio > > math/octave-forge-automatic-differentiation > > math/octave-forge-bim > > math/octave-forge-bioinfo > > math/octave-forge-biosig > > math/octave-forge-bsltl > > math/octave-forge-cfitsio > > math/octave-forge-cgi > > math/octave-forge-civil-engineering > > math/octave-forge-coder > > math/octave-forge-communications > > math/octave-forge-control > > math/octave-forge-csg-dataset > > math/octave-forge-csg-toolkit > > math/octave-forge-dataframe > > math/octave-forge-datatypes > > math/octave-forge-dicom > > math/octave-forge-divand > > math/octave-forge-doctest > > math/octave-forge-fda > > math/octave-forge-femoctave > > math/octave-forge-fenv > > math/octave-forge-fileio > > math/octave-forge-financial > > math/octave-forge-fl-core > > math/octave-forge-fpl > > math/octave-forge-fuzzy-logic-toolkit > > math/octave-forge-fxp > > math/octave-forge-ga > > math/octave-forge-general > > math/octave-forge-generate_html > > math/octave-forge-geographiclib > > math/octave-forge-geometry > > math/octave-forge-gsl > > math/octave-forge-hdf5oct > > math/octave-forge-ident > > math/octave-forge-image > > math/octave-forge-instrument-control > > math/octave-forge-integration > > math/octave-forge-internal-fluid-flow > > math/octave-forge-interval > > math/octave-forge-io > > math/octave-forge-joystick > > math/octave-forge-linear-algebra > > math/octave-forge-llms > > math/octave-forge-lssa > > math/octave-forge-ltfat > > math/octave-forge-mapping > > math/octave-forge-matgeom > > math/octave-forge-mboct-fem-pkg > > math/octave-forge-mboct-mbdyn-pkg > > math/octave-forge-mboct-numerical-pkg > > math/octave-forge-mboct-octave-pkg > > math/octave-forge-mccabe-thiele > > math/octave-forge-miscellaneous > > math/octave-forge-missing-functions > > math/octave-forge-mqtt > > math/octave-forge-msh > > math/octave-forge-multicore > > math/octave-forge-mvn > > math/octave-forge-mysql > > math/octave-forge-nan > > math/octave-forge-ncarray > > math/octave-forge-netcdf > > math/octave-forge-nurbs > > math/octave-forge-oct2mat > > math/octave-forge-octave-pool > > math/octave-forge-octave_boost > > math/octave-forge-octave_ffmpeg_free > > math/octave-forge-octave_mermaid_js > > math/octave-forge-octave_php_wrapper > > math/octave-forge-octave_tar > > math/octave-forge-octave_zstd > > math/octave-forge-octclip > > math/octave-forge-octproj > > math/octave-forge-odbc > > math/octave-forge-odebvp > > math/octave-forge-optics > > math/octave-forge-optim > > math/octave-forge-optiminterp > > math/octave-forge-outliers > > math/octave-forge-parallel > > math/octave-forge-pde1dm > > math/octave-forge-pkg-octave-doc > > math/octave-forge-ponchon-savarit > > math/octave-forge-prompt > > math/octave-forge-psychrometrics > > math/octave-forge-pythonic > > math/octave-forge-quaternion > > math/octave-forge-queueing > > math/octave-forge-rf > > math/octave-forge-rtree > > math/octave-forge-secs1d > > math/octave-forge-secs2d > > math/octave-forge-secs3d > > math/octave-forge-signal > > math/octave-forge-simp > > math/octave-forge-sockets > > math/octave-forge-sole > > math/octave-forge-sparsersb > > math/octave-forge-special-matrix > > math/octave-forge-splines > > math/octave-forge-sqlite > > math/octave-forge-statistics > > math/octave-forge-statistics-resampling > > math/octave-forge-stk > > math/octave-forge-strings > > math/octave-forge-struct > > math/octave-forge-symbolic > > math/octave-forge-tablicious > > math/octave-forge-tcl-octave > > math/octave-forge-timer > > math/octave-forge-tsa > > math/octave-forge-velas > > math/octave-forge-video > > math/octave-forge-websockets > > math/octave-forge-zenity > > math/octave-forge-zeromq > > math/scilab > > misc/wmweather+ > > net-mgmt/aircrack-ng > > net-mgmt/grepip > > net-mgmt/kismet > > net-mgmt/pads > > net-mgmt/xymon-server > > net-mgmt/yaf > > net/freeswitch > > net/haproxy24 > > net/honeyd > > net/libyang > > net/megacmd > > net/pacemaker2 > > net/pecl-oauth2 > > net/tinyfugue > > science/paraview > > science/zotero > > security/bsmtrace3 > > security/ftimes > > security/hydra > > security/libprelude > > security/libpreludedb > > security/pev > > security/snort > > sysutils/ccze > > sysutils/cfengine > > sysutils/cfengine-devel > > sysutils/cfengine-lts > > sysutils/cfengine324 > > sysutils/cfengine325 > > sysutils/cfengine326 > > sysutils/cfengine327 > > sysutils/ftwin > > sysutils/ganglia-monitor-core > > sysutils/gsmartcontrol > > sysutils/hardlink > > sysutils/metalog > > sysutils/rdup > > sysutils/watchman > > textproc/cgrep > > textproc/modlogan > > textproc/py-pyscss > > textproc/the_silver_searcher > > www/angie-module-lua > > www/c-icap > > www/cas > > www/e2guardian > > www/hypermail > > www/kannel > > www/kannel-sqlbox > > www/kf5-kjs > > www/mod_auth_cas > > www/nginx-full > > www/openresty > > www/rejik > > www/sarg > > www/trafficserver > > x11-wm/compton > > > > # pkg rquery -r FreeBSD-ports "%ro" databases/db18 | sort -u > > comms/xastir > > devel/rsvndump > > editors/nvi2 > > mail/vacation > > net-p2p/litecoin > > net-p2p/litecoin-daemon > > net-p2p/litecoin-utils > > net/netatalk4 > > security/pks > > www/crawl > > > > > > For reference: > > > > The context for the above is: main amd64, aarch64 might be somewhat > > different, for example. > > > > > > Also, at least one notation indicates some explicit references: > > # grep -r bdb:5 /usr/ports/ | sort -u > /usr/ports/devel/apr1/Makefile:BDB5_USES= bdb:5 > /usr/ports/mail/greyfix/Makefile:USES= bdb:5+ > /usr/ports/net-p2p/namecoin/Makefile:WALLET_USES= bdb:5+ > /usr/ports/security/heimdal/Makefile:BDB_USES= bdb:5 localbase > /usr/ports/textproc/redland/Makefile:BDB_USES= bdb:5 > > > And then there are the defaults, which is probably what your original > wording was about but I guessed incorrectly about that intent: > > # grep -ri -e bdb -e db5 /usr/ports/Mk/ | grep 5 | sort -u > /usr/ports/Mk/Uses/bdb.mk:# necessary (db5 if compatible). > /usr/ports/Mk/Uses/bdb.mk:. if ${_BDB_VER} == 5 > /usr/ports/Mk/Uses/bdb.mk:BDB_LIB_CXX_NAME= db_cxx-5.3 > /usr/ports/Mk/Uses/bdb.mk:BDB_LIB_DIR= ${LOCALBASE}/lib/db5 > /usr/ports/Mk/Uses/bdb.mk:BDB_LIB_NAME= db-5.3 > /usr/ports/Mk/Uses/bdb.mk:_BDB_OLDPLUSVERS=4+ 40+ 41+ 42+ 43+ 44+ 45+ > 46+ 47+ 48+ > /usr/ports/Mk/Uses/bdb.mk:_bdb_ARGS:= 5+ > /usr/ports/Mk/Uses/bdb.mk:db5_DEPENDS= libdb-5.3.so:databases/db5 > /usr/ports/Mk/Uses/bdb.mk:db5_FIND= ${LOCALBASE}/include/db5/db.h > /usr/ports/Mk/Uses/dbus-testing.mk: . . . (ingore this one) . . . > /usr/ports/Mk/bsd.default-versions.mk:BDB_DEFAULT?= 5 > /usr/ports/Mk/bsd.options.desc.mk:BDB1_DESC?= Berkeley DB 1.85 support > > > -- > === > Mark Millard > marklmi at yahoo.com Putting pcre aside, replacing database usually is too much a pain as a non-database-developer user. # I'm not sure it applies or not, but if db18 can sanely # handle databases created by db5, everything below are # ignorable. If databases are "centralized", things could be easier (if ignoring temporary storage usages for conversion like on PostgreSQL major version upgrades), but for "distributed around" small databases like configs and caches, many end-users doesn't know where they're stored, thus, even if "how to convert" is provided on UPDATING, "where should I seek?" issues are too huge. The conversions won't progress unless each consumer apps provide auto-transition (without previous DB software!) on first boot after switch. Maybe this would be something like depending on both old and new DB, auto-convert to new one on first run (or per updates of DB entries) and drop old DB support at some point in the future. But it's on each upstream, unmanageable. # Or anyone succeeds to seek for creating ports that does # seek and convert everything the user running it can read/ # write automatically and sanely. Regards. -- Tomoaki AOKI <[email protected]>
