Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:48833 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 96725 invoked from network); 18 Jun 2010 18:08:42 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 18 Jun 2010 18:08:42 -0000 Authentication-Results: pb1.pair.com smtp.mail=scott@macvicar.net; spf=permerror; sender-id=unknown Authentication-Results: pb1.pair.com header.from=scott@macvicar.net; sender-id=unknown Received-SPF: error (pb1.pair.com: domain macvicar.net from 97.107.131.220 cause and error) X-PHP-List-Original-Sender: scott@macvicar.net X-Host-Fingerprint: 97.107.131.220 whisky.macvicar.net Linux 2.6 Received: from [97.107.131.220] ([97.107.131.220:36654] helo=whisky.macvicar.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 69/85-59924-926BB1C4 for ; Fri, 18 Jun 2010 14:08:41 -0400 Received: from 174-145-6-158.pools.spcsdns.net (174-145-6-158.pools.spcsdns.net [174.145.6.158]) by whisky.macvicar.net (Postfix) with ESMTP id 252BC46A51; Fri, 18 Jun 2010 14:08:36 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v1078) Content-Type: text/plain; charset=us-ascii In-Reply-To: <007d01cb0f0e$aded25f0$09c771d0$@com> Date: Fri, 18 Jun 2010 11:08:30 -0700 Cc: "'Ilia Alshanetsky'" , "'Pierre Joye'" , Content-Transfer-Encoding: quoted-printable Message-ID: References: <007d01cb0f0e$aded25f0$09c771d0$@com> To: Jonathan Bond-Caron X-Mailer: Apple Mail (2.1078) Subject: Re: [PHP-DEV] Remove sqlite2 from trunk From: scott@macvicar.net (Scott MacVicar) On Jun 18, 2010, at 10:50 AM, Jonathan Bond-Caron wrote: > On Wed Jun 16 07:04 AM, Ilia Alshanetsky wrote: >>>> drop the Sqlite2 extensions from Trunk as they are superseded by >> the >>> Sqlite3 >>>> extensions. The sqlite2 library is no longer maintainer and the=20 >>>> migration path from version 2 to 3 is very simple. Unless there=20 >>>> any objections, I'd like to make this happen in the next week or = two. >>>=20 >=20 > I'm all for starting to use sqlite3 but I found two issues with the > migration to the new api: >=20 > a) sqlite_busy_timeout is not available in sqlite3.c >=20 > This is important for an application to return a failure right away = instead > of wait for locks to be release. > The patch looks simple since it's a wrapper for There is a patch going around, someone should commit it or I will. >=20 > SQLITE_API int sqlite3_busy_timeout(sqlite3*, int ms); >=20 > b) No persistent connections >=20 > Any reason why it wasn't migrated from sqlite.c? >=20 Persistent connections make sense if there is an actual overhead in = creating a socket etc, it doesn't really apply and is actually more = dangerous if something is left unfinished and locks the DB. - S=