Created attachment 169148 [details] Update Port: databases/sqlite3 to 3.12.1 Update port to version 3.12.1.
Created attachment 169149 [details] build log
Created attachment 169150 [details] portlint log
Changes: https://www.sqlite.org/changes.html which says: The SQLITE_DEFAULT_PAGE_SIZE is increased from 1024 to 4096. The SQLITE_DEFAULT_CACHE_SIZE is changed from 2000 to -2000 so the same amount of cache memory is used by default. See https://www.sqlite.org/pgszchng2016.html Do you as the maintainer see this as a risk-free upgrade or is more scrutiny recommended ?
Hello. I think it is safe to update. SQLITE_DEFAULT_PAGE_SIZE will be increased only for newly created databases, previously created database files will be used saved in them values. As described in https://www.sqlite.org/fileformat2.html, "The page size for a database file is determined by the 2-byte integer located at an offset of 16 bytes from the beginning of the database file." For those who like to keep the old page size can advise use pragma https://www.sqlite.org/pragma.html#pragma_page_size SQLITE_DEFAULT_CACHE_SIZE only changes the form of the recording of their value, but the size remains unchanged. Previously, it was the number of memory pages, and now - the size in Kibibytes. As described in https://www.sqlite.org/pragma.html#pragma_cache_size As described in https://www.sqlite.org/pgszchng2016.html, item 2, it is: "Not a Compatibility Break". Thank you.
Testbuilds are fine.
A commit references this bug: Author: pi Date: Wed Apr 13 15:28:26 UTC 2016 New revision: 413212 URL: https://svnweb.freebsd.org/changeset/ports/413212 Log: databases/sqlite3: 3.11.1 -> 3.12.1 Changes: https://www.sqlite.org/changes.html PR: 208674 Submitted by: Pavel Volkov <pavelivolkov@gmail.com> (maintainer) Changes: head/databases/sqlite3/Makefile head/databases/sqlite3/distinfo
Committed, thanks!