python-pysqlite2 - Python interface to SQLite 3

Property Value
Distribution Ubuntu 16.04 LTS (Xenial Xerus)
Repository Ubuntu Universe amd64
Package name python-pysqlite2
Package version 2.7.0
Package release 1
Package architecture amd64
Package type deb
Installed size 125 B
Download size 33.34 KB
Official Mirror
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


Package Version Architecture Repository
python-pysqlite2_2.7.0-1_i386.deb 2.7.0 i386 Ubuntu Universe
python-pysqlite2 - - -


Name Value
libc6 >= 2.14
libsqlite3-0 >= 3.5.9
python << 2.8
python >= 2.7


Name Value
python2.7-pysqlite2 -


Name Value
python2.3-pysqlite2 -
python2.4-pysqlite2 -


Name Value
python2.3-pysqlite2 -
python2.4-pysqlite2 -


Type URL
Binary Package python-pysqlite2_2.7.0-1_amd64.deb
Source Package python-pysqlite2

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install python-pysqlite2 deb package:
    # sudo apt-get install python-pysqlite2




2015-08-16 - Joel Rosdahl <>
python-pysqlite2 (2.7.0-1) unstable; urgency=medium
* New upstream release 2.7.0
2015-06-27 - Joel Rosdahl <>
python-pysqlite2 (2.6.3-4) unstable; urgency=medium
* Bump Standards-Version to 3.9.6 (no changes)
* Make build reproducible (patch by Juan Picca) (closes: #789997)
2012-06-24 - Joel Rosdahl <>
python-pysqlite2 (2.6.3-3) unstable; urgency=low
* Don't use defunct redirector anymore
* Include searchindex.js in python-pysqlite2-doc package (closes: #678050)
* Build with hardening flags
* Use underscore.js from libjs-underscore
* Bump Standards-Version to 3.9.3
2011-06-30 - Joel Rosdahl <>
python-pysqlite2 (2.6.3-2) unstable; urgency=low
* Convert from dh_pycentral to dh_python2 (closes: #617024)
* Use debhelper compat level 8
* Bump Standards-Version to 3.9.2
* Add build-arch and build-indep targets to debian/rules
* Add description of enable_load_extension.patch
* Expanded descripiton of python-pysqlite2-doc
2011-02-20 - Joel Rosdahl <>
python-pysqlite2 (2.6.3-1) unstable; urgency=low
* New upstream version.
* Updated Standards-Version to 3.9.1.
* Added watch file.
2010-05-16 - Joel Rosdahl <>
python-pysqlite2 (2.6.0-1) unstable; urgency=low
* New upstream version.
* Changed source package format to "3.0 (quilt)".
* Updated Standards-Version to 3.8.4.
* Don't compile with debug information in the non-dbg package.
* Added missing ${misc:Depends}.
2009-10-20 - Joel Rosdahl <>
python-pysqlite2 (2.5.5-3) unstable; urgency=low
* Bumped build dependency on python-all-dev to >= 2.5.4. Closes: #551692.
2009-10-13 - Joel Rosdahl <>
python-pysqlite2 (2.5.5-2) unstable; urgency=low
* Allow building with Python 2.6. Patch by Andrew Starr-Bochicchio and
Stefano Zacchiroli; thanks! Closes: #532014,#547850.
* Don't build with SQLITE_OMIT_LOAD_EXTENSION. Closes: #543252.
* Updated to Standards-Version 3.8.3.
2009-05-10 - Joel Rosdahl <>
python-pysqlite2 (2.5.5-1) unstable; urgency=low
* New upstream release.
* Updated to Standards-Version 3.8.1.
* pysqlite now by default enforces UTF-8 strings. Closes: #469644.
* Fixed build problem using new Sphinx versions. Closes: #527494.
2008-09-28 - Joel Rosdahl <>
python-pysqlite2 (2.5.0-2) unstable; urgency=low
* Moved documentation to a separate package:
python-pysqlite2-doc. Closes: #500425.

See Also

Package Description
python-pysrt_1.0.1-1_all.deb library to edit or create SubRip files (Python 2)
python-pyst_0.6.50-1_all.deb Python module for interacting with the Asterisk PBX
python-pystache_0.5.4-5_all.deb Python implementation of Mustache
python-pytango-doc_8.1.8-1_all.deb API for the TANGO control system
python-pytango_8.1.8-1_amd64.deb API for the TANGO control system (Python 2)
python-pytc_0.8-2_amd64.deb Python bindings for the Tokyo Cabinet database
python-pyte-doc_0.4.8-1_all.deb simple VTXXX-compatible terminal emulator (documentation)
python-pyte_0.4.8-1_all.deb simple VTXXX-compatible terminal emulator
python-pytest-catchlog_1.2.1-1_all.deb py.test plugin to capture test log messages
python-pytest-cov_2.2.1-1_all.deb py.test plugin to produce coverage reports
python-pytest-django_2.9.1-2_all.deb Django plugin for py.test
python-pytest-doc_2.8.7-4_all.deb Simple, powerful testing in Python - Documentation
python-pytest-httpbin_0.1.1-1_all.deb py.test plugin providing a local httpbin
python-pytest-instafail-doc_0.3.0-1_all.deb plugin for py.test that shows failures and errors instantly
python-pytest-instafail_0.3.0-1_all.deb plugin for py.test that shows failures and errors instantly