databases/sqlite33.53.4,1

databases/sqlite3: Update to 3.53.4

Changes:	https://sqlite.org/news.html

databases/sqlite3: Update to 3.53.3

- Update MASTER_SITES
- Update WWW
- Simplify USES=cpe
- Sort CPPFLAGS
- Remove STRIP option
- Remove post-fetch:
- Use EXAMPLESDIR
- Cosmetic change

Changes:	https://sqlite.org/news.html

databases/*: Add CPE info

databases/sqlite3: Fix tcl flavor

Reference:	https://github.com/sqlite/sqlite/commit/d961d49971f241652cff7628a22335ea85b237b8
		https://github.com/sqlite/sqlite/commit/a3fcd7c79e827f98ac01fb83ee91848096fbb11c

databases/sqlite3: Update to 3.53.1

- Take maintainership

Changes:	https://www.sqlite.org/news.html
PR:		295137
Approved by:	maintainer (timeout, 16 days)

databases/sqlite3: Enable SESSION option by default

- Update WWW
- Add LICENSE_FILE
- Remove unnecessary substitution
- Remove unnecessary double quotation mark
- Bump PORTREVISION for package change

PR:		290588
Approved by:	maintainer (timeout, 14 days)

databases/sqlite3: security update to 3.50.4

Changes per <https://sqlite.org/changes.html>:

2025-07-30 (3.50.4)

  1 Fix two long-standings cases of the use of uninitialized variables
    in obscure circumstances.

2025-07-17 (3.50.3)

  1 Fix a possible memory error that can occur if a query is made
    against against FTS5 index that has been deliberately corrupted in a
    very specific way.
  2 Fix the parser so that it ignored SQL comments in all places of a
    CREATE TRIGGER statement. This resolves a problem that was introduced by
    the introduction of the SQLITE_DBCONFIG_ENABLE_COMMENTS feature in
    version 3.49.0.
  3 Fix an incorrect answer due to over-optimization of an AND operator.
    Forum post f4878de3e.
  4 Fix minor makefile issues and documentation typos.

While here, install sqlite_cfg.h

The 3.51.0 update is left for the maintainer or other interested parties;
3.51.0 was released earlier this week, on 2025-11-04.

Security:	c5889223-b4e1-11f0-ae9b-b42e991fc52e
Security:	CVE-2025-7709
Approved by:	ports-secteam@ (implicit)
MFH:		2025Q4
PR:		290588

databases/sqlite3: Pass --prefix to configure

This is required to build with a non-default ${LOCALBASE}, otherwise,
the build fails: firstly because it can't find libedit, and secondly
because it tries to install into /usr/local instead of ${PREFIX}.

PR:	288816
Reviewed by:	vvd, arrowd
Approved by:	maintainer (timeout, > 30 days)
Differential Revision:	https://reviews.freebsd.org/D52632

databases/sqlite3: Add reminder comment about linux ports

I saw several vuxml entries that lacked corresponding
linux-*-sqlite entries, or linux_base-rl9 these days (since June 2025).

Add a reminder comment near the PORTVERSION to remind people to
also add linux-*-sqlite VuXML entries as needed.

databases/*: remove useless USES=pathfix

databases/sqlite3: Fix soname, fix build if ICU=on LIBEDIT=off and READLINE=off

--soname=libsqlite3.so.${DISTVERSION} mean that users must
rebuild/reinstall all consumers of the sqlite3 after each patch-level
update.
Use --soname=legacy => soname = libsqlite3.so.0 - ABI and API didn't
changed.

PR:		287983
Approved by:	Pavel Volkov <pavelivolkov@gmail.com> (maintainer, implicit - fix runtime)
Fixes:		8af3fe5ef31b (update to 3.50.2)
Co-authored-by:	russian@russerver.org

databases/sqlite3: update to 3.50.2

PR:		287983

*/*: Bump consumers of devel/icu

...to avoid library mismatches

databases/sqlite3: remove not necessary powerpc64le knob

Not necessary since https://sqlite.org/src/info/4a2498fed4c5436f

databases/sqlite3: Update to 3.46.1

