# piskvorky/sqlitedict

Persistent dict, backed by sqlite3 and pickle, multithread-safe.

Repository: https://github.com/piskvorky/sqlitedict
Canonical: https://ross.abutalabs.com/products/sqlitedict
Language: Python
License: Apache-2.0
License Family: permissive
Topics: sqlite, python, data-store, multi-threading
Last push: 2022-12-07T16:37:05+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 5524, "days_push": 1365, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1245, forks 140 (observed 2026-08-28T04:04:07.077996+00:00)

## What it is
A lightweight Python library providing a persistent dict interface backed by SQLite and pickle, with multithread-safe access. It wraps Python's sqlite3 module with a simple, Pythonic dict-like API including autocommit and context manager support.

## Use cases
- persist a python dictionary to disk
- simple key-value store without running a database server
- share dict-like data across threads safely
- store pickled objects in sqlite
- lightweight embedded storage for small python apps

## When to choose
- you need simple persistent key-value storage in pure Python with no server
- your workload is single-process but possibly multithreaded
- you want a dict API with sqlite durability

## When to avoid
- you need concurrent access from multiple processes
- you need queries, indexes, or relational features beyond key-value lookups
- you need high write throughput or network access

## Facets
- artifact type: library
- maturity: maintenance
- function: database, serialization, caching
- domain: databases, developer-tools
- platform: python, cross-platform
- tags: sqlite, persistent-dict, key-value-store, pickle, multithreaded, data-engineering

## Member repositories
- piskvorky/sqlitedict (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:07.077996+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T05:08:11.230968+00:00, confidence not recorded.
  - readme: https://github.com/piskvorky/sqlitedict (fetched 2026-08-28T04:04:07.077996+00:00, sha acba028db361)
  - registry_pypi: https://pypi.org/pypi/sqlitedict/json (fetched 2026-08-29T12:19:39.910408+00:00, sha 4d4ca24552fc)
- Data as of 2026-08-30T08:39:29.467469+00:00.