From owner-freebsd-ports-bugs@freebsd.org Wed Apr 13 13:50:50 2016 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 1CA20B0FEC0 for ; Wed, 13 Apr 2016 13:50:50 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 0D09D1836 for ; Wed, 13 Apr 2016 13:50:50 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id u3DDonSB022768 for ; Wed, 13 Apr 2016 13:50:49 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 208674] [maintainer] Update Port: databases/sqlite3 to 3.12.1 Date: Wed, 13 Apr 2016 13:50:50 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: pavelivolkov@gmail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.21 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 Apr 2016 13:50:50 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D208674 --- Comment #4 from Pavel Volkov --- 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.=