ChangeLog: https://sqlite.org/releaselog/3_46_1.html

PR:		281055
Reported by:	pavelivolkov@gmail.com (maintainer)

databases/sqlite3: Update to 3.46.0

PR:		279314

databases/sqlite3: Update to 3.45.1

PR:	277610
Approved by:	bapt
Differential Revision:	https://reviews.freebsd.org/D44299

databases/sqlite3: Impelled to share/man

Approved by:    portmgr (blanket)

databases/sqlite3: Update to 3.45.0

ChangeLog: https://sqlite.org/releaselog/3_45_0.html

 * The SQLITE_DIRECT_OVERFLOW_READ optimization is now enabled by default.
 * The use of -DSQLITE_STRICT_SUBTYPE=1 is a recommended compile-time option for
   every application that makes use of subtypes.

PR:		276472
Reported by:	pavelivolkov@gmail.com (maintainer)

devel/icu: update to 74.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-74-1
Reported by:	GitHub (watch releases)
PR:		274317
Exp-run by:	antoine (incomplete)
Approved by:	fluffy

databases/sqlite3: Update to 3.44.0

ChangeLog: https://sqlite.org/releaselog/3_44_0.html

PR:		274934
Reported by:	pavelivolkov@gmail.com (maintainer)

databases/sqlite3: Update to 3.43.1

ChangeLog: https://www.sqlite.org/releaselog/3_43_1.html

PR:		273900
Reported by:	pavelivolkov@gmail.com (maintainer)

databases/sqlite3: Update to 3.42.0

PR:		271694
Changes:	https://sqlite.org/releaselog/3_42_0.html

databases/sqlite3: Update to 3.41.2

ChangeLog: https://www.sqlite.org/releaselog/3_41_2.html

PR:		270857
Reported by:	pavelivolkov@gmail.com (maintainer)
MFH:		2023Q2	(bugfixes)

devel/icu: update to 73.1

- Temporarily switch to GitHub auto archive (release artifacts are N/A atm)

Changes:	https://github.com/unicode-org/icu/releases/tag/release-73-1
Reported by:	GitHub (watch releases)
PR:		270422
Exp-run by:	antoine

databases/sqlite3: reenable the DQS option

Due to various ports not being prepared for this change (see 20230227
entry), the DQS option of databases/sqlite3 has been reenabled as a
stop gap measure.  It is scheduled to be disabled again for good no
earlier than 20240101, giving downstream software authors more time
to fix their queries.

PR:		270064
Fixes:		47912ce2e613211aecf6ecdfc58681b7aca0df33
See also:	PR 269889, 269966, 269950

databases/sqlite3: update to 3.41.0

Disable option DQS by default.
Add a note to UPDATING about this.

See also: https://sqlite.org/quirks.html#dblquote
Changelog: https://sqlite.org/releaselog/3_41_0.html

PR:		269798
Approved by:	flo (mentor)
Differential Revision: https://reviews.freebsd.org/D38774

databases/sqlite3: Update to 3.40.1

ChangeLog: https://www.sqlite.org/releaselog/3_40_1.html

 * Fix the --safe command-line option to the CLI such that it correctly
   disallows the use of SQL functions like writefile() that can cause harmful
   side-effects.
 * Fix a potential infinite loop in the memsys5 alternative memory allocator.
   This bug was introduced by a performance optimization in version 3.39.0.

 * Various other obscure fixes.

PR:		268762
Reported by:	pavelivolkov@gmail.com (maintainer)
MFH:		2023Q1 (bugfix release)

databases/sqlite3: Update to 3.40.0

