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.5.0-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6195a652707009f36fc9394c5d4bdff04b42e8bca369d80d1555cbad59ed7328 |
|
MD5 | 72d1c73010eaaaecda5298657120223e |
|
BLAKE2b-256 | 6aa5ae104822f98c783c722aabb4d48a6f975fd07e9bb7aa5525983bc261631f |
Hashes for pysqlite3_wheels-0.5.0-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2f13a35a5c80d01c3ad10879de8d5b260103a4dd573381db26f0d117f7eeabc9 |
|
MD5 | 23b36c42267b91bd494047187bf87f4a |
|
BLAKE2b-256 | 03158b7e415143089899e628131695a011c2638c215e9587f4bf79321d84a9db |
Hashes for pysqlite3_wheels-0.5.0-cp311-cp311-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bf59830b4d505f5e90b727ae4e842421698646f1f85e3d0a7d6c3016032479cd |
|
MD5 | 159d31f132dad427546979ff3b673831 |
|
BLAKE2b-256 | 0ac39407c0266ac93a60851fc592337fc21235ac3b6af00dfe5da9163201ac9f |
Hashes for pysqlite3_wheels-0.5.0-cp311-cp311-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3018df38f9cd7795cc6feb7b44c984e04bd6f546f2fabc8dd6240aaf373e6d41 |
|
MD5 | afc1c74477e246ef801c1310651b74d5 |
|
BLAKE2b-256 | 026c544c1e754cc438dee05bce0afea585a836b128e4ceea381fe9dac15e3315 |
Hashes for pysqlite3_wheels-0.5.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a2db8791254f60e6f037476a50c8768ed3c1c682b82b6ae9cb9c5ca3d6c0b97b |
|
MD5 | 14550023073d832d3ff30a3e84e958a2 |
|
BLAKE2b-256 | b6c8ce5202d63e45eec58b9e52f693f928d0988ab58cea8489dc8e125a7b0f6a |
Hashes for pysqlite3_wheels-0.5.0-cp311-cp311-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 77afba05c59b474e4b54e7e699d818c5c9c8b39ffbb672ce376356307e8313ea |
|
MD5 | c3ca8b3688952f2949aa5987f67985f4 |
|
BLAKE2b-256 | 906c2fb0200b3189527f0df319cb508b191f8aee2d826e609e7868cf0e3d8582 |
Hashes for pysqlite3_wheels-0.5.0-cp311-cp311-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b983575fb1c1420ad69d85b9f865870a662125ae31557223aedb77dba905dd9e |
|
MD5 | 6f24becb8b15e55c325b15b78610106c |
|
BLAKE2b-256 | 1a208c17636cec5780297485c06cd3afbabeaf50ce3304e6bf8d926ea5a99ce6 |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0dc9eea99eca60e2d8633c16868618f9ce56ae1b912182fabe11325ea469eaac |
|
MD5 | ddc716d2aa6b09918b1c3588e97c0a0a |
|
BLAKE2b-256 | 67dbde55255bcee5635bb0d7a5e31c35d8d5446b36be20c67e908a9419a92b6f |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f5ee37dfdbe840609a8d456006f197a8ce6f201a9d2e76864a01237ecd30c32e |
|
MD5 | d337c2b808583d6f9f847943184c6461 |
|
BLAKE2b-256 | 5affdad105999e92ba8bce5eb005fc5952b83df310dbc0fe85d8a58f5b082d7a |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d89c0527d7fe3fe3f392b7eea4fd070591a702bf57ff57aa5bc1e76060ef3c89 |
|
MD5 | a992476ea6ae82fe61fdab062a31bcc6 |
|
BLAKE2b-256 | 5efae81bea8fb19f96dc5db6f5d626392d480dbcbd63295fd8d5bbeb7da0b4e3 |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 138dc81afaa859212ad215ae8c3d79582144fad4d61cc40637adbb81c02b094a |
|
MD5 | 0edde8220c5668d4774053eb1d08294d |
|
BLAKE2b-256 | 20d22ac4bfd3a8753282b7a2ddd10ef5e405d0754c36b8496b105a904eda78ef |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 679064c9ef0510150ac2361bbfff0a8147cc1d2b7fe8b5758ee3ca84a3d21d21 |
|
MD5 | e65eef096212fbc615af54c68559ac9f |
|
BLAKE2b-256 | f16d61a525ca0eef2aba07dfd925c73f6579582bfa1ab083c0ff326b1f076759 |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 26392184996b041a6873a56ec3f4b783550ad4b58c557100989bc709b077c477 |
|
MD5 | 9db77f7552f3ab6e76308c216ae81a24 |
|
BLAKE2b-256 | 55fdbb4d3db56e779b11bd565c73a5ebc6efd2f63bb64f7aeffb65b4d09b36e4 |
Hashes for pysqlite3_wheels-0.5.0-cp310-cp310-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 96f1e90a1ac3eecf9654833f410df956f66d711ad5f0684190e88c95e582453e |
|
MD5 | 188c8d1727bfa9ee57679295049d7fbf |
|
BLAKE2b-256 | 91dbd9923a7b7d4ba621ecd5aea80a84d290e61af64c7f32f3ef5e1b7198fbae |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 66bbcfe69c0ee2b3d4cec44e76f17480334a64ecf8dc7ca20354cddcc91e8814 |
|
MD5 | 5ff366e39a7ef2a23e0d4f0aa05e2231 |
|
BLAKE2b-256 | 9d20ee3d3f0ffad5dcab0fecd7c4e464910054db989a16b0b45ad6c6b2f5bd94 |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 264999c3961fd1ec6c887a5e075c129fd270e13104384cff3d17fc0c7e148990 |
|
MD5 | 847ea3c1e42db4265b681f90a18c7f08 |
|
BLAKE2b-256 | 81b3d3dc5d2f916bf4cf17b36364d5b64415f53e21b315fe7dd9e0ff77e79947 |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1b76160bac7aa19d7dad6c274507085eecb7993f0e4d0dd1fdb590fbdca91360 |
|
MD5 | 4a22c68329da3c38e28bc61b65b70991 |
|
BLAKE2b-256 | acf6c80b8508126209e2611cb3166f777436790055e771a38e7762589a31247e |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a27aa56674f6c8a0797236281160bcaec6cd0839c24119cd5a6c5a20d0a238c8 |
|
MD5 | a3c03dcd30f735d04d66d35737fa483a |
|
BLAKE2b-256 | 9949ed069c0972a1227e23ee3581fff0815fe5c7adb1a923f180ebc51468672a |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 160807c5a279281798d41be8b99a4913d3e22395ae07a2e2ebcbf8314e0bb030 |
|
MD5 | b675865519ded584790c9e76b25c0450 |
|
BLAKE2b-256 | 61acaa37ff2b58429d5cd2470d19ec9b8662eeed1ae3dd02f4d85508dc0d8d88 |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6946ad7430229500bf31211b2292cbfcf3967773c359de88eb4499fcc81a1be1 |
|
MD5 | ed89e3253affd5281e347a67c5262a44 |
|
BLAKE2b-256 | f7c7461cbdbef32fde30cb2bc602f6e53f3d57de488b106fee63e0ea5ee1afe0 |
Hashes for pysqlite3_wheels-0.5.0-cp39-cp39-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dafaa6fd17901c374022fa719d26f9fa62aadb65b2f8a8b1ed834ef48ba6ac82 |
|
MD5 | f1290bae58b768204a9c7a328f8900bf |
|
BLAKE2b-256 | c170963b7d021ffe4ddc75ba3d11538597a0302d96a763b00c5f83c1d8f1cf0b |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3d8273240d0b4ff6deb2f609ea1bed07c6287f3b9173effba8407895eef3a759 |
|
MD5 | f76f20cbae67cd03363612817313b6f7 |
|
BLAKE2b-256 | 45580fcfa83ab83bd374a0f97aadb76224c1d7b2551040ccf5acb6ecb49508ff |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2b60a7d017dc1511937baaf5f20a177bf642bf727b7d7d0a73c68d9d0c2da4b0 |
|
MD5 | 52d9ee991526ce142218aa7ad4685143 |
|
BLAKE2b-256 | ecb7e89edddc7a41f09960ee3c4e89e7135aeff06fd53ce5e766c1822958028e |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0c1682165aa3d8eb78fa47025ce0036622788fa75abb88847ee1d1b274dc5170 |
|
MD5 | 3403ef834aa56f38a5c94968e438d846 |
|
BLAKE2b-256 | 12c2dd7dd299892b5f1f358719cb27065778f88d1952b6fd1e7d118fc77e5da5 |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 055881bd0d75d83de59784b053ae5c28d65daca97d611a1ef03937073207aa35 |
|
MD5 | ea49dfd896c775bcb6252b836e2d5093 |
|
BLAKE2b-256 | f16589acfe39155cb79bd572983ba217f71a4f0bc594caa58c6f5fe8aa08a703 |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 14474374e9493cead233d5de7099c313a625cec34f6e2882f0a34beb12677200 |
|
MD5 | 5654b0f14d940714508f89ae71078c43 |
|
BLAKE2b-256 | 19c57e5257b54c293ec97276f59ce5c5f5064179cbc53ed159f528668063eebe |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bf987fa2c9ef169b7ba6231e0e1e03a62bddd20d92bdeae8c66c63f5d05e376c |
|
MD5 | 8c499e20d21207c8cc8eecd21c11b02c |
|
BLAKE2b-256 | 70f925f120d36ae1cf1c23339649a87d1b3b29bc0d9f255ae8685a90168e59b6 |
Hashes for pysqlite3_wheels-0.5.0-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 89c8a7f8587cfdb5d44e784ad3125894225824ff4369421676e6fdf816c1f2cb |
|
MD5 | 1bc12ebebd73ef07286a88e63a440df0 |
|
BLAKE2b-256 | d8917b1cd94cc6f29c7b72480d6af086b966df4759f2c05d590684038f81bfc6 |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | eae5ca5bb8de5f66c8c1c8d438e0bff4e578e25dee02eb7e21341250be5ffae6 |
|
MD5 | 37390b909ce0d9fcb8f2e830887a6be1 |
|
BLAKE2b-256 | 0fe56ac5e83c1ea82122cc4b5dcac51b710f4687ba2298b0e4d8cda1f00fab62 |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 47a7ce19285fab9a3707a7541cd1187ab5f07c7af7c66ab86a921cbe70d6a2e7 |
|
MD5 | ca83b6f72aef4f6a410ce1aea28a5a62 |
|
BLAKE2b-256 | 42bde3d1549b52d27a6ff3fef710708e67fa01f4ce79d367866d4363e376fa51 |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e568b7dda39995990591d0751f70451a30c77b6561b6162c62b59d939b3c11ba |
|
MD5 | cb9110c41056e534a94bae869744466a |
|
BLAKE2b-256 | 6d821903103018891a0c8a062ebcffcfb3929a932a3f333ce7c34a16c0b74999 |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a2f5779d7784035e7fde55ef4ecc1f80c16eb3fbfe65a166287693e22285dc24 |
|
MD5 | d7d17acf5971ca5d5ea248c27503c788 |
|
BLAKE2b-256 | a034fff6630c25c79f288771fc7547c2aec2f7885203c03b16138ca1542c2111 |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f61b5247d9f7cee89f3e7505942af77849e49f166e5f9c45879d426dad988bce |
|
MD5 | cff64234a5362d27bd34203966f41d6c |
|
BLAKE2b-256 | 7fd1fcc0b2fc799b15ec40e5c5547921ea879d9fd954e5852c8e40e7431a304e |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6876f6d803200728e4def53e0c73a57247ad35267507274de49ae8762c3feb59 |
|
MD5 | 527d9f3916b01ebb5df2b4b3a77d3f83 |
|
BLAKE2b-256 | 086edd05bb414c290bea09fd9d43aae04430d40879798abefc034b430055b7ef |
Hashes for pysqlite3_wheels-0.5.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 34f1d6efedab2a9473b98986ea2f89b5640a9b75b429f7e62db12c0e4e01de8a |
|
MD5 | 2fa9fa2266e33c127a747f3a64ef9b8a |
|
BLAKE2b-256 | efc07a2ceccc889ecc78e0faafa337a152b34d77dffd6cae5ed04f561fedb2ac |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b38c32d94c243be09f195642a999e256811fd0fb6bd7fb7707cbc0a776fbce50 |
|
MD5 | f91e7965bcf9751360d17a361c190154 |
|
BLAKE2b-256 | a5bc02f0ddad1a1d0bfa860b21063657c625382e662681a760f6b25da2256eaa |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 65b1346ebd6d4a073f4edd8e956921dd0ef7a9df314373a0dca58b7e1dc12cca |
|
MD5 | 37e85130c69a9cc811a0c32a01210d09 |
|
BLAKE2b-256 | 7ec2574e3848bd852646cc7d76aa26ac24e44a7aa57ecc8981bed10e794deb29 |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | da398e75cbc1fc8f91ad99be74129ea779934f3b8768a9b4f67007cc02a19d58 |
|
MD5 | f4e1f4d4995396f095e6db1f18b76a14 |
|
BLAKE2b-256 | d4978f77c7ec60852831972942f33868e88d464e116f313f67ebfbbf565b6a53 |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 02a59d9691f369dea247e9db34205cac444e429eae99e47c016e917806cecfb1 |
|
MD5 | 2c21bdb0aa84f8cb0d403d6a5f46af52 |
|
BLAKE2b-256 | 9719f3e36d0697ddd2c0e1c4c7503a6fe736bc91958a2a19056cbcfeb1cc568f |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 73740bf549bbf140efc14afb6105aa998d535109d6a0aa26697142a3dbeadbd9 |
|
MD5 | f7c204189c255c5c8424f80ca05f6e35 |
|
BLAKE2b-256 | a12255deef729b5c2da3e1d97d1877bfc5a9ebb54309c2acfc5f91c2e4ef22be |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3773ba8612603aa5d91e6911d390e0c676be748b9add07cfebd3d9d1533ae6f6 |
|
MD5 | ddb8b935d620af7d9a5853ac00d85e5c |
|
BLAKE2b-256 | 7e6faa94f748723822870486c024c0a6d8790a433c304c2a77a1c5351dabf6da |
Hashes for pysqlite3_wheels-0.5.0-cp36-cp36m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cdc4eec90d37a1f83f4955c5e02e5d27adf12cd1872357d92490f7e0a3af5d06 |
|
MD5 | e9d6389833dc098ebd980bdc057b2219 |
|
BLAKE2b-256 | 2b4256af9e6280e65e4dd83fc8cede4e91cba569c0a1ebd1d4090ea1ffc77cf3 |