DictSQLite Version 2
High-performance dict-like SQLite storage for Python, backed by a Rust native extension.
Release Highlights — v2.1.3
- More robust write-buffer flushing: pending writes are restored if a storage flush fails.
- Safer delete/clear behavior: pending buffered writes no longer reappear after removal.
- Faster batch cache-miss reads using bulk SQLite queries.
- Improved warm-cache memory accounting to avoid repeated full-cache scans.
- Fixed separate-table persistence and compression/decompression consistency.
- Expanded benchmark coverage across sizes, record counts, storage modes, table modes, cold reads, mutations, and threaded access.
- GitHub Actions now publishes benchmark artifacts, comparison data, and Markdown summaries.
English Version
(日本語のREADMEは下にあります)
You can handle basic SQLite operations in Python as if you were working with a dictionary.
Installation
Install DictSQLite via pip:
pip install dictsqlite
Documentation
Additional Guides / 追加ガイド
- Index (目次)
- Examples — English (使用例 英語)
- Examples — 日本語 (使用例 日本語)
- Migration from 1.8.8 — English
- Migration from 1.8.8 — 日本語
Author
Feedback
Please create an issue on github:disnana/DictSQLite.
Support
For support, email support@disnana.com or join the Discord Server.
License
This project is licensed under a MIT License. See the LICENSE file for details.
You are free to modify the code, but you must give appropriate credit to the original author and comply with the terms of this license.
DictSQLite
日本語版
(English version is above)
Rust製ネイティブ拡張をバックエンドにした、辞書ライクな高性能 SQLite ストレージです。
リリースハイライト — v2.1.3
- flush 失敗時に保留中の書き込みが失われないように改善
- delete/clear 後に未 flush の値が復活する問題を修正
- batch 取得のキャッシュミス時に一括 SQLite 読み込みを使用
- warm cache のメモリ使用量管理を改善し、不要な全走査を削減
- separate table の永続化と圧縮/展開の整合性を修正
- サイズ、件数、保存形式、テーブルモード、cold read、削除/clear、並行アクセスを含むベンチマークを拡充
- GitHub Actions でベンチ結果 artifact、比較データ、Markdown Summary を出力
インストール
DictSQLite を pip でインストールする。
pip install dictsqlite
ドキュメント
ガイド / 追加リソース
著者
フィードバック
github:disnana/DictSQLiteにてIssueを作成してください。
サポート
サポートは support@disnana.com にメールするか、Discord Server に参加してください。
ライセンス
このプロジェクトはMIT Licenseの下でライセンスされています。 詳細はLICENSEファイルを参照してください。
コードを改変することは自由ですが、元の作成者に適切なクレジットを与え、このライセンスの条項に従う必要があることに注意してください。
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 dictsqlite-2.1.3.tar.gz.
File metadata
- Download URL: dictsqlite-2.1.3.tar.gz
- Upload date:
- Size: 976.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
31c4063bb39381134392998fbc6f852e11aa7c2d109b99ce5049b9ae806b55d1
|
|
| MD5 |
8d44b723d02ab7ae097968b2a46dcb13
|
|
| BLAKE2b-256 |
c9bc3b00431dea9f7e195b14d96d2298f24a8ba7b9c8d25634aa609561afcf8c
|
Provenance
The following attestation bundles were made for dictsqlite-2.1.3.tar.gz:
Publisher:
pypi_release.yml on disnana/DictSQLite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dictsqlite-2.1.3.tar.gz -
Subject digest:
31c4063bb39381134392998fbc6f852e11aa7c2d109b99ce5049b9ae806b55d1 - Sigstore transparency entry: 2069238286
- Sigstore integration time:
-
Permalink:
disnana/DictSQLite@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/disnana
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
pypi_release.yml@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Trigger Event:
push
-
Statement type:
File details
Details for the file dictsqlite-2.1.3-cp39-abi3-win_amd64.whl.
File metadata
- Download URL: dictsqlite-2.1.3-cp39-abi3-win_amd64.whl
- Upload date:
- Size: 1.6 MB
- Tags: CPython 3.9+, Windows x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
af56f0e1fd685d758d554ce92410b398a3b7dfbf952d40a66a70789e9d456fe3
|
|
| MD5 |
21e15eb03607a6e8af64e69e2e057fed
|
|
| BLAKE2b-256 |
ad36581fd1af316a16867a79bc29721c4000e6dff3253261dc3e8f6e82461faf
|
Provenance
The following attestation bundles were made for dictsqlite-2.1.3-cp39-abi3-win_amd64.whl:
Publisher:
pypi_release.yml on disnana/DictSQLite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dictsqlite-2.1.3-cp39-abi3-win_amd64.whl -
Subject digest:
af56f0e1fd685d758d554ce92410b398a3b7dfbf952d40a66a70789e9d456fe3 - Sigstore transparency entry: 2069239401
- Sigstore integration time:
-
Permalink:
disnana/DictSQLite@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/disnana
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
pypi_release.yml@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Trigger Event:
push
-
Statement type:
File details
Details for the file dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.
File metadata
- Download URL: dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
- Upload date:
- Size: 2.0 MB
- Tags: CPython 3.9+, manylinux: glibc 2.17+ x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3d10c434cd2eb2bd0247dfac1da66c3804d2c8e1bff6f8a960a63d87c30b91d8
|
|
| MD5 |
2e5eb3adcf89226cd60ac3f8c0c2bb28
|
|
| BLAKE2b-256 |
a0d11d8a0d22a5faaceaea5431a9949ce3bca9e7d8af074dbdf099194f100da0
|
Provenance
The following attestation bundles were made for dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:
Publisher:
pypi_release.yml on disnana/DictSQLite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl -
Subject digest:
3d10c434cd2eb2bd0247dfac1da66c3804d2c8e1bff6f8a960a63d87c30b91d8 - Sigstore transparency entry: 2069238630
- Sigstore integration time:
-
Permalink:
disnana/DictSQLite@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/disnana
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
pypi_release.yml@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Trigger Event:
push
-
Statement type:
File details
Details for the file dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl.
File metadata
- Download URL: dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
- Upload date:
- Size: 1.8 MB
- Tags: CPython 3.9+, manylinux: glibc 2.17+ ARM64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a14b2ddb10d27fb967ab5527e77feac57034524e15c4001ba532d4d5674c8b07
|
|
| MD5 |
a63b618b4c4a3b5c2bafcf078ebab640
|
|
| BLAKE2b-256 |
34c2aebc99722154ed3240d1733235d5258bf2afc2a0c60ff5680ad3825bf81f
|
Provenance
The following attestation bundles were made for dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl:
Publisher:
pypi_release.yml on disnana/DictSQLite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dictsqlite-2.1.3-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl -
Subject digest:
a14b2ddb10d27fb967ab5527e77feac57034524e15c4001ba532d4d5674c8b07 - Sigstore transparency entry: 2069239610
- Sigstore integration time:
-
Permalink:
disnana/DictSQLite@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/disnana
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
pypi_release.yml@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Trigger Event:
push
-
Statement type:
File details
Details for the file dictsqlite-2.1.3-cp39-abi3-macosx_11_0_arm64.whl.
File metadata
- Download URL: dictsqlite-2.1.3-cp39-abi3-macosx_11_0_arm64.whl
- Upload date:
- Size: 1.7 MB
- Tags: CPython 3.9+, macOS 11.0+ ARM64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
de6367b336d05d49b41f99680251ea6663df013942ca85cb6827586a243eccef
|
|
| MD5 |
78ae9c4500d6c8203626d85e65be1b84
|
|
| BLAKE2b-256 |
d1f35dac4be3283c1ce7158bb39576cffcba98e0e267f55aadb31b0b94b4a5e9
|
Provenance
The following attestation bundles were made for dictsqlite-2.1.3-cp39-abi3-macosx_11_0_arm64.whl:
Publisher:
pypi_release.yml on disnana/DictSQLite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dictsqlite-2.1.3-cp39-abi3-macosx_11_0_arm64.whl -
Subject digest:
de6367b336d05d49b41f99680251ea6663df013942ca85cb6827586a243eccef - Sigstore transparency entry: 2069238990
- Sigstore integration time:
-
Permalink:
disnana/DictSQLite@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/disnana
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
pypi_release.yml@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Trigger Event:
push
-
Statement type:
File details
Details for the file dictsqlite-2.1.3-cp39-abi3-macosx_10_12_x86_64.whl.
File metadata
- Download URL: dictsqlite-2.1.3-cp39-abi3-macosx_10_12_x86_64.whl
- Upload date:
- Size: 1.8 MB
- Tags: CPython 3.9+, macOS 10.12+ x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
f91e876d9388984ed13ee798865d9fc1fae6f9312068e58ae5fcf7538ca65d13
|
|
| MD5 |
9b4c10d229162ebd3e1e5d165a2ef834
|
|
| BLAKE2b-256 |
5a86ecc4d3e605c7896ea54c785e7b0a9664c55ca87494a633e82f9c4c700584
|
Provenance
The following attestation bundles were made for dictsqlite-2.1.3-cp39-abi3-macosx_10_12_x86_64.whl:
Publisher:
pypi_release.yml on disnana/DictSQLite
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dictsqlite-2.1.3-cp39-abi3-macosx_10_12_x86_64.whl -
Subject digest:
f91e876d9388984ed13ee798865d9fc1fae6f9312068e58ae5fcf7538ca65d13 - Sigstore transparency entry: 2069239102
- Sigstore integration time:
-
Permalink:
disnana/DictSQLite@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/disnana
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
pypi_release.yml@2c6e182c78593be5bd8494b4872064ab490c3a94 -
Trigger Event:
push
-
Statement type: