Skip to main content

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.

Metadata

Release files for rotki-pysqlcipher3 2026.8.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for rotki-pysqlcipher3 2026.8.3
File Size Uploaded Provenance Actions
rotki_pysqlcipher3-2026.8.3.tar.gz 2.7 MB With provenance Details for rotki_pysqlcipher3-2026.8.3.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for rotki-pysqlcipher3 2026.8.3
File Actions
rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl CPython 3.14 CPython 3.14 free-threading Windows x86-64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl CPython 3.14 CPython 3.14 free-threading Linux glibc 2.28+ x86-64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl CPython 3.14 CPython 3.14 free-threading Linux glibc 2.28+ ARM64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl CPython 3.14 CPython 3.14 free-threading macOS 11.0+ ARM64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl CPython 3.14 CPython 3.14 free-threading macOS 10.15+ x86-64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl CPython 3.14 CPython 3.14 Windows x86-64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl CPython 3.14 CPython 3.14 Linux glibc 2.28+ x86-64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl CPython 3.14 CPython 3.14 Linux glibc 2.28+ ARM64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl CPython 3.14 CPython 3.14 macOS 11.0+ ARM64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl
rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl CPython 3.14 CPython 3.14 macOS 10.15+ x86-64 Details for rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl

Total release size: 49.5 MB

Release files / rotki_pysqlcipher3-2026.8.3.tar.gz

Download URL rotki_pysqlcipher3-2026.8.3.tar.gz
Size 2.7 MB
Tags Source
SHA-256 checksum
How to use checksums
c4c7f7f7536dbc2dcd662c08691370be3e8f8974e857bd0321f04ea29fdbc1d3
BLAKE2b-256 checksum
How to use checksums
0ad3686f7437c254040d741c494107cc1659349481b31ea8823f459455e685d2
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314t-win_amd64.whl
Size 2.6 MB
Tags CPython 3.14 CPython 3.14 free-threading Windows x86-64
SHA-256 checksum
How to use checksums
b7ca762bc08e502eded5a804cd71e676be2fcc5486ed723e227a0a02ae82c2da
BLAKE2b-256 checksum
How to use checksums
d49e306f02227e72bf3a41fdd782218568caf7ff384d6ca6b08c444d1c072e3c
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_x86_64.whl
Size 7.3 MB
Tags CPython 3.14 CPython 3.14 free-threading Linux glibc 2.28+ x86-64
SHA-256 checksum
How to use checksums
3784205fbe71c7a169add70cac54570d7e6698cd009cff11d5be94ba259e27fb
BLAKE2b-256 checksum
How to use checksums
e6abde577768db70b73bd0e424192c1c89394bbe34fab771c670072c90765f30
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314t-manylinux_2_28_aarch64.whl
Size 7.5 MB
Tags CPython 3.14 CPython 3.14 free-threading Linux glibc 2.28+ ARM64
SHA-256 checksum
How to use checksums
d4bf45b5392dfb28aae93e6e00d4504e7047acb1db89a1ca3ef3ede91b5290ac
BLAKE2b-256 checksum
How to use checksums
cafa8bbe831ba7abd9293425c781aadd35060d8dff23fdb5e0c729592b531eca
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_11_0_arm64.whl
Size 3.2 MB
Tags CPython 3.14 CPython 3.14 free-threading macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
eba7ef2c710ac49231f78d4b5a1e3b7fffcf7044436da3cda9f966385cccf667
BLAKE2b-256 checksum
How to use checksums
5ad5a68d57f499ba31cc66b61f54efbb67feda6f527221fe4c7fe8a7a7a38301
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314t-macosx_10_15_x86_64.whl
Size 2.9 MB
Tags CPython 3.14 CPython 3.14 free-threading macOS 10.15+ x86-64
SHA-256 checksum
How to use checksums
20dff4cdfcb0d267167fe712360d039905ced3238119486de4a6f78789869dd1
BLAKE2b-256 checksum
How to use checksums
32a03f02ada9700d1bc59265fc8d2909b0862092beaa3d0fa026a9e5fdf4ef51
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314-win_amd64.whl
Size 2.6 MB
Tags CPython 3.14 Windows x86-64
SHA-256 checksum
How to use checksums
7fb50da57201cb3b3cb3fa3e10505d905bafd8e4d6c3ca6a1387eea2b5231fda
BLAKE2b-256 checksum
How to use checksums
cb4ff533504d0ef2ddf9c870000785d0b03aa03dbe731a4c9fad8f72524f199b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_x86_64.whl
Size 7.2 MB
Tags CPython 3.14 Linux glibc 2.28+ x86-64
SHA-256 checksum
How to use checksums
a52c29c29fcfe64f3eceb7c4bdf442313c80cadf5b0650dbddbe80e140eb3906
BLAKE2b-256 checksum
How to use checksums
9fa52ed8bc069229b76513a8cf8741eb870fedb5c7cfc88aa2fe22137210fa61
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314-manylinux_2_28_aarch64.whl
Size 7.4 MB
Tags CPython 3.14 Linux glibc 2.28+ ARM64
SHA-256 checksum
How to use checksums
178a31e61c981096e26116a96b5a3ca3c197db9deac1c6efb856fe87d270c9a3
BLAKE2b-256 checksum
How to use checksums
9182bdbb94b2f4bfe468e04dae8e71cc16f1e9b6b1a52eb2c44e4c60588694f9
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_11_0_arm64.whl
Size 3.2 MB
Tags CPython 3.14 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
02982624e30d4558521e127613d30e43498fabe3ccc49674368b22face65f862
BLAKE2b-256 checksum
How to use checksums
2f46b4ddd1e4dd41ad1cc06d1d2138dc6f59eeac1d7840adcda0e09fd2f87a9a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Release files / rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl

Download URL rotki_pysqlcipher3-2026.8.3-cp314-cp314-macosx_10_15_x86_64.whl
Size 2.9 MB
Tags CPython 3.14 macOS 10.15+ x86-64
SHA-256 checksum
How to use checksums
d41b3b5b8118bc4c4d1b3bf12045613806edd7c0d49cd7415efe31b34635feaa
BLAKE2b-256 checksum
How to use checksums
f220debe7bb97714e44622eb3349fcbefca3b009a231026b7026fa0e36a83eb3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

Security for rotki-pysqlcipher3 2026.8.3

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

All 11 files in this release have been uploaded with provenance metadata.

Select from 11 files

Attestation for rotki_pysqlcipher3-2026.8.3.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 27, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

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