sqlcipher3

This repository is based on coleifer/sqlcipher3 and is maintained by rotki. Its SQLite extension wrapper has been updated from CPython 3.14 and adjusted to work with both regular CPython 3.14 and free-threaded CPython 3.14t without enabling the global interpreter lock during import.

This library takes pysqlite3 and makes some small modifications so it is suitable for use with sqlcipher (sqlite with encryption).

Additional features:

  • User-defined window functions (requires SQLite >= 3.25)
  • Flags and VFS can 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 starting with version 0.6.2. This package contains the latest release of SQLCipher compiled with numerous extensions, and requires no external dependencies.

Python compatibility

This fork supports CPython 3.14 only. Wheels are built for the regular cp314 ABI and the free-threaded cp314t ABI.

If you prefer to build yourself, a source distribution is available on PyPI. Note that since SQLCipher 4.7.0 the build system for SQLCipher has changed substantially and it no longer provides a libsqlcipher but is intended to overwrite the system libsqlite3.

sqlcipher3 with statically-linked sqlcipher

Install a wheel using pip:

$ pip install rotki-pysqlcipher3

Because SQLCipher 4.7.0 and newer no longer provide a system libsqlcipher, there is no great way to link against a system library. The best route if you wish to use a different version of SQLCipher than the one bundled is to check-out the source code and replace the vendored sources with your own desired SQLCipher amalgamation.

# Copy your specific sqlcipher amalgamations into the vendor/ directory at the
# root of the sqlcipher3 checkout:
$ cp sqlite3.[ch] vendor/

# Build your library.
$ pip install .

# Or alternately,
$ python setup.py build

Nor aught availed him now to have built in heaven high towers; nor did he scrape by all his engines, but was headlong sent with his industrious crew to build in hell.

Beware to those who would build their own wheels! See what has been wrought and tremble.

Project links

Data verified by PyPI on Aug 27, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

3 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for kelsos from gravatar.com kelsos Avatar for lefterisjp from gravatar.com lefterisjp Avatar for rotki from gravatar.com rotki

Credits

Author: Charles Leifer

Maintainer: Rotki Solutions GmbH

GitHub Statistics

Data verified by PyPI on Aug 27, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

Requires

Python <3.15, >=3.14

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

rotki_pysqlcipher3-2026.8.3.tar.gz (2.7 MB view details)

Uploaded Source

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl (2.6 MB view details)

Uploaded CPython 3.14tWindows x86-64

rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl (7.3 MB view details)

Uploaded CPython 3.14tmanylinux: glibc 2.28+ x86-64

rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl (7.5 MB view details)

Uploaded CPython 3.14tmanylinux: glibc 2.28+ ARM64

rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl (3.2 MB view details)

Uploaded CPython 3.14tmacOS 11.0+ ARM64

rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl (2.9 MB view details)

Uploaded CPython 3.14tmacOS 10.15+ x86-64

rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl (2.6 MB view details)

Uploaded CPython 3.14Windows x86-64

rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl (7.2 MB view details)

Uploaded CPython 3.14manylinux: glibc 2.28+ x86-64

rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl (7.4 MB view details)

Uploaded CPython 3.14manylinux: glibc 2.28+ ARM64

rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl (3.2 MB view details)

Uploaded CPython 3.14macOS 11.0+ ARM64

rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl (2.9 MB view details)

Uploaded CPython 3.14macOS 10.15+ x86-64

File details

Details for the file rotki_pysqlcipher3-2026.8.3.tar.gz.

File metadata

  • Download URL: rotki_pysqlcipher3-2026.8.3.tar.gz
  • Upload date:
  • Size: 2.7 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3.tar.gz