ChangeLog: https://www.sqlite.org/releaselog/3_40_0.html

 * Add support for compiling SQLite to WASM and running it in web browsers.
 * Add the recovery extension that might be able to recover some content from a
   corrupt database file.
 * Query planner enhancements:
 * A new typedef named sqlite3_filename is added and used to represent the name
   of a database file.
 * Add the sqlite3_value_encoding() interface.
 * Security enhancement: SQLITE_DBCONFIG_DEFENSIVE is augmented to prohibit
   changing the schema_version.
 * Enhancements to the PRAGMA integrity_check statement:
 * Enhance the VACUUM INTO statement so that it honors the PRAGMA synchronous
   setting.
 * Enhance the sqlite3_strglob() and sqlite3_strlike() APIs
 * Provide the new SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting
   the size of memory allocations.
 * Change the algorithm used by SQLite's built-in pseudo-random number
   generator (PRNG) from RC4 to Chacha20.
 * Allow two or more indexes to have the same name as long as they are all in
   separate schemas.
 * Miscellaneous performance optimizations result in about 1% fewer CPU cycles
   used on typical workloads.

PR:		268012
Reported by:	pavelivolkov@gmail.com (maintainer)

devel/icu: update to 72.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-72-1
Reported by:	GitHub (watch releases)
PR:		266582
Exp-run by:	antoine

databases/sqlite3: Add missing Makefile entries

PR:	266459

databases/sqlite3: Update to 3.39.3

PR:	266459

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)

databases/sqlite3: Update to 3.39.2

