# rogerbinns/apsw

> A Python wrapper over the SQLite C API that exposes full SQLite features: FTS, session, virtual tables, VFS, JSON and CArray, including async support.

- Magnitude: 2.6 out of 10 — Steady
- Stars: 882 total · +15 stars measured 2026-10-11, 19:23–21:31 UTC, ≈ 16 by evening
- Star trust: star growth looks organic
- Category: Backend & databases · Language: C · Created: 2013-12-29 · Last push: 2026-10-11
- GitHub: https://github.com/rogerbinns/apsw · Homepage: https://rogerbinns.github.io/apsw/ · Page: https://gitnova.dev/en/r/rogerbinns/apsw

## Useful for

- Use SQLite full-text search from Python
- Create a SQLite virtual table in Python
- Set up a VFS for SQLite data access

## Why it’s here

- Star-counter measurements on 2026-10-11 (UTC), 19:23–21:31: 867 → 882 stars (+15). This is the change over that interval.
- Estimated end-of-day forecast: about +16 stars, using observed gains and the previous day.
- Hacker News: “apsw: Another Python SQLite Wrapper” — 42 points, 4 h ago.

## Star trust

Star growth looks organic.

Star-trust labels are heuristics based on the repository’s behavior, not a check of every stargazer.

## Numbers

- Forks: 108
- Issues and pull requests: 625
- Watchers: 30
- Average over the last week: 3 per day
- Usual pace: 0 per day
- Stars in the last hour (measured): 5
- Latest release: 3.53.4.0 (2026-07-26)

## Stars per day, last 30 days (oldest → newest, today is partial)

2026-09-12 … 2026-10-11: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 15

## Hacker News

- apsw: Another Python SQLite Wrapper — 42 points, 12 comments: https://news.ycombinator.com/item?id=50045273

## Spotted in now

- Spotted on Hacker News

## More in this category

1. **FalkorDB/FalkorDB** — 3.8 · Peaking · Backend & databases · Rust · +289 stars measured 2026-10-11, 00:39–21:28 UTC, ≈ 319 by evening
   FalkorDB is a Rust graph database using sparse matrices and linear algebra for fast queries. It targets Knowledge Graphs for LLMs (GraphRAG), agent memory, and fraud detection.
   Full card: https://gitnova.dev/en/r/FalkorDB/FalkorDB.md
2. **sqliteai/sqlite-multiwriter** — 3.8 · Early signal · Backend & databases · C · +21 stars measured 2026-10-11, 00:38–21:28 UTC, ≈ 23 by evening
   A SQLite VFS extension that enables concurrent writes from multiple threads or processes without schema or SQL changes, using per-writer WALs, snapshot validation and optional rebase to avoid SQLITE_BUSY.
   Full card: https://gitnova.dev/en/r/sqliteai/sqlite-multiwriter.md
3. **nodejs/node** — 3.1 · Steady · Backend & databases · JavaScript · +41 stars measured 2026-10-11, 00:40–21:29 UTC, ≈ 45 by evening
   Open-source, cross-platform JavaScript runtime environment used to build server-side applications, CLI tools and build tooling. Governed by the OpenJS Foundation, it ships Current, LTS and Nightly releases.
   Full card: https://gitnova.dev/en/r/nodejs/node.md
4. **project-minigraf/minigraf** — 2.7 · Early signal · Backend & databases · Rust · +7 stars measured 2026-10-11, 00:40–21:30 UTC, ≈ 8 by evening
   Single-file embedded graph database with Datalog queries and bi-temporal time travel — "SQLite for connected data with full history".
   Full card: https://gitnova.dev/en/r/project-minigraf/minigraf.md
5. **rmyndharis/OpenWA** — 2.7 · Steady · Backend & databases · TypeScript · +52 stars measured 2026-10-11, 00:01–21:30 UTC, ≈ 57 by evening
   Self-hosted WhatsApp API gateway in TypeScript with a dashboard, multi-session support, plugins (Chatwoot, Typebot, n8n) and API keys scoped to sessions and chats.
   Full card: https://gitnova.dev/en/r/rmyndharis/OpenWA.md

---

Magnitude (0–10) measures how fast and how unusually interest in a repository is growing right now. It is not a quality score.
Days are UTC. “So far today” is a fact; “expected by the end of the day” is a forecast.
Summaries and use cases are written by an LLM (DeepSeek V4.1 Flash) from the README and may be inaccurate: verify specific claims (benchmarks, speed, hardware) in the repository itself.
Data as of 2026-10-11 21:38 UTC, updated every 30 minutes.