Date: Wed, 13 Apr 2016 13:50:50 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 208674] [maintainer] Update Port: databases/sqlite3 to 3.12.1 Message-ID: <bug-208674-13-rHEt788TGk@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-208674-13@https.bugs.freebsd.org/bugzilla/> References: <bug-208674-13@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D208674 --- Comment #4 from Pavel Volkov <pavelivolkov@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 loca= ted 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 Kibiby= tes. 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: "N= ot a Compatibility Break". Thank you. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-208674-13-rHEt788TGk>