From John.Fischer@sun.com Fri Feb 15 10:17:48 2008 Received: from sunmail2sca.sfbay.sun.com (sunmail2sca [129.145.155.234]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m1FIHmY6013035 for ; Fri, 15 Feb 2008 10:17:48 -0800 (PST) Received: from nwk-avmta-2.sfbay.sun.com (nwk-avmta-2.SFBay.Sun.COM [129.145.155.6]) by sunmail2sca.sfbay.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id m1FIHmMm025166 for <@sunmail2sca.sfbay.sun.com:psarc-ext@sun.com>; Fri, 15 Feb 2008 10:17:48 -0800 (PST) Received: from pmxchannel-daemon.nwk-avmta-2.sfbay.sun.com by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JWA00205LHNKK00@nwk-avmta-2.sfbay.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Fri, 15 Feb 2008 10:17:47 -0800 (PST) Received: from sca-es-mail-1.sun.com ([192.18.43.132]) by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JWA00D7MLHMDSE0@nwk-avmta-2.sfbay.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Fri, 15 Feb 2008 10:17:46 -0800 (PST) Received: from fe-sfbay-10.sun.com ([192.18.43.129]) by sca-es-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m1FIHkWv014897 for ; Fri, 15 Feb 2008 10:17:46 -0800 (PST) Received: from conversion-daemon.fe-sfbay-10.sun.com by fe-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JWA00D01LAGLE00@fe-sfbay-10.sun.com> (original mail from John.Fischer@Sun.COM) for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Fri, 15 Feb 2008 10:17:46 -0800 (PST) Received: from [192.168.10.6] ([24.10.86.139]) by fe-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JWA001L8LHH0N60@fe-sfbay-10.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Fri, 15 Feb 2008 10:17:42 -0800 (PST) Date: Fri, 15 Feb 2008 10:17:18 -0800 From: John Fischer Subject: PSARC/2008/117 - PySQLite Sender: John.Fischer@sun.com To: psarc-ext@sun.com Cc: Darren Kenny , John Fischer Reply-to: John.Fischer@sun.com Message-id: <47B5D72E.7090302@sun.com> MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_KtxlRcnDxZ0EOqBUMq29rw)" X-PMX-Version: 5.2.0.264296 User-Agent: Thunderbird 2.0.0.4 (X11/20070622) Status: RO Content-Length: 4962 This is a multi-part message in MIME format. --Boundary_(ID_KtxlRcnDxZ0EOqBUMq29rw) Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT PSARC, I am sponsoring this fast track for Darren Kenny of the Gnome team in Dublin, Ireland. The case directory contains this proposal. I have set the timer for Friday, February 22nd, 2008. This project proposes to integrate PySQLite into a Minor release of Solaris. PySQLite is an open source DB-API 2.0-compliant [PEP-0249] database interface to SQLite for Python. SQLite is currently being reviewed within LSARC (2008/059 case). That case will most likely be superseded soon by another case that will upgrade the SQLite interfaces. I will be following any subsequent SQLite ARC developments to insure that either the subsequent case is presented or a contract filed for this case. Thanks, John --Boundary_(ID_KtxlRcnDxZ0EOqBUMq29rw) Content-type: text/plain; name=proposal.txt Content-transfer-encoding: 7BIT Content-disposition: inline; filename=proposal.txt Template Version: @(#)onepager.txt 1.35 07/11/07 SMI Copyright 2007 Sun Microsystems 1. Introduction 1.1. Project/Component Working Name: PySQLite 1.2. Name of Document Author/Supplier: Darren Kenny 1.3. Date of This Document: 01/31/08 1.3.1. Date this project was conceived: 05/08/01 1.4. Name of Major Document Customer(s)/Consumer(s): 1.4.1. The PAC or CPT you expect to review your project: Solaris PAC 1.4.2. The ARC(s) you expect to review your project: PSARC 1.4.3. The Director/VP who is "Sponsoring" this project: robert.odea@sun.com 1.4.4. The name of your business unit: OPG / OpenSource. 1.5. Email Aliases: 1.5.1. Responsible Manager: leo.binchy@sun.com 1.5.2. Responsible Engineer: darren.kenny@sun.com 1.5.3. Marketing Manager: dan.roberts@sun.com 1.5.4. Interest List: desktop-discuss@opensolaris.org 4. Technical Description: 4.1. Details: PySQLite is an open source DB-API 2.0-compliant [PEP-0249] database interface for SQLite. SQLite is a relational database management system contained in a relatively small C library. PySQLite makes this powerful embedded SQL engine available to Python programmers. It stays compatible with the Python database API specification 2.0, but also exposes most of SQLite's native API, so that it is for example possible to create user-defined SQL functions and aggregates in Python. The version being integrated is 2.4.1 4.2. Bug/RFE Number(s): None. 4.3. In Scope: See above. 4.4. Out of Scope: See above. 4.5. Interfaces: -------------------------------------------------------------------- Exported Stability Comments -------------------------------------------------------------------- SUNWpysqlite Uncommitted Package name sqlite Uncommitted Python module [PEP-2249] -------------------------------------------------------------------- Imported Stability Comments -------------------------------------------------------------------- Python 2.4.x External PSARC 2005/532 SQLite C API Volatile LSARC 2008/059 4.6. Doc Impact: Man page will be provided pointing to the on-line API documentation. 4.7. Admin/Config Impact: None. 4.8. HA Impact: None. 4.9. I18N/L10N Impact: The JDS team and the G11N are working together to evaluation and provide I18N/L10N support. 4.10. Packaging & Delivery: Adds new package, SUNWpysqlite, approx 145 KB. Package will go into SUNWCall, SUNWCXall and SUNWCprog clusters. 4.11. Security Impact: None. 4.12. Dependencies: The following versions of the imported interfaces are required: Python >= 2.3 SQLite >= 3.0.8 5. Reference Documents: PSARC 2005/532, Python migration from /usr/sfw to /usr and upgrade to v2.4.x LSARC 2007/608, Including MySQL 5.0 with Solaris [PEP-0249] http://www.python.org/peps/pep-0249.html PySQLite API http://initd.org/pub/software/pysqlite/doc/usage-guide.html --Boundary_(ID_KtxlRcnDxZ0EOqBUMq29rw)-- From John.Fischer@sun.com Wed Feb 20 16:26:19 2008 Received: from sunmail5.uk.sun.com (sunmail5.UK.Sun.COM [129.156.85.165]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m1L0QJ8P018127 for ; Wed, 20 Feb 2008 16:26:19 -0800 (PST) Received: from brm-avmta-1.central.sun.com (brm-avmta-1.Central.Sun.COM [129.147.4.11]) by sunmail5.uk.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id m1L0QGFK018225 for <@sunmail2sca.sfbay.sun.com:psarc-ext@sun.com>; Thu, 21 Feb 2008 00:26:18 GMT Received: from pmxchannel-daemon.brm-avmta-1.central.sun.com by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JWK00B01BVT1J00@brm-avmta-1.central.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Wed, 20 Feb 2008 17:26:17 -0700 (MST) Received: from brmea-mail-2.sun.com ([192.18.98.43]) by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JWK00M7CBVSF7A0@brm-avmta-1.central.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Wed, 20 Feb 2008 17:26:16 -0700 (MST) Received: from fe-amer-09.sun.com ([192.18.109.79]) by brmea-mail-2.sun.com (8.13.6+Sun/8.12.9) with ESMTP id m1L0QGOW029210 for ; Thu, 21 Feb 2008 00:26:16 +0000 (GMT) Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JWK00J01BN0J700@mail-amer.sun.com> (original mail from John.Fischer@Sun.COM) for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Wed, 20 Feb 2008 17:26:16 -0700 (MST) Received: from 129.145.154.84 ([129.145.154.84]) by mail-amer.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JWK00GJBBVRRG50@mail-amer.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Wed, 20 Feb 2008 17:26:16 -0700 (MST) Date: Wed, 20 Feb 2008 16:26:15 -0800 From: John Fischer Subject: Re: PSARC/2008/117 - PySQLite In-reply-to: <47B5D72E.7090302@sun.com> Sender: John.Fischer@sun.com To: psarc-ext@sun.com Cc: John Fischer , Darren Kenny Reply-to: John.Fischer@sun.com Message-id: <1203553574.63061.301.camel@sr1-umpk-34> MIME-version: 1.0 X-Mailer: Ximian Evolution 1.4.6.301c Content-type: text/plain Content-transfer-encoding: 7BIT X-PMX-Version: 5.2.0.264296 References: <47B5D72E.7090302@sun.com> Status: RO Content-Length: 5108 Darren, This case was approved during PSARC's open business today. Thanks, John On Fri, 2008-02-15 at 10:17, John Fischer wrote: > PSARC, > > I am sponsoring this fast track for Darren Kenny of the Gnome team > in Dublin, Ireland. The case directory contains this proposal. I > have set the timer for Friday, February 22nd, 2008. > > This project proposes to integrate PySQLite into a Minor release of > Solaris. PySQLite is an open source DB-API 2.0-compliant [PEP-0249] > database interface to SQLite for Python. SQLite is currently being > reviewed within LSARC (2008/059 case). That case will most likely > be superseded soon by another case that will upgrade the SQLite > interfaces. I will be following any subsequent SQLite ARC developments > to insure that either the subsequent case is presented or a contract > filed for this case. > > Thanks, > > John > > ______________________________________________________________________ > Template Version: @(#)onepager.txt 1.35 07/11/07 SMI > Copyright 2007 Sun Microsystems > > > 1. Introduction > 1.1. Project/Component Working Name: > > PySQLite > > 1.2. Name of Document Author/Supplier: > > Darren Kenny > > 1.3. Date of This Document: > > 01/31/08 > > 1.3.1. Date this project was conceived: > > 05/08/01 > > 1.4. Name of Major Document Customer(s)/Consumer(s): > > 1.4.1. The PAC or CPT you expect to review your project: > > Solaris PAC > > 1.4.2. The ARC(s) you expect to review your project: > > PSARC > > 1.4.3. The Director/VP who is "Sponsoring" this project: > > robert.odea@sun.com > > 1.4.4. The name of your business unit: > > OPG / OpenSource. > > 1.5. Email Aliases: > 1.5.1. Responsible Manager: > > leo.binchy@sun.com > > 1.5.2. Responsible Engineer: > > darren.kenny@sun.com > > 1.5.3. Marketing Manager: > > dan.roberts@sun.com > > 1.5.4. Interest List: > > desktop-discuss@opensolaris.org > > 4. Technical Description: > 4.1. Details: > > PySQLite is an open source DB-API 2.0-compliant [PEP-0249] database > interface for SQLite. > > SQLite is a relational database management system contained in a > relatively small C library. > > PySQLite makes this powerful embedded SQL engine available to Python > programmers. It stays compatible with the Python database API > specification 2.0, but also exposes most of SQLite's native API, so > that it is for example possible to create user-defined SQL functions > and aggregates in Python. > > The version being integrated is 2.4.1 > > 4.2. Bug/RFE Number(s): > > None. > > 4.3. In Scope: > > See above. > > 4.4. Out of Scope: > > See above. > > 4.5. Interfaces: > > -------------------------------------------------------------------- > Exported Stability Comments > -------------------------------------------------------------------- > SUNWpysqlite Uncommitted Package name > sqlite Uncommitted Python module [PEP-2249] > > > -------------------------------------------------------------------- > Imported Stability Comments > -------------------------------------------------------------------- > Python 2.4.x External PSARC 2005/532 > SQLite C API Volatile LSARC 2008/059 > > 4.6. Doc Impact: > > Man page will be provided pointing to the on-line API documentation. > > 4.7. Admin/Config Impact: > > None. > > 4.8. HA Impact: > > None. > > 4.9. I18N/L10N Impact: > > The JDS team and the G11N are working together to evaluation and > provide I18N/L10N support. > > 4.10. Packaging & Delivery: > > Adds new package, SUNWpysqlite, approx 145 KB. > Package will go into SUNWCall, SUNWCXall and SUNWCprog clusters. > > 4.11. Security Impact: > > None. > > 4.12. Dependencies: > > The following versions of the imported interfaces are required: > Python >= 2.3 > SQLite >= 3.0.8 > > 5. Reference Documents: > > PSARC 2005/532, Python migration from /usr/sfw to /usr and upgrade > to v2.4.x > > LSARC 2007/608, Including MySQL 5.0 with Solaris > > [PEP-0249] http://www.python.org/peps/pep-0249.html > > PySQLite API http://initd.org/pub/software/pysqlite/doc/usage-guide.html > > From danek.duvall@sun.com Sat Mar 1 23:15:21 2008 Received: from newsunmail1brm.central.sun.com (newsunmail1brm.Central.Sun.COM [129.147.62.245]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m227FKAa020630 for ; Sat, 1 Mar 2008 23:15:20 -0800 (PST) Received: from nwk-avmta-1.SFBay.Sun.COM (nwk-avmta-1.SFBay.Sun.COM [129.146.11.74]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id m227FIip012316 for <@sunmail2sca.sfbay.sun.com:psarc-ext@Sun.COM>; Sun, 2 Mar 2008 00:15:20 -0700 (MST) Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JX30080FDHJ3O00@nwk-avmta-1.sfbay.Sun.COM> for psarc-ext@Sun.COM (ORCPT psarc-ext@Sun.COM); Sat, 01 Mar 2008 23:15:19 -0800 (PST) Received: from dm-sfbay-02.sfbay.sun.com ([129.146.11.31]) by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JX300H6VDHIMM80@nwk-avmta-1.sfbay.Sun.COM> for psarc-ext@Sun.COM (ORCPT psarc-ext@Sun.COM); Sat, 01 Mar 2008 23:15:18 -0800 (PST) Received: from zruty.sfbay.sun.com (zruty.SFBay.Sun.COM [129.146.168.40]) by dm-sfbay-02.sfbay.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id m227FHa4062871; Sat, 01 Mar 2008 23:15:17 -0800 (PST) Received: from zruty.sfbay.sun.com (localhost [127.0.0.1]) by zruty.sfbay.sun.com (8.14.2+Sun/8.14.2) with ESMTP id m227FHTL002452; Sat, 01 Mar 2008 23:15:17 -0800 (PST) Received: (from dduvall@localhost) by zruty.sfbay.sun.com (8.14.2+Sun/8.14.2/Submit) id m227FG2L002451; Sat, 01 Mar 2008 23:15:16 -0800 (PST) Date: Sat, 01 Mar 2008 23:15:16 -0800 From: Danek Duvall Subject: Re: PSARC/2008/117 - PySQLite In-reply-to: <47B5D72E.7090302@sun.com> To: John Fischer Cc: psarc-ext@sun.com, Darren Kenny Message-id: <20080302071516.GD296@zruty.sfbay.sun.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.2.0.264296 References: <47B5D72E.7090302@sun.com> User-Agent: Mutt/1.5.16 (2007-06-27) Status: RO Content-Length: 1131 Sorry for the late question, but ... On Fri, Feb 15, 2008 at 10:17:18AM -0800, John Fischer wrote: > sqlite Uncommitted Python module [PEP-2249] I was browsing the Python 2.5 What's New document, and discovered that pysqlite is bundled with 2.5. A little more reading, and I'm concerned about your proposed module name. The history appears to be this: - pysqlite 0.x/1.x used the module name "sqlite". - pysqlite 2.x uses the module name "pysqlite2", where the "2" refers to the major version of pysqlite. - It appears that pysqlite 3.x will use "pysqlite2" as well. - Python-bundled pysqlite uses the module name "sqlite3", where the "3" refers to the SQLite version number. I think that shipping pysqlite 2.x as "sqlite" is a bad idea -- it will confuse developers who have written Python code to recognize that as the 1.x API. I'd recommend using "pysqlite2", as it appears that the difference between the Python-bundled name and the leaf-development name is at the request of the pysqlite author, and it makes sense to me to maintain that distinction. Thanks, Danek From Darren.Kenny@sun.com Mon Mar 3 01:47:39 2008 Received: from sunmail4.singapore.sun.com (sunmail4.Singapore.Sun.COM [129.158.71.19]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m239lcgC022940 for ; Mon, 3 Mar 2008 01:47:38 -0800 (PST) Received: from nwk-avmta-1.SFBay.Sun.COM (nwk-avmta-1.SFBay.Sun.COM [129.146.11.74]) by sunmail4.singapore.sun.com (8.13.4+Sun/8.13.3/ENSMAIL,v2.2) with ESMTP id m239lanc024982 for <@sunmail2sca.sfbay.sun.com:psarc-ext@sun.com>; Mon, 3 Mar 2008 17:47:37 +0800 (SGT) Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JX500F03F7BU900@nwk-avmta-1.sfbay.Sun.COM> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Mon, 03 Mar 2008 01:47:35 -0800 (PST) Received: from gmp-eb-inf-1.sun.com ([192.18.6.21]) by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JX500KCBF7A5QE0@nwk-avmta-1.sfbay.Sun.COM> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Mon, 03 Mar 2008 01:47:35 -0800 (PST) Received: from fe-emea-10.sun.com (gmp-eb-lb-2-fe3.eu.sun.com [192.18.6.12]) by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m239lXd1025482 for ; Mon, 03 Mar 2008 09:47:34 +0000 (GMT) Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JX500J01DQS7E00@fe-emea-10.sun.com> (original mail from Darren.Kenny@Sun.COM) for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Mon, 03 Mar 2008 09:47:34 +0000 (GMT) Received: from [129.150.121.192] by fe-emea-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JX500DR6F6DRD40@fe-emea-10.sun.com>; Mon, 03 Mar 2008 09:47:02 +0000 (GMT) Date: Mon, 03 Mar 2008 09:46:40 +0000 From: Darren Kenny Subject: Re: PSARC/2008/117 - PySQLite In-reply-to: <20080302071516.GD296@zruty.sfbay.sun.com> Sender: Darren.Kenny@sun.com To: Danek Duvall Cc: John Fischer , psarc-ext@sun.com Message-id: <47CBC900.3050802@Sun.COM> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-15 Content-transfer-encoding: 7BIT X-PMX-Version: 5.2.0.264296 References: <47B5D72E.7090302@sun.com> <20080302071516.GD296@zruty.sfbay.sun.com> User-Agent: Thunderbird 2.0.0.9 (X11/20080225) Status: RO Content-Length: 1875 Hi Danek, Hmm - this is my mistake - I happened to have both PySQLite 0.x/1.x and PySQLite2 installed - and the name is meant to be pysqlite2, but saying that most test programs import the module as sqlite - which is what confused me. #!/usr/bin/python import pysqlite2.dbapi2 as sqlite print sqlite.apilevel So it should have read Exported Interface --------------------------------------------------------------------------- Interface Name Stability Comments --------------------------------------------------------------------------- pysqlite2 Uncommitted Python module [PEP-2249] Thanks for catching that! Darren. Danek Duvall wrote: > Sorry for the late question, but ... > > On Fri, Feb 15, 2008 at 10:17:18AM -0800, John Fischer wrote: > >> sqlite Uncommitted Python module [PEP-2249] > > I was browsing the Python 2.5 What's New document, and discovered that > pysqlite is bundled with 2.5. A little more reading, and I'm concerned > about your proposed module name. > > The history appears to be this: > > - pysqlite 0.x/1.x used the module name "sqlite". > > - pysqlite 2.x uses the module name "pysqlite2", where the "2" refers to > the major version of pysqlite. > > - It appears that pysqlite 3.x will use "pysqlite2" as well. > > - Python-bundled pysqlite uses the module name "sqlite3", where the "3" > refers to the SQLite version number. > > I think that shipping pysqlite 2.x as "sqlite" is a bad idea -- it will > confuse developers who have written Python code to recognize that as the > 1.x API. I'd recommend using "pysqlite2", as it appears that the > difference between the Python-bundled name and the leaf-development name is > at the request of the pysqlite author, and it makes sense to me to maintain > that distinction. > > Thanks, > Danek