Created attachment 169148 [details]
Update Port: databases/sqlite3 to 3.12.1
Update port to version 3.12.1.
Created attachment 169149 [details]
Created attachment 169150 [details]
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 ?
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".
Testbuilds are fine.
A commit references this bug:
Date: Wed Apr 13 15:28:26 UTC 2016
New revision: 413212
databases/sqlite3: 3.11.1 -> 3.12.1
Submitted by: Pavel Volkov <email@example.com> (maintainer)