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.7-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ad89abbc379c94ea585442f5989377f2dcae0cb8ce3efae2e34f99cc97b19aa3 |
|
MD5 | e0ed8adab699e81f74d393dc64b7c763 |
|
BLAKE2b-256 | 1298630881001a666249f54c4f5b29e9bc7817c59977b9530cac96564dd18207 |
Hashes for pysqlite3_wheels-0.4.7-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9919656308afd697ade29afe742e867f9b367199c995c88e9eaca90c86a3a2bd |
|
MD5 | 7c322c41009884f98f2f073d35f4a9bb |
|
BLAKE2b-256 | 4c2b73a0c6b7e532460764ebba05f3ab21a596266d13ecc3147bca5ed10ea4be |
Hashes for pysqlite3_wheels-0.4.7-cp310-cp310-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f3031e8527e74117d9ba3163b0e3614d2011a629a7e6f79086637ea459827ef3 |
|
MD5 | 08938cfd9b6934d8cf1ac38407caecb2 |
|
BLAKE2b-256 | 813da312b7199aa522572767e7ceae2ed59f41e4080863a5cb907a01ef18de26 |
Hashes for pysqlite3_wheels-0.4.7-cp310-cp310-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0f66496bd4f4db2fd70811b81de5f9c2a712187169edbefc3dc1357e1fdad71b |
|
MD5 | 352d4a271676c70301208a51d16c3865 |
|
BLAKE2b-256 | 043bef7e2229448850090aadc1a6388160cdd7368a2bd13ef2c9d469018f3900 |
Hashes for pysqlite3_wheels-0.4.7-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8041c99221c03e7c7e54f48ebd1457701a2475e5d94b11fc5f5a1b465f8193b9 |
|
MD5 | 2754e6558ab840e78d20d88d9c903ee0 |
|
BLAKE2b-256 | bcfc801fb22a28dc684e8ac54be366ac55b4b24be467721144be1d5d3a0c3e32 |
Hashes for pysqlite3_wheels-0.4.7-cp310-cp310-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 08aee10058397c6840710907d7308bb9718ac81119b21c1ac72d3861624cc6d3 |
|
MD5 | 630ddc9dc96528e7e1dc25535d2b5f83 |
|
BLAKE2b-256 | d0f4b6545bd5fbb05ba580ba174a822f2ad630a08c6f04c9d70add90d539ee30 |
Hashes for pysqlite3_wheels-0.4.7-cp310-cp310-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a56a45b4d7fa473cf94ea146bb69682db561cd41d4a677b40486088bf425bc76 |
|
MD5 | f9d7f2d7958c92eddce6499c1d51ff72 |
|
BLAKE2b-256 | 98089b86af430224e3f7522ee3a280e2293b62c27cd843316572e4a439b41499 |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 31410d06578e32595c3a443f7e52225b529434fae031f8d2c0ac771fe2186135 |
|
MD5 | 2a149bf503224b683980f089cc14f18e |
|
BLAKE2b-256 | 47600e3c9429b1f65444791858d5cb97a6ca69a73fbf4e2abce8a99fb72bce65 |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f99024866931f431cf3754377bde0d12066c0f4932bbc540749f745b2614b3be |
|
MD5 | f75a492fbe9ecfd7ea89dbd3460557d6 |
|
BLAKE2b-256 | 15b8cbef0b069a05f4d1be86154377be8a915c0c3735d23334674b0eae5685c2 |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7c11c90a5b2fc8bf8cb2374405646c9418ada8bf6ce4b1acc7b739c9941e6535 |
|
MD5 | 166ed4697b6c02ea6390547ac16d93a4 |
|
BLAKE2b-256 | 08be56a4c161699e16120c00c9fd2a4422d2af6f790bde1e5fb2cc4da7ed6444 |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e327c8589af31c0a53fa77bfff13e94e79c0cb34c6e522a56372bc9329c539ff |
|
MD5 | e2a755ffd238efa6a45c624ed5866192 |
|
BLAKE2b-256 | c7a1e55ac4f89b5c8453d2ae4b8202dc1fb1d70e66cd01f13cfe83e76498feeb |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7422be7c04a2cf83426fcbef509a4db6ee37be6076cfefb2615af01dbd7c3417 |
|
MD5 | b500844a53eef8381bfc4fb5b284b663 |
|
BLAKE2b-256 | ea04328cabebca0e7ddc74d17529b1d2d199b6ad901043f56fec1469aca7c445 |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 975328b0dd27ff084b6d7aaccfa60c29276c091312b1ace46656c62a97113014 |
|
MD5 | 8a8e8ccfec88c93a1f01106196e4608c |
|
BLAKE2b-256 | 8e82210dc3b5c9fbca5333de7e1978e08cb9187f2b4f848fac1f6f17163d754c |
Hashes for pysqlite3_wheels-0.4.7-cp39-cp39-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4d9cd67b5de0c88d6833bcebeb74535ad75e6d3f660202d200891863147941aa |
|
MD5 | cfc32216d67c1f562adaf7648a21cb2d |
|
BLAKE2b-256 | 9c97147645c35ffcbaf5e71198b72a6515266f387fd628b3167b19b00b2f27bb |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f3744c1ed30efe10041d8314501f2ff37c9e7ec133906eae56aef9bb5137d624 |
|
MD5 | bdf7cb4d2990df530cce4637cbaa6adf |
|
BLAKE2b-256 | f122e1ae067467510e7b214ec18077b062bbe77dffe1e68b6f831bd13a8fda99 |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 625fd593e2774cebe778b826cc6b2b3ad38431a620d4ff49ae207f50eed23139 |
|
MD5 | 1283b8ba1b25c3bb0de96a8b598aef9a |
|
BLAKE2b-256 | adaf6a9c4275419ee2c230ec3a5c94d5ed97b0cdffbb1ee291f83d81e233257e |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b5a2debe650608f883ce578bd25e83dd87514684998c87098e23df51423acf70 |
|
MD5 | 6b26717cb0bb6dd346c3cd13b0f1accb |
|
BLAKE2b-256 | 5c8f9662e690bf88aa37ec203b03fcd2b6fd21f30d7ae6a32f827bd81e73a546 |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 013fc3b6aa6559956e3640d0cba33accb6181d3c0fe5dc4b12541987c2ebcd52 |
|
MD5 | 7d1ef901bcef99b3873b22c0b5610823 |
|
BLAKE2b-256 | 83d7475dea6a60aa6e4ab18e8bcc7a4e4ac2c8c2d8a6fb6a6f3caf357a039c0f |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9586549a79d5bc4ffa47cea69c39267a5747bd45de42beae692e1833d17dd565 |
|
MD5 | b3ab7569c0b84025fd6bbd0966219664 |
|
BLAKE2b-256 | 5a7edef5d508f4517930cd266b77d7d498f39cc9b60f252d1f920697d8c0d90f |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3dac664753e10cd402cc0f3e56328f4cd1f8d74a2feadbb67d7fa3047f223759 |
|
MD5 | 831f750f3d2dd81d3575c6874b08407e |
|
BLAKE2b-256 | 965908913314019ede24d302dcd3008141a0d60a5d87a28bc462c349bc8b047a |
Hashes for pysqlite3_wheels-0.4.7-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f92a77ba7a10bfc523cdb5e0de00a6ca3e6c1c0f48c22da6ee35c5ef0c69a7d0 |
|
MD5 | 7c812b1afcba3c987bdf78c45aae2713 |
|
BLAKE2b-256 | 73bbab97f8ed87d6bb6e7d277ed144463d6c1c9cbadec5ef9b65dfca7116536f |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 048af5139d23a80a32ce4de04a6db6a3313bffb50ef3ef04a865e5327c131839 |
|
MD5 | a1606103a76fa8127532de16fcd464fd |
|
BLAKE2b-256 | 51f2be16083cd7ef8e3da5db0a24a32915c205fbe9bb15b5407a2a3d3e38068e |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c6df9ff2fca7aac5968fa9d7546e857527c416f43d29e1bd21db604cb49a09c7 |
|
MD5 | 66166109cb4706df0b9ed17bae40fb3c |
|
BLAKE2b-256 | 3710436dc9bf5dff197d5fa4d12f15b8edb37b9a3c60f2ba45702cd8bcfdebb4 |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8f7c97e93b82e666c83e40e726ba69db86d0b2804a17733df6f9caf7c838f822 |
|
MD5 | 2b116b6859825bbcb60a4b12223f9575 |
|
BLAKE2b-256 | ce085afbded7c6f2ac292f3261396bf7ea7727f46aa84f021e9098936e510da7 |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 678bc06e60408ebdfc20f3222edbf06c661949daf40cb64ce517e4e2f1db9146 |
|
MD5 | 438f412d6e1dc5a669457c45fc93c84f |
|
BLAKE2b-256 | dd5b8d945a0fc9aeb12e40d707119ca9850b4c3190b6ecc5abeb6e0359a40ebb |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 56102096b17a1974ef7b51a49b0ceafafdb9c45933a861754f023393f4a04d31 |
|
MD5 | 26df2067bf56833f7e678c52ec943a3f |
|
BLAKE2b-256 | 69c5feb1a09221a287d967c05517595d3b164ba6be8fcaf503c4badf0137bd5d |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7b74966f4eecf76f8220a803eec5168b63f4aaca5c3efa0be963f5f48ffe733d |
|
MD5 | 3e96f421d84b86f7e6ebe21a751c4dec |
|
BLAKE2b-256 | c6655ae639656a7929577769571e5c8f26109eca7c56da3e12a204ddd3751101 |
Hashes for pysqlite3_wheels-0.4.7-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 27599a367d54b94a3a5eac519a2aee4f287412167a0e3df3f10ca346b2cc16f0 |
|
MD5 | be08024f70c537108a50e841e188c6b0 |
|
BLAKE2b-256 | da0d9e621de8eecc60680fed34ae24448fe10bbb4112b12a6b025a33633d2bf2 |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 904187003a47bde2c5204cc9932dd396c2f1b83dd0762db63a08e0e89e858717 |
|
MD5 | f8c7641cc8d16128143f5adccfba8839 |
|
BLAKE2b-256 | bcc1a88084a7814441d8e9501b67fd7b8cc52737891533f1f19d5bb70967a482 |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 10e71362ff7a0fbea853e5e575e28ae41bf19621aa5ced4bae7570d38c19360d |
|
MD5 | a8fb0e4b98e3d90056a7a580a71dfd08 |
|
BLAKE2b-256 | 18155f281c71e58a67438dddf4543df33f0079e85aba4a5d27ce4e8a5abdbe8a |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-musllinux_1_1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d8b1fe444781f3790a448546f00b17c0d967bc0558c8ceee3802ad6052e93288 |
|
MD5 | 1b2105923c91e3c37820100093e4db16 |
|
BLAKE2b-256 | 0fdbf6d1f4da523a1bfbc8bcb082a3d732be7543776f0b86ed3812b8ad062327 |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-musllinux_1_1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca40e52282d7418fbc9cf492e70fd968609476db3dc52af3d2c92f25d301476c |
|
MD5 | d9606d6cfcf85f40c75731511ad182a8 |
|
BLAKE2b-256 | 453c2368d233c2cfad6403d14e016a20c12c17c8440ca182fe52430eab3c38c7 |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7a4ce25c024d11ea9024721f79cb13388df29cefc7ac55466164bcca81a063ac |
|
MD5 | ad310c68b2933857d953f72d7a1d4acb |
|
BLAKE2b-256 | 510f5954ae58f016020994b6b6cbe634ec3a9588b1a722871041f3a1b09828d6 |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fe878f1a6f319dedf647e3ae2a65c19d3ee42514a621a7adce8291b87357aab8 |
|
MD5 | d4286499f3e61aa513984bc38609fa9a |
|
BLAKE2b-256 | 5d77a8e67ee03a6c6ad40a1f7b61236da36341165a38066f8da608de85365383 |
Hashes for pysqlite3_wheels-0.4.7-cp36-cp36m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | da162e7a35c3af70426e871ace5e3722c96effb8346d845d42c61ef39e0eb924 |
|
MD5 | 9d36cecca89b4962e258cf0b8f7f74ca |
|
BLAKE2b-256 | c336f233244a6e2e288d51200f9110dacd7baa855947795a8ed1b11644db9898 |