Security:	CVE-2022-35737
ChangeLog:	https://www.sqlite.org/releaselog/3_39_2.html
Reported by:    pavelivolkov@gmail.com (maintainer) via delpij
MFH:		2022Q3

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
  *  Aldis Berjoza <graudeejs@gmail.com>
  *  Alessando Sagratini <ale_sagra@hotmail.com>
  *  Alex Dupre <ale@FreeBSD.org>
  *  Alex Samorukov <samm@freebsd.org>
  *  Alexander Logvinov <ports@logvinov,com>
  *  Alexander Logvinov <ports@logvinov.com>
  *  Alexander Nedotsukov <bland@FreeBSD.org>
  *  Alexander Novitsky
  *  Alexander Zhuravlev <zaa@zaa.pp.ru>
  *  Alexey Degtyarev <alexey@renatasystems.org>
  *  Alexey Dokuchaev <danfe@FreeBSD.org>
  *  Anders Nordby <anders@fix.no>
  *  Andrei Antoukh <niwi@niwi.be>
  *  Andrew McNaughton <andrew@scoop.co.nz>
  *  Andrew Pantyukhin <infofarmer@FreeBSD.org>
  *  Andrey Kostenko <andrey@kostenko.name>
  *  Andrey Simonenko
  *  Andrey Zakhvatov
  *  Anes Mukhametov <anes@anes.su>
  *  Anton Berezin <tobez@FreeBSD.org>
  *  Anton Berezin <tobez@tobez.org>
  *  Antonio Carlos Venancio Junior (<antonio@inf.ufsc.br>)
  *  Antonio Carlos Venancio Junior (<antonio@php.net>)
  *  Autrijus Tang <autrijus@autrijus.org>
  *  Babak Farrokhi <farrokhi@FreeBSD.org>
  *  Bartek Rutkowski <r@robakdesign.com>
  *  Bernard Spil <brnrd@FreeBSD.org>
  *  Brent J. Nordquist <bjn@visi.com>
  *  Cezary Morga <cm@therek.net>
  *  Cheng-Lung Sung <clsung@FreeBSD.org>
  *  Choe, Cheng-Dae
  *  Chris D. Faulhaber <jedgar@FreeBSD.org>
  *  Chris Larsen <darth@vader.dk>
  *  Damian Gerow <dgerow@afflictions.org>
  *  Daniel O'Connor
  *  Daniel Wijnands <daniel@itxl.nl>
  *  Dave Green <dg@fastmail.co.uk>
  *  David Thiel <lx@FreeBSD.org>
  *  Davíð Steinn Geirsson <david@isnic.is>
  *  Denis Generalov <gd.workbox@gmail.com>
  *  Denis Generalov <gd@rambler-co.ru>
  *  Denis Shaposhnikov <dsh@bamus.cz>
  *  Dermot Tynan <dtynan@kalopa.com>
  *  Dmitry Liakh <dliakh@ukr.net>
  *  Dmitry Sivachenko <demon@FreeBSD.org>
  *  Dmitry Sivachenko <dima@Chg.RU>
  *  Dmitry Sivachenko <mitya@yandex-team.ru>
  *  Domas Mituzas <midom@dammit.lt>
  *  Dominic Mitchell
  *  Don Owens <don@regexguy.com>
  *  Dryice Dong Liu <dryice@dryice.name>
  *  Edwin Groothuis (edwin@mavetju.org)
  *  Eric Freeman <freebsdports@chillibear.com>
  *  Espen Tagestad <espen@tagestad.no>
  *  Espen Volden aka voldern <voldern@hoeggen.net>
  *  Evan Sarmiento <bsdports@wayfair.com>
  *  Fernan Aguero <fernan@iib.unsam.edu.ar>
  *  Frank Wall <fw@moov.de>
  *  Ganbold Tsagaankhuu <ganbold@FreeBSD.org>
  *  Gary Palmer <gpalmer@FreeBSD.org>
  *  Gea-Suan Lin <gslin@gslin.org>
  *  Geraud CONTINSOUZAS <geraud@gcu.info>
  *  Gerrit Beine <tux@pinguru.net>
  *  Greg Larkin <glarkin@FreeBSD.org>
  *  Grzegorz Blach <gblach@FreeBSD.org>
  *  Hansjoerg Pehofer <hansjoerg.pehofer@uibk.ac.at>
  *  Henk van Oers <hvo.pm@xs4all.nl>
  *  Henrik Hodne <henrik@hodne.io>
  *  Hiroyuki Hanai <hanai@FreeBSD.org>
  *  Horia Racoviceanu <horia@racoviceanu.com>
  *  Hye-Shik Chang
  *  Hye-Shik Chang <perky@python.or.kr>
  *  Ilia Chipitsine <ilia@jane.cgu.chel.su>
  *  Ivan Voras <ivoras@FreeBSD.org>
  *  J.F. Dockes
  *  Jaap Boender <jaapb@kerguelen.org>
  *  Jake Smith <jake@xz.cx>
  *  James FitzGibbon <jfitz@FreeBSD.org>
  *  Janos Mohacsi <janos.mohacsi@bsd.hu>
  *  Janos.Mohacsi@bsd.hu
  *  Jason Helfman <jgh@FreeBSD.org>
  *  Jens Rehsack <rehsack@liwing.de>
  *  Jeremy Chadwick <koitsu@FreeBSD.org>
  *  Jev Björsell <ports@ecadlabs.com>
  *  Jim Ohlstein <jim@ohlste.in>
  *  Jin-Shan Tseng <tjs@cdpa.nsysu.edu.tw>
  *  Joe Horn <joehorn@gmail.com>
  *  Joe Marcus Clarke <marcus@FreeBSD.org>
  *  Johannes Meixner <johannes@perceivon.net>
  *  John Chen <johnpupu@gmail.com>
  *  John Marino <marino@FreeBSD.org>
  *  John Merryweather Cooper
  *  John Merryweather Cooper et al
  *  Jon Nistor <nistor@snickers.org>
  *  Jonathan Weiss (<jw@innerewut.de>)
  *  Jose Jachuf <jjachuf@gmail.com>
  *  Joshua D. Abraham <jabra@ccs.neu.edu>
  *  Jov <amutu@amutu.com>
  *  Jov amutu@amutu.com
  *  Jui-Nan Lin <jnlin@freebsd.cs.nctu.edu.tw>
  *  Julien Laffaye <kimelto@gmail.com>
  *  Jyun-Yan You <jyyou@cs.nctu.edu.tw>
  *  Keith Gaughan <k@sterechro.me>
  *  Kevin Bowling <kbowling@freebsd.org>
  *  Kimo <kimor79@yahoo.com>
  *  Kimura Fuyuki <fuyuki@nigredo.org>
  *  Koop Mast <kwm@FreeBSD.org>
  *  Lars Balker Rasmussen <lbr@FreeBSD.org
  *  Lars Balker Rasmussen <lbr@FreeBSD.org>
  *  Lars Eggert <larse@isi.edu>
  *  Lars Thegler <lars@thegler.dk>
  *  Lars Thegler <lth@FreeBSD.org>
  *  Li-Wen Hsu <lwhsu@FreeBSD.org>
  *  Loïc BARTOLETTI
  *  Loïc BARTOLETTI <lbartoletti@FreeBSD.org>
  *  Lubomir Marinov <lubomir_m@abv.bg>
  *  Mahdi Mokhtari <mokhi64@gmail.com>
  *  Mahlon E. Smith <mahlon@martini.nu>
  *  Marc G. Fournier <scrappy@FreeBSD.org>
  *  Mark Felder <feld@FreeBSD.org>
  *  Markus Brueffer <markus@FreeBSD.org>
  *  Martin Matuska <martin@matuska.org>
  *  Martin Matuska <mm@FreeBSD.org>
  *  Martin Wilke <miwi@FreeBSD.org>
  *  Mathieu Arnold <m@absolight.net>
  *  Matthew Seaman
  *  Matthias Andree <mandree@FreeBSD.org>
  *  Matthias Fechner <mfechner@FreeBSD.org>
  *  Matthias Petermann <matthias@petermann-it.de>
  *  Max Khon
  *  Max Khon <fjoe@FreeBSD.org>
  *  Michael Johnson <ahze@FreeBSD.org>
  *  Michael Johnson <ahze@ahze.net>
  *  Michael Winking <mwfp@foldl.net>
  *  Mikael URANKAR and Loïc BARTOLETTI
  *  Mike Carlson (carlson39@llnl.gov)
  *  Mikhail T. <michael@fun-box.ru>
  *  Mikhail Teterin
  *  Mikhail Teterin <mi@aldan.algebra.com>
  *  Mikolaj Golub <trociny@FreeBSD.org>
  *  Mirko Zinn <mail@derzinn.de>
  *  Mohammad S. Babaei <info@babaei.net>
  *  Muhammad Moinur Rahman <bofh@FreeBSD.org>
  *  Nick Hibma <n_hibma@freebsd.org>
  *  Nick Hilliard <nick@foobar.org>
  *  Nick Sayer <nsayer@FreeBSD.org>
  *  Nicola Vitale <nivit@FreeBSD.org>
  *  Nicolas Embriz <nbari@tequila.io>
  *  Nicolas de Bari Embriz <nbari@dalmp.com>
  *  Oleg Sharoiko <os@rsu.ru>
  *  Olexander Melnyk <olexander.v.melnyk@gmail.com>
  *  Oliver Eikemeier <eikemeier@fillmore-labs.com>
  *  Olivier Duchateau <duchateau.olivier@gmail.com>
  *  Palle Girgensohn <girgen@FreeBSD.org>
  *  Palle Girgensohn <girgen@partitur.se>
  *  Palle Girgensohn <girgen@pingpong.net>
  *  Parv <parv@pair.org>
  *  Pete Fritchman <petef@databits.net>
  *  Peter Avalos <pavalos@theshell.com>
  *  Philip M. Gollucci
  *  Philip M. Gollucci <philip@p6m7g8.com>
  *  Philip Stoev <philip.stoev@galeracluster.com>
  *  Pierre-Emmanuel Andre <pea@raveland.org>
  *  Pietro Cerutti <gahr@FreeBSD.org>
  *  Piotr Kubaj <pkubaj@anongoth.pl>
  *  Po-Chuan Hsieh <sunpoet@FreeBSD.org>
  *  Qing Feng <qingfeng@douban.com>
  *  Quinton Dolan <q@onthenet.com.au>
  *  Radim Kolar
  *  Rainer Hurling <rhurlin@gwdg.de>
  *  Rick Miller
  *  Robert Kruus <rob.kruus@gmail.com>
  *  Rod Taylor <ports@rbt.ca>
  *  Roland van Laar <roland@micite.net>
  *  Rong-En Fan <rafan@FreeBSD.org>
  *  Roy Boerner
  *  Rozhuk Ivan <rozhuk.im@gmail.com>
  *  Rusty Nejdl
  *  Ryan Steinmetz <rpsfa@rit.edu>
  *  Ryan Steinmetz <zi@FreeBSD.org>
  *  Ryan T. Dean <rtdean@cytherianage.net>
  *  Sam Lawrance <boris@brooknet.com.au>
  *  Scott McWhirter <scott@surreytech.co.uk>
  *  Seamus Venasse <svenasse@polaris.ca>
  *  Sean Chittenden <seanc@FreeBSD.org>
  *  Sergei Kolobov <sergei@kolobov.com>
  *  Sergei Vyshenski <svysh.fbsd@gmail.com>
  *  Sergey A. Osokin <osa@FreeBSD.org.ru>
  *  Sergey A. Osokin <osa@FreeBSD.org>
  *  Sergey Matveychuk <sem@FreeBSD.org>
  *  Sergey Skvortsov <skv@FreeBSD.org>
  *  Sergey Skvortsov <skv@protey.ru>
  *  Sevan Janiyan <venture37@geeklan.co.uk>
  *  Sheldon Hearn <sheldonh@FreeBSD.org>
  *  Stanislav Svirid <count@211.ru>
  *  Stefan Schmidt <stefan.schmidt@stadtbuch.de>
  *  Steve Wills <swills@FreeBSD.org>
  *  Steve Wills <swills@freebsd.org>
  *  Steven Kreuzer <skreuzer@FreeBSD.org>
  *  Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org>
  *  Sunpoet Po-Chuan Hsieh <sunpoet@sunpoet.net>
  *  T. William Wells <bill@twwells.com>
  *  TAKATSU Tomonari <tota@FreeBSD.org>
  *  Thierry Thomas (<thierry@pompo.net>)
  *  Thomas Gellekum <tg@FreeBSD.org>
  *  Timur I. Bakeyev <bat@cpan.org>
  *  Tom Judge <tj@FreeBSD.org>
  *  Torsten Zuehlsdorff <ports@toco-domains.de>
  *  Torsten Zuhlsdorff <ports@toco-domains.de>
  *  Toshiya Saitoh (<toshiya@saitoh.nu>)
  *  Tsung-Han Yeh <snowfly@yuntech.edu.tw>
  *  Vasil Dimov <vd@FreeBSD.org>
  *  Veniamin Gvozdikov <vg@FreeBSD.org>
  *  Vladimir Timofeev <vovkasm@gmail.com>
  *  Wen Heping
  *  Wen Heping <wen@FreeBSD.org>
  *  Wen Heping <wenheping@gmail.com>
  *  Wen heping <wenheping@gmail.com>
  *  William Grzybowski <wg@FreeBSD.org>
  *  Xin Li <delphij@FreeBSD.org>
  *  Yarema <yds@CoolRat.org>
  *  Yarema <yds@Necessitu.de>
  *  Yen-Ming Lee <leeym@FreeBSD.org>
  *  Ying-Chieh Liao <ijliao@FreeBSD.org>
  *  Yoichi NAKAYAMA <yoichi@FreeBSD.org>
  *  Yuri Victorovich <yuri@rawbw.com>
  *  Zach Thompson <hideo@lastamericanempire.com>
  *  Zach Thompson <lin-chi@lastamericanempire.com>
  *  ache@FreeBSD.org
  *  alfred
  *  alp@sfedu.ru
  *  andrew@scoop.co.nz
  *  andrey@kostenko.name
  *  chinsan
  *  chinsan <chinsan.tw@gmail.com>
  *  clive
  *  clive@FreeBSD.org
  *  clsung@dragon2.net
  *  dcf@aracnet.com
  *  elvstone@gmail.com
  *  erikhb@bgnett.no
  *  erwin@FreeBSD.org
  *  gahr
  *  ijliao
  *  ijlioa
  *  ivoras
  *  johnpupu <johnpupu@gmail.com>
  *  kirk@daycos.com
  *  kuriyama
  *  lbartoletti <lbartoletti@FreeBSD.org>
  *  loïc bartoletti <lbartoletti@FreeBSD.org>
  *  mharo@FreeBSD.org
  *  michael johnson <ahze@ahze.net>
  *  milki <milki@rescomp.berkeley.edy>
  *  mm@FreeBSD.org
  *  nbm
  *  nectar@FreeBSD.org
  *  nork@FreeBSD.org
  *  nork@cityfujisawa.ne.jp
  *  olevole@olevole.ru
  *  proler@gmail.com
  *  sergey@migsoft.com.ua
  *  sobomax
  *  spam@rm-rf.kiev.ua
  *  stas
  *  tobez
  *  tremere@cainites.net
  *  vanilla
  *  vanilla@
  *  wen@FreeBSD.org
  *  wenheping<wenheping@gmail.com>
  *  wolman@cs.washington.edu
  * # Created by Kevin Bowling <kbowling@FreeBSD.org>
  * # Created by Matthias Fechner <mfechner@FreeBSD.org>

With hat:	portmgr

databases/sqlite3: Update to 3.39

ChangeLog: https://www.sqlite.org/releaselog/3_39_0.html

 * Add (long overdue) support for RIGHT and FULL OUTER JOIN.
 * Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM
   that are equivalent to IS and IS NOT, respective, for compatibility with
   PostgreSQL and SQL standards.
 * Add a new return code (value "3") from the sqlite3_vtab_distinct() interface
   that indicates a query that has both DISTINCT and ORDER BY clauses.
 * Added the sqlite3_db_name() interface.
 * The unix os interface resolves all symbolic links in database filenames to
   create a canonical name for the database before the file is opened.
 * Defer materializing views until the materialization is actually needed, thus
   avoiding unnecessary work if the materialization turns out to never be used.
 * The HAVING clause of a SELECT statement is now allowed on any aggregate
   query, even queries that do not have a GROUP BY clause.
 * Many microoptimizations collectively reduce CPU cycles by about 2.3%.

PR:	264974
Reported by:	pavelivolkov@gmail.com (maintainer)

Fix CONFLICTS_INSTALL in the databases category

Approved by:	portmgr (implicit)

databases/sqlite3: Update to 3.38.5

ChangeLog: https://www.sqlite.org/releaselog/3_38_5.html

* Add sqldiff tool to the package

