[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#429512: RFP: python2.5-pysqlite2 -- python interface to SQLite 3



Package: wnpp
Severity: wishlist


* Package name    : python2.5-pysqlite2
  Version         : 2.3.3
  Upstream Author : Gerhard Häring <gh@ghaering.de>
* URL             : http://www.initd.org/tracker/pysqlite
* License         : 
    Copyright (c) 2004 Gerhard Häring

    This software is provided 'as-is', without any express or implied
    warranty. In no event will the authors be held liable for any
    damages arising from the use of this software.

    Permission is granted to anyone to use this software for any
    purpose, including commercial applications, and to alter it and
    redistribute it freely, subject to the following restrictions:

        1. The origin of this software must not be misrepresented; you
           must not claim that you wrote the original software. If you
           use this software in a product, an acknowledgment in the
           product documentation would be appreciated but is not
           required.

        2. Altered source versions must be plainly marked as such, and
           must not be misrepresented as being the original software.

        3. This notice may not be removed or altered from any source
           distribution.
  Programming Lang: Python
  Description     : python interface to SQLite 3

pysqlite is a DB-API 2.0-compliant database interface for SQLite.

This package is built against SQLite 3. For an interface to SQLite 2, see the package python-sqlite. An alternative Python SQLite 3 module is packaged as python-apsw.

SQLite is a relational database management system contained in a relatively small C library. It is a public domain project created by D. Richard Hipp. Unlike the usual client-server paradigm, the SQLite engine is not a standalone process with which the program communicates, but is linked in and thus becomes an integral part of the program. The library implements most of SQL-92 standard, including transactions, triggers and most of complex queries.

pysqlite makes this powerful embedded SQL engine available to Python programmers. It stays compatible with the Python database API specification 2.0 as much as possible, 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.

If you need a relational database for your applications, or even small tools or helper scripts, pysqlite is often a good fit. It's easy to use, easy to deploy, and does not depend on any other Python libraries or platform libraries, except SQLite. SQLite itself is ported to most platforms you'd ever care about.

It's often a good alternative to MySQL, the Microsoft JET engine or the MSDE, without having any of their license and deployment issues. 


========

python-pysqlite2 already exists, but only for python2.4. Since we already have
python2.5 in etch, it would be cool to have pysqlite for that version also. 

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)



Reply to: