ports/databases/sqlite3/files, branch main FreeBSD ports tree databases/sqlite3: update to 3.50.2 2025-07-07T06:15:07+00:00 Philippe Audeoud jadawin@FreeBSD.org 2025-07-07T06:15:07+00:00 8af3fe5ef31bd6ab4bfddc982ca7c7dc33c8a1ab PR: 287983 
PR:		287983
databases/sqlite3: update to 3.41.0 2023-02-27T22:46:24+00:00 Pavel Volkov pavelivolkov@gmail.com 2023-02-24T09:23:48+00:00 47912ce2e613211aecf6ecdfc58681b7aca0df33 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 
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.0 2022-11-28T16:54:42+00:00 Pavel Volkov pavelivolkov@gmail.com 2022-11-28T06:45:01+00:00 5e8b3d783d2cce36c7e4f38aad7b34b4ee3d9c68 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) 
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)
databases/sqlite3: add flavor for support ICU and TCL 2021-05-06T01:29:14+00:00 Pavel Volkov pavelivolkov@gmail.com 2021-05-06T01:29:14+00:00 ec612a64353c822eabaed0dadd000cc9e3bfe17d PR: 255526 
PR:	255526
databases/sqlite3: Update to 3.35.5 2021-04-27T17:03:07+00:00 Neel Chauhan nc@FreeBSD.org 2021-04-27T17:03:07+00:00 4e00066ccb9699f670b9a3be411b13bc26a932f2 Changes: https://www.sqlite.org/releaselog/3_35_5.html PR: 255392 Submitted by: Pavel Volkov <pavelivolkov AT gmail DOT com> (maintainer) 
Changes: https://www.sqlite.org/releaselog/3_35_5.html

PR:		255392
Submitted by:	Pavel Volkov <pavelivolkov AT gmail DOT com> (maintainer)
Add sqlite_analyzer support 2021-03-14T20:33:03+00:00 Dmitry Marakasov amdmi3@FreeBSD.org 2021-03-14T20:33:03+00:00 98731c8c61019e7d02a3e07d080db5f580639ffa - Switch to more complete distfile which allows to enable TCL extensions and sqlite_analyzer - Switch to pkg-plist PR: 221735 Reported by: lapo@lapo.it Approved by: maintainer timeout (pavelivolkov@gmail.com, 3.5 years) 
- Switch to more complete distfile which allows to enable
  TCL extensions and sqlite_analyzer
- Switch to pkg-plist

PR:		221735
Reported by:	lapo@lapo.it
Approved by:	maintainer timeout (pavelivolkov@gmail.com, 3.5 years)
databases/sqlite3: fix build w/o THREADS 2020-12-11T14:01:48+00:00 Pietro Cerutti gahr@FreeBSD.org 2020-12-11T14:01:48+00:00 54bf58abce424bfe2696ebd1ca48410bec44fa46 PR: 244459 Reported by: Brian Haug <haug.bsd6114@yahoo.com> 
PR:		244459
Reported by:	Brian Haug <haug.bsd6114@yahoo.com>
Update 3.31.1 --> 3.32.0 2020-06-12T13:02:53+00:00 Cy Schubert cy@FreeBSD.org 2020-06-12T13:02:53+00:00 bc51631fc3be9479f2b0f31abe6a3bf5b68c3d77 Address multiple security vulnerabilities. PR: 247149 Reported by: spam123@bitbert.com Reminded by: emaste Approved by: Approved by: portmgr (blanket: security bugfix) MFH: 2020Q2 Security: CVE-2020-11655, CVE-2020-13434, CVE-2020-13435, CVE-2020-13630, CVE-2020-13631, CVE-2020-13632 
Address multiple security vulnerabilities.

PR:		247149
Reported by:	spam123@bitbert.com
Reminded by:	emaste
Approved by:    Approved by: portmgr (blanket: security bugfix)
MFH:		2020Q2
Security:	CVE-2020-11655, CVE-2020-13434, CVE-2020-13435,
		CVE-2020-13630, CVE-2020-13631, CVE-2020-13632
Fix PowerPC segfault. 2020-04-24T03:53:50+00:00 Cy Schubert cy@FreeBSD.org 2020-04-24T03:53:50+00:00 1ff56b9f93adcea9d7a8798bb11b78de957fdf16 The segfault fix was originally developed by our upstream, sqlite.org, to address S/390 and Sparc segfaults, both of which are big endian. Our PowerPC is also big endian, which this patch also fixes. Inspired by: src r360223 Approved by: Approved by: portmgr (blanket: run-time bugfix) Obtained from: https://www.sqlite.org/src/vinfo/04885763c4cd00cb?diff=1 https://sqlite.org/forum/forumpost/672291a5b2 
The segfault fix was originally developed by our upstream, sqlite.org,
to address S/390 and Sparc segfaults, both of which are big endian.
Our PowerPC is also big endian, which this patch also fixes.

Inspired by:	src r360223
Approved by:	Approved by: portmgr (blanket: run-time bugfix)
Obtained from:	https://www.sqlite.org/src/vinfo/04885763c4cd00cb?diff=1
		https://sqlite.org/forum/forumpost/672291a5b2
databases/sqlite3: Update to 3.26.0 2018-12-04T18:02:14+00:00 Steve Wills swills@FreeBSD.org 2018-12-04T18:02:14+00:00 739f9d054a376a53c53786abed4645f9398ab7f6 PR: 233712 Submitted by: Pavel Volkov <pavelivolkov@gmail.com> (maintainer) 
PR:		233712
Submitted by:	Pavel Volkov <pavelivolkov@gmail.com> (maintainer)