[  etch  ] [  etch-m68k  ] [  lenny  ] [  squeeze  ] [  sid  ]
[ Source: python-pysqlite2  ]

Package: python-pysqlite2 (2.5.5-3 and others)

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.

Tags: Software Development: Python Development, SQL, Implemented in: Python, Role: Shared Library, Works with: Databases

Other Packages Related to python-pysqlite2

  • depends
  • recommends
  • suggests
  • dep: hurd [hurd-i386]
    The GNU Hurd
    also a virtual package provided by hurd-udeb
  • dep: libc0.1 (>= 2.3) [kfreebsd-amd64, kfreebsd-i386]
    GNU C Library: Shared libraries
    also a virtual package provided by libc0.1-udeb
  • dep: libc0.3 (>= 2.9) [hurd-i386]
    GNU C Library: Shared libraries
    also a virtual package provided by libc0.3-udeb
  • dep: libc6 (>= 2.3) [amd64]
    GNU C Library: Shared libraries
    also a virtual package provided by libc6-udeb
    dep: libc6 (>= 2.3.5) [powerpc]
    dep: libc6 (>= 2.3.6-6~) [i386]
    dep: libc6 (>= 2.4) [armel, mips, mipsel, s390]
    dep: libc6 (>= 2.5) [avr32, hppa]
    dep: libc6 (>= 2.5-5) [m68k]
    dep: libc6 (>= 2.6) [sparc]
  • dep: libc6.1 (>= 2.3) [alpha, ia64]
    GNU C Library: Shared libraries
    also a virtual package provided by libc6.1-udeb
  • dep: libsqlite3-0 (>= 3.6.11) [m68k]
    SQLite 3 shared library
    dep: libsqlite3-0 (>= 3.6.19) [not m68k]
  • dep: python (<< 2.6)
    An interactive high-level object-oriented language (default version)
    dep: python (>= 2.4)
  • dep: python-central (>= 0.6.11)
    register and build utility for Python packages

Download python-pysqlite2

Download for all available architectures
Architecture Version Package Size Installed Size Files
alpha 2.5.5-3 68.2 kB308 kB [list of files]
amd64 2.5.5-3 66.4 kB276 kB [list of files]
armel 2.5.5-3 58.8 kB244 kB [list of files]
avr32 (unofficial port) 2.5.5-3 55.0 kB220 kB [list of files]
hppa 2.5.5-3 67.5 kB272 kB [list of files]
hurd-i386 2.5.5-3 57.9 kB244 kB [list of files]
i386 2.5.5-3 59.0 kB244 kB [list of files]
ia64 2.5.5-3 86.0 kB388 kB [list of files]
kfreebsd-amd64 2.5.5-3 66.3 kB216 kB [list of files]
kfreebsd-i386 2.5.5-3 59.0 kB186 kB [list of files]
m68k (unofficial port) 2.5.5-1 57.9 kB244 kB [list of files]
mips 2.5.5-3 58.0 kB272 kB [list of files]
mipsel 2.5.5-3 57.5 kB272 kB [list of files]
powerpc 2.5.5-3 68.1 kB284 kB [list of files]
s390 2.5.5-3 67.4 kB268 kB [list of files]
sparc 2.5.5-3 59.1 kB260 kB [list of files]