DB-API 2.0 interface for Sqlite 3.x
Project description
pysqlite3
This library takes the SQLite module from Python 3 and packages it as a separately-installable module.
This may be useful for creating SQLite modules capable of working with other versions of SQLite (via the amalgamation option).
Additional features:
- User-defined window functions (requires SQLite >= 3.25)
- Flags and VFS an be specified when opening connection
- Incremental BLOB I/O, bpo-24905
- Improved error messages, bpo-16379
- Simplified detection of DML statements via
sqlite3_stmt_readonly
. - Sqlite native backup API (also present in standard library 3.7 and newer).
A completely self-contained binary package (wheel) is available for versions
0.4.1 and newer as pysqlite3-binary
. This package contains the latest release
of SQLite compiled with numerous extensions, and requires no external
dependencies.
Building with System SQLite
To build pysqlite3
linked against the system SQLite, run:
$ python setup.py build
Building a statically-linked library
To build pysqlite3
statically-linked against a particular version of SQLite,
you need to obtain the SQLite3 source code and copy sqlite3.c
and sqlite3.h
into the source tree.
# Download the latest release of SQLite source code and build the source
# amalgamation files (sqlite3.c and sqlite3.h).
$ wget https://www.sqlite.org/src/tarball/sqlite.tar.gz?r=release \
-O sqlite.tar.gz
$ tar xzf sqlite.tar.gz
$ cd sqlite/
$ ./configure
$ make sqlite3.c
# Copy the sqlite3 amalgamation files into the root of the pysqlite3 checkout
# and run build_static + build:
$ cp sqlite/sqlite3.[ch] pysqlite3/
$ cd pysqlite3
$ python setup.py build_static build
You now have a statically-linked, completely self-contained pysqlite3
.
Using the binary package
A binary package (wheel) is available for linux with a completely
self-contained pysqlite3
, statically-linked against the most recent release
of SQLite.
$ pip install pysqlite3-binary
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e015db65e87a1ca98315165181f920343dfa861ada9c2335afc54aada596af8c |
|
MD5 | 29ff974f2edff5fc60cbfd854f877cb2 |
|
BLAKE2b-256 | 666c4c8ffdab006599a1b4be03ef4bdece4706be8ca9b788c58ffae58b38a64c |
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 844446abe43a651ffbe28c0a58b27e5feb0e0c790fc31e23fa40a05e238bfdbc |
|
MD5 | 3e53d7b8fdc2f6468389005c20e70702 |
|
BLAKE2b-256 | 5780af9580b8319f5c3eaa043ab42771571dcf3d91173f5d300429b5cbca5782 |
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8227169b3bbb8cf697c8567d8a3ac095d240766927a134e717beeec2ef426894 |
|
MD5 | 47b1268e74c66852318da455eae4187b |
|
BLAKE2b-256 | 2987b66968e64f2013f65a53b7b977d668979db5a16f8b52817d69940b25d999 |
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 15e68bc0020cbc33b55a046f3a15bca43ac74afccef68a78a3634a46c7189c7f |
|
MD5 | 030cdca98ff71a6e9eb1f42605c6ebbd |
|
BLAKE2b-256 | 17fd3d48c62b66aa9a32a6177e7fa3617c79fd22df7168ee8bb2b67ff17920ed |
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c6094c5388b954c716aedceacf037cd39be025915005542680813ca3c6510f0b |
|
MD5 | c25b27d60afc89772b52376882ce4de4 |
|
BLAKE2b-256 | d1f31f2fdc2fc10a9d70bbd4dcd6f6c61ee9306e78dae400a503f296004330ed |
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 424378742d099e99c88f679070e6317022a4ebb8a3626582214ce0852d15c7f9 |
|
MD5 | de6a9e0c003fb42e22f09adcb30f51b6 |
|
BLAKE2b-256 | 1bd09a678853852aa1a60f9f0c0177dc8f6fd3a73cdaf9afee8b8b4ba7ccf9fa |
Hashes for pysqlite3_wheels-0.4.8-cp311-cp311-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | db93744016caf6f90f200e2f31ff2c57c8a5fac53f2d9d06900faf8b5ee62914 |
|
MD5 | d4e7b5b969a3a612201b331f575f5a81 |
|
BLAKE2b-256 | c28772533fd6f86ebf87b5abc6af356da160f6777fe4a786b43c552a6aa7a3f2 |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fb694ef16fdbdf4906db425c60b926d32bbed2e9ed3663dfe906cf0892ffbbaf |
|
MD5 | b85dd83f40112f553f3ea90678aa7b41 |
|
BLAKE2b-256 | a4990d40e43f2727965c62772a1a017cf6d61c93676279a1dcfbaff6cf72955b |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ebaefd4481b1842c4030443a332d5deb4d5fea9167febfb8f84d0d517f4a5631 |
|
MD5 | 849bd585f6d91f3501aab4f3295edcb0 |
|
BLAKE2b-256 | f8c7c28bb485589590d3336f3943279db718c66103bb10d65bf707c755ec5922 |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 494cc1bdbff522445a2b63eeb3d0037dffe3abb2ce7dd2dd88e77619ba6db9d6 |
|
MD5 | 00c7f8d527bd46b784969c5945644bfd |
|
BLAKE2b-256 | a9639dc36187b80831abe61b037a42928a06c10080f6a73891f83580464b18f3 |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b5f34ef5b3b538af5781f332b7c73f94fd0664779302c3b64425eeb2233f3ed8 |
|
MD5 | 376a9da86c1dcf82713684d3aad5caa3 |
|
BLAKE2b-256 | 92ab88f900bf57c7a6cbce7f9aec4578277dd081e6e6daa30659bffc2c16c575 |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 01960ae34d9ddd6886e19ab75fc99409fa9810ff3018671a59979d0c71109733 |
|
MD5 | 03c7c36ae4d53480ba5888d5c7043c0d |
|
BLAKE2b-256 | d638dc2732dc22f80adb23c7beecb817376f5f5c95d42b489fc813fcd6a1b44e |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7a0b8941f526b37da9fb9c9b3fe4901ef92427890c18c150a2f4b5fe5f8c6b31 |
|
MD5 | a5c4f54a03941999adba5a2992ea5566 |
|
BLAKE2b-256 | dd14bd2944f7e7cf92e6362e8d19d5d757b84f51d20a1873918b78bdab7466ec |
Hashes for pysqlite3_wheels-0.4.8-cp310-cp310-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 391a7105f75660b8b7c1761a2f8156be59f6fd0b2de88e0db6d53472c86dec5c |
|
MD5 | ae3e8c2d80431208452384a95c1d7092 |
|
BLAKE2b-256 | 6ee64ae4a6790226be4ed5ab1732e899e3c75566b7eebe5c0d1d09f0a6778a08 |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ce18ec4650db56d5cfd02473c19881991b77afe452a96d71bf18126cb01931e8 |
|
MD5 | a699381c963d537b6396a7d5dbfa8fbf |
|
BLAKE2b-256 | 780a028f053fdf19d9941d41a657ef1862cf350b0968ab2ea92702f9e7b2177a |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5eeb5338e90f329701dee9dec2b3b578b8ca121ac8d714fa5217dafe3a0b0e2e |
|
MD5 | 6e5cf2cf94e0113edaf2dfbd67e15101 |
|
BLAKE2b-256 | 69a4a533d378d600d5ab1f226cb78a209b96f5250939668898d73cbd7f057752 |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 07d8dbbf27cfc9baf1d400a89683ab38e1374e72e83cdedace83ae45ca73d9ec |
|
MD5 | 013b742be5e20d28a57a91845e408d48 |
|
BLAKE2b-256 | 6f77d5e59e937711cccd41e09504a2ce6f536e83d2f9a50016d978c6c6f618d9 |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 10d4b1554c34abc187bcfa971fc819472c5a80fb50286f3b1445ed019141ed77 |
|
MD5 | d0711383bb8446ad4ecfda0486edca14 |
|
BLAKE2b-256 | f8b5f19b89f618007bbf3498f6d8641ba8cceb0d8e4833c453a828eae255323b |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 735ca0d96a669d614333929399d6d3ece72dd2643567c54327ac47a41f35ef20 |
|
MD5 | a98ae2833b8ab4cdc56b97c5b8c8b351 |
|
BLAKE2b-256 | 4fda706864dc5d8a1b4e4359dbe74a87aa6d6bdc90382b0d1f8fa48ae404318b |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 41012eb75599f13bacedbd6ad66358a7bf33439387f826fcf4ebf129617e8553 |
|
MD5 | bd24829849467e0120d9b9129f486166 |
|
BLAKE2b-256 | 4b8840344f0f249582d945c3d792d63ad24924d15ae8e294fecadcd64d2d78fc |
Hashes for pysqlite3_wheels-0.4.8-cp39-cp39-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2a025600021b637e159be2c56be7896111e8ad711a0aee72cdf748edba252c8f |
|
MD5 | 48b32f751f3b009e3e8ee620ddb3a648 |
|
BLAKE2b-256 | 6ffcab5240e9a8dfd6253aff2b8b9be144849eaf776ef8d8347f836985eed984 |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 16942698e1d8008b11e46e1095c0e1737fd251827ab181b91137be3683c8f847 |
|
MD5 | 2c0be5def766853771b68f67ac27502f |
|
BLAKE2b-256 | f38d839af1b15f1d6f974c19f7aa206192d745cc2856edace590adf2e1a17637 |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d7d4724bc7c6267f034420b2acbe7703170a3cc8c58363038c289810fce3a545 |
|
MD5 | 90b8a3a37986519e7057d3e49c6faf32 |
|
BLAKE2b-256 | cc5bcffea65dc2209e74fa06e53f8bbc5f4110225d46d221c50ebade0b064d14 |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1552e44a0d71cfa59d7bb248e2001ce371320a946dadefbeeb47fb7140f9fc02 |
|
MD5 | fd4759d2fa7b4b27b31bc5e294253f9f |
|
BLAKE2b-256 | 2d24483b80057fada2db4769e02d4c907f2fdb0a412d1e552e5ec0ac79169c92 |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 654f402407d8c66946e1bfb14ffd8c8e880cfe5efdd19d292991b40fbae2d776 |
|
MD5 | 7c9f96195c9f6351a78e55412554a940 |
|
BLAKE2b-256 | 9c35b6de4bd095394fc5c593c67ed0f66805fb5a331621b41fbf18a712ce1f63 |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8c8c5b96bc5ed2ee69336c25105f18d9027ed51b324b2344ae299373123f589a |
|
MD5 | 5cfb2f55bc44c2b14ab41a0b6f5aa8e4 |
|
BLAKE2b-256 | 6869f9ac189f658bda05bf2269bd15242f104bd3b06dc3a7944c4e876c73fd09 |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 566c76a3fb11b2c75641300e5b07dd5ca7cd07e9923662e14a80f279458c7b3c |
|
MD5 | 63321ab5402bdf27d7fab54ed193bb87 |
|
BLAKE2b-256 | 5a39d2878b312cbe0c7a64c7956105ffc8dc0c91efd698844d5eee325553a08b |
Hashes for pysqlite3_wheels-0.4.8-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c650f76976befcf7eabf314999a174de225edf4f4a42ab251cba937fd4fd6902 |
|
MD5 | b5836a3349787e03d729ee521b160733 |
|
BLAKE2b-256 | 393d570f8632190dac03a0e6daa6d5ad05becb185489202f56ad86bb6ef38c26 |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 96c3839befc7eb84915b62ec49b1dadd8e58d8bc0a580ffa1e53dbe1f079087b |
|
MD5 | 8d17818e1490f933a9b8905123cfe3d8 |
|
BLAKE2b-256 | b06220423f4a317e0f18586531bf19cce41a3d6df72504559dc09a93048f002b |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b97d04e2b2e53482f7141f45c7d3f41b231b08aa4e7351f86bd30a9268cfe7d3 |
|
MD5 | 2b6dffa0907f46082401b68ae7d56f0f |
|
BLAKE2b-256 | 8525474a823fc649f6bf36f1eb64784b594ae74246686dcb253f25ab0897e2bf |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 234674f17c7562e7985f417f9c364db9c3760398b9b4aac2d8e22d5993af8f31 |
|
MD5 | bb7316b029a7dcdbff2b956c5827bb8f |
|
BLAKE2b-256 | 1ea595cbd0e8b6ff6e54681086e189ee7c3ebc4d7edf4bc9e77d8dc6a69eefb6 |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1ba8870a286e89f5acbd420896008048bcc19b2ec8770b0eaa91d66d5376d7fc |
|
MD5 | 8fb452ee99bb6267b206b9e3adf79031 |
|
BLAKE2b-256 | 0a6539b4db65442e6820da3b9847ee3973440e356747a1cb8566e475da0dcaac |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0d38e020ce8dcd566ab653d65f162da28cdf244543728a46213ae3e1a4b9bca3 |
|
MD5 | 700ace691cb50561523c73e1fd234e7f |
|
BLAKE2b-256 | 5b91f3193969dfaa025af00f79b8459fda036fb4da6d4d059905d1ca718ec054 |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7e1c1c62bd60319a46d7679adf5af2e415204eeeca9c8b98dfd64da3e664f73f |
|
MD5 | 780964731c7c0ef3802304584d82a827 |
|
BLAKE2b-256 | 66345e84c6bf730ec3d2c4406f14ee48b0b581114f000051993e2b39c1644af8 |
Hashes for pysqlite3_wheels-0.4.8-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 64fa3d9a75b846b4aca0668111c38e7c218efd36af615b91a791f9208e0988e9 |
|
MD5 | 1245ecb8fce6cd66029079969fd8adbe |
|
BLAKE2b-256 | 49cc2dea9bbc73b10248cbbc93a267d77c96f08cb0bc9bbb2440bd982a2a569c |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 28c42961d8ba8a8218e76c7d6066ced066db0b8d3f71ed1b1d55b6c96489634b |
|
MD5 | aa569ca3c365bba9728aae8a67e0609d |
|
BLAKE2b-256 | fe7f09080b09fe700d23230e7c20ea63f779a5bda05db9b75f8b712f213b782d |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1f68784b8aeee5f28a205a0314a53c1c0baceba7047f92ef0b2285a90ea72fc4 |
|
MD5 | 22b6ee42e4200aa1b1352f018bd8e14c |
|
BLAKE2b-256 | d6c264b6358c4cd1043980c991b3c083279d31af68f5c394678a6fe7b554ee7a |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dc93fe4f5c0093a3941f3d8215de4f68a2509b51cc97f917ebf207f44cc7256a |
|
MD5 | 2324ba9e90b595f4ef638cd7d05db565 |
|
BLAKE2b-256 | 236807223c4be7de77c3ad83a83850161a62ce0e2f530cfd9b24a9a46a272880 |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 966690ac39b5f290b6a7e1aef9c86067b1fa49c477f41f564d978c98f9dd1fac |
|
MD5 | 906db5b2b9e02e70ed51a474aa3a9d82 |
|
BLAKE2b-256 | 28d7f5d241b06755170fe12f76e2a0d327e1acae4b859d3d6457c8062b12490f |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f7711beaeb2bbeb692cc4985e7fbccc385e66843891a30f00902cf8dd62d30ce |
|
MD5 | fbe30312feb28eb4bc1c45f4add8ff6e |
|
BLAKE2b-256 | 8857e93feeec4139bba802809c4a12205b796bd42810868b112bfc124f8f58db |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 660e9f9436c9a44345a770c9896c98caa4d189f733643e2f1f62a70d706daced |
|
MD5 | a206d2a58636fd5229690512fab8a069 |
|
BLAKE2b-256 | db6860df700c92ce303d2612685d49212e67aba5aa9291c67f089ab2d365bfdf |
Hashes for pysqlite3_wheels-0.4.8-cp36-cp36m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2886efff8712309243f01546d00f58ab1a5d364f6c63717489f7ccbe5610590d |
|
MD5 | 567c9daedc004328753ad26f3978ec59 |
|
BLAKE2b-256 | 7dfb20ea6c9c1d041588bd5c694962ad53bc5658647a15d3501ee587cac3a33e |