Algorithm Hash digest
SHA256 c4c7f7f7536dbc2dcd662c08691370be3e8f8974e857bd0321f04ea29fdbc1d3
MD5 01b905f4435431e328c3218abfbb8699
BLAKE2b-256 0ad3686f7437c254040d741c494107cc1659349481b31ea8823f459455e685d2

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3.tar.gz:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl
Algorithm Hash digest
SHA256 b7ca762bc08e502eded5a804cd71e676be2fcc5486ed723e227a0a02ae82c2da
MD5 01d0fa63bf3cb64d1a0d562d0a5b1973
BLAKE2b-256 d49e306f02227e72bf3a41fdd782218568caf7ff384d6ca6b08c444d1c072e3c

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 3784205fbe71c7a169add70cac54570d7e6698cd009cff11d5be94ba259e27fb
MD5 de7f807c8ccdc8831de972fa78868ef3
BLAKE2b-256 e6abde577768db70b73bd0e424192c1c89394bbe34fab771c670072c90765f30

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl
Algorithm Hash digest
SHA256 d4bf45b5392dfb28aae93e6e00d4504e7047acb1db89a1ca3ef3ede91b5290ac
MD5 5f2be4fb08598e519dbdc4532bc8373a
BLAKE2b-256 cafa8bbe831ba7abd9293425c781aadd35060d8dff23fdb5e0c729592b531eca

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 eba7ef2c710ac49231f78d4b5a1e3b7fffcf7044436da3cda9f966385cccf667
MD5 2c415f61f7a2823ea0046f81bf4446fa
BLAKE2b-256 5ad5a68d57f499ba31cc66b61f54efbb67feda6f527221fe4c7fe8a7a7a38301

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl
Algorithm Hash digest
SHA256 20dff4cdfcb0d267167fe712360d039905ced3238119486de4a6f78789869dd1
MD5 226ac44371264df199296453fffcd5d2
BLAKE2b-256 32a03f02ada9700d1bc59265fc8d2909b0862092beaa3d0fa026a9e5fdf4ef51

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl
Algorithm Hash digest
SHA256 7fb50da57201cb3b3cb3fa3e10505d905bafd8e4d6c3ca6a1387eea2b5231fda
MD5 40231a605bc09dbf1d77147687d36ac7
BLAKE2b-256 cb4ff533504d0ef2ddf9c870000785d0b03aa03dbe731a4c9fad8f72524f199b

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 a52c29c29fcfe64f3eceb7c4bdf442313c80cadf5b0650dbddbe80e140eb3906
MD5 ce02a09162c26ef16005ec24fdda3e8e
BLAKE2b-256 9fa52ed8bc069229b76513a8cf8741eb870fedb5c7cfc88aa2fe22137210fa61

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl
Algorithm Hash digest
SHA256 178a31e61c981096e26116a96b5a3ca3c197db9deac1c6efb856fe87d270c9a3
MD5 01d4c2b18a3e9470509d66423477447e
BLAKE2b-256 9182bdbb94b2f4bfe468e04dae8e71cc16f1e9b6b1a52eb2c44e4c60588694f9

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 02982624e30d4558521e127613d30e43498fabe3ccc49674368b22face65f862
MD5 d39fefd5a2f12c8045e09fc6a6dd587f
BLAKE2b-256 2f46b4ddd1e4dd41ad1cc06d1d2138dc6f59eeac1d7840adcda0e09fd2f87a9a

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl.

File metadata

File hashes

Hashes for rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl
Algorithm Hash digest
SHA256 d41b3b5b8118bc4c4d1b3bf12045613806edd7c0d49cd7415efe31b34635feaa
MD5 97ca63900c2ac5a9b7344f68c5af6ae8
BLAKE2b-256 f220debe7bb97714e44622eb3349fcbefca3b009a231026b7026fa0e36a83eb3

See more details on using hashes here.

Provenance

The following attestation bundles were made for rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl:

Publisher: build.yml on rotki/pysqlcipher3

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

This release

2026.8.3 This release

11 files

2024.10.1

13 files

2024.1.2

7 files

2024.1.1

1 file

2023.7.1

7 files

2023.5.1

7 files

2022.8.1

7 files

2022.6.1

7 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page