DB-API 2.0 interface for Sqlite 3.x
Project description
rsqlite3
A Python SQLite3 extension module with static SQLite build support.
Building
This project supports building with a statically linked SQLite library. The sqlite3.c and sqlite3.h amalgamation files are included in the repository.
Build with uv
To build the wheel with static SQLite using uv:
uv build --wheel
Build with setuptools directly
To build with the static SQLite amalgamation:
python setup.py build_static bdist_wheel
This will create a wheel file in the dist/ directory with SQLite statically compiled into the extension.
Features
The static build includes the following SQLite features:
- FTS3/FTS4/FTS5 (Full Text Search)
- JSON1 extension
- RTREE (R-Tree index)
- Math functions
- Load extension support
- And more...
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file rotki_sqlite-2025.7.4.tar.gz.
File metadata
- Download URL: rotki_sqlite-2025.7.4.tar.gz
- Upload date:
- Size: 2.2 MB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2e9ccdce2ab18959565eb068102838d8f7dbfe7d3e50765a5ab4b2dfe0df0086
|
|
| MD5 |
939c83d8217e19d26d471a3029f2eb79
|
|
| BLAKE2b-256 |
1515392c2cfdb6f34f630da25af175f75ca2b850c3d22bf4246b6e62b9e27a19
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4.tar.gz:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4.tar.gz -
Subject digest:
2e9ccdce2ab18959565eb068102838d8f7dbfe7d3e50765a5ab4b2dfe0df0086 - Sigstore transparency entry: 348768402
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-win_amd64.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-win_amd64.whl
- Upload date:
- Size: 721.4 kB
- Tags: CPython 3.11, Windows x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
99ed266d6132f087c2713d489e5c388a68fd66e9d3d7df6060acd238be57f155
|
|
| MD5 |
dba542280bd600a4faad546b29e240ec
|
|
| BLAKE2b-256 |
92128e25100ba1a58de87203816c6d368ce331aac12c2f82121befc7586c4a40
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-win_amd64.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-win_amd64.whl -
Subject digest:
99ed266d6132f087c2713d489e5c388a68fd66e9d3d7df6060acd238be57f155 - Sigstore transparency entry: 348768416
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-win32.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-win32.whl
- Upload date:
- Size: 597.4 kB
- Tags: CPython 3.11, Windows x86
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
8ef35457e56361db75bf54e0dc12a6f4b5a5e556c627eb688d9ebdf5fa477aec
|
|
| MD5 |
50c342fee66d7d7b9d632a440142c788
|
|
| BLAKE2b-256 |
7835632ab047333e32fc6b58ea43096c62f9d1b28d8dbfbd85456184f76f7e7e
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-win32.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-win32.whl -
Subject digest:
8ef35457e56361db75bf54e0dc12a6f4b5a5e556c627eb688d9ebdf5fa477aec - Sigstore transparency entry: 348768501
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
- Upload date:
- Size: 3.6 MB
- Tags: CPython 3.11, manylinux: glibc 2.17+ x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
c6bd304d2cff2ecdda2e7d93a5f229a50c774534eb1e46238ada7d44bb05393d
|
|
| MD5 |
eeb35b056fbf45d2170e52027ccb81ec
|
|
| BLAKE2b-256 |
5cd04608671790463029404eae138a6045f37e6e90f350dd738b0f737c3a786d
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl -
Subject digest:
c6bd304d2cff2ecdda2e7d93a5f229a50c774534eb1e46238ada7d44bb05393d - Sigstore transparency entry: 348768479
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
- Upload date:
- Size: 3.6 MB
- Tags: CPython 3.11, manylinux: glibc 2.17+ ARM64
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1ecbf625dca018bd98f83ce0af8055cc82c4ec87b35eaea8449c3a61ce7114cf
|
|
| MD5 |
8198667db79bc173612c26c4eebedc40
|
|
| BLAKE2b-256 |
8ccb4d0a1a293e0d2b7518fa6e2e6a4904bbab2ede815534d60ed35360b82c17
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-manylinux2014_aarch64.manylinux_2_17_aarch64.whl -
Subject digest:
1ecbf625dca018bd98f83ce0af8055cc82c4ec87b35eaea8449c3a61ce7114cf - Sigstore transparency entry: 348768464
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl
- Upload date:
- Size: 3.5 MB
- Tags: CPython 3.11, manylinux: glibc 2.17+ i686, manylinux: glibc 2.5+ i686
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
6377a684ecda07be0a9dad7f6627339c8349d8acce54979b6a1d1b4925e70263
|
|
| MD5 |
7ade19d2bca0d11bf02f1cfb0c130294
|
|
| BLAKE2b-256 |
794c10899337a68f7182ea11f980b408b1abfe2813793befa64f763e8c076a2b
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-manylinux_2_5_i686.manylinux1_i686.manylinux_2_17_i686.manylinux2014_i686.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-manylinux1_i686.manylinux2014_i686.manylinux_2_17_i686.manylinux_2_5_i686.whl -
Subject digest:
6377a684ecda07be0a9dad7f6627339c8349d8acce54979b6a1d1b4925e70263 - Sigstore transparency entry: 348768446
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-macosx_11_0_arm64.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-macosx_11_0_arm64.whl
- Upload date:
- Size: 759.9 kB
- Tags: CPython 3.11, macOS 11.0+ ARM64
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
669bddba9b396669e98b57c14f067322ac6e7ec8da9cfec460aa6b967d87daad
|
|
| MD5 |
445d23cb55839bd1d3786d069efa6257
|
|
| BLAKE2b-256 |
3dcb3bb0d53bda4bc3365ae1cca22e2ed2e9849cec1aefe35e2f81bdef7ec31d
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-macosx_11_0_arm64.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-macosx_11_0_arm64.whl -
Subject digest:
669bddba9b396669e98b57c14f067322ac6e7ec8da9cfec460aa6b967d87daad - Sigstore transparency entry: 348768428
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type:
File details
Details for the file rotki_sqlite-2025.7.4-cp311-cp311-macosx_10_9_x86_64.whl.
File metadata
- Download URL: rotki_sqlite-2025.7.4-cp311-cp311-macosx_10_9_x86_64.whl
- Upload date:
- Size: 810.1 kB
- Tags: CPython 3.11, macOS 10.9+ x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a8eda2fdf7cfe7ba6cf033283251b5aecbc2171c874f431a660ca8341bd82c55
|
|
| MD5 |
fb36b968b64582e40e4ea246278a2d92
|
|
| BLAKE2b-256 |
1b6f4bde22d6a94755cfc2c83c28f9d6ae2f6140f6680711786501b0504f6f49
|
Provenance
The following attestation bundles were made for rotki_sqlite-2025.7.4-cp311-cp311-macosx_10_9_x86_64.whl:
Publisher:
build.yml on rotki/rotki-sqlite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
rotki_sqlite-2025.7.4-cp311-cp311-macosx_10_9_x86_64.whl -
Subject digest:
a8eda2fdf7cfe7ba6cf033283251b5aecbc2171c874f431a660ca8341bd82c55 - Sigstore transparency entry: 348768493
- Sigstore integration time:
-
Permalink:
rotki/rotki-sqlite@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Branch / Tag:
refs/tags/2025.07.04 - Owner: https://github.com/rotki
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
build.yml@b69139ea0b33571228e0d243527c40da1b9a20d0 -
Trigger Event:
push
-
Statement type: