[Bug 208674] [maintainer] Update Port: databases/sqlite3 to 3.12.1

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=208674

--- Comment #4 from Pavel Volkov <pavelivolkov at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.