PR:	264173
Reported by:	pavelivolkov@gmail.com (maintainer)

databases/sqlite3: Update to 3.38.2

ChangeLog: https://www.sqlite.org/releaselog/3_38_3.html

PR:	263718
Reported by:	pavelivolkov@gmail.com (maintainer)

devel/icu: update to 71.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-71-1
Reported by:	GitHub (watch releases)
PR:		262654
Exp-run by:	antoine
Approved by:	fluffy

databases/sqlite3: use the right TCL even if a newer version is installed

PR:	261367

databases/sqlite3: Update to 3.37.2

PR:	261000
Reported by:	pavelivolkov@gmail.com (maintainer)

databases/sqlite3: Update to 3.37.1

PR:	260924

databases/sqlite3: unbreak fetch

3.35.5 was not released in 2022, nor have there been any SQLite
releases thus far in 2022.

Approved by: portmgr (implicit)

devel/icu: update to 70.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-70-1
Reported by:	GitHub (watch releases)
PR:		258794
Exp-run by:	antoine

databases/sqlite3: disable SQLITE_MMAP_READWRITE

Although mmap is not in use by default, this option is too specific to
enable in the system sqlite3. There are cases where the
application/developer may wish to use mmap for reads (to minimize the
sqlite pagecache), but go through the well tested (p)write routines.

databases/sqlite3: enable OS features

Enable various FreeBSD API options and go-fasters

The only one of these that raised concern is related to mmap, but this
compile time flag will not enable mmap usage on its own.

There is a test failure on ZFS with posix_fallocate(), leave that off
for now.

PR:		241385
Tested by:	kbowling (test harness https://www.sqlite.org/testing.html)
Approved by:	maintainer timeout

databases/sqlite3: Fix installation of examples in option TCL

PR:		255811
Reported by:	Pavel Volkov <pavelivolkov@gmail.com> (maintainer)

databases/sqlite3: add flavor for support ICU and TCL

PR:	255526