Home / apsw
rogerbinns/apsw
Another Python SQLite wrapper
CCategories: Developer tools
Our summary
APSW is a Python wrapper for the SQLite C API, described as "Another Python SQLite Wrapper". It exposes SQLite features such as full text search, sessions, virtual tables, VFS, JSON and CArray, and supports async frameworks.
Who it is for: Python developers who want full access to SQLite features
What the README claims
- Supports CPython 3.11 onwards
APSW stands for **A**\ nother **P**\ ython **S**\ QLite **W**\ rapper. APSW supports CPython 3.11 onwards.
Not checked - Covers the complete SQLite C API
glues together the complete `SQLite C API
Not checked - Includes full text search, sessions, virtual tables, VFS, JSON and CArray
This includes `full text search
Not checked - Supports all async frameworks
full support for all the `async frameworks
Not checked
Written by AI from the project's README on 2026-10-26. It does not affect the verdict.
Watching: no other rule matched yet.
PyPI downloads on the latest day: 81,050, up from 49,518 a week earlier.
Commits in the last 30 days: 3, down from 90 30 days earlier.
Gaining 2 stars this week, 0.2x its usual pace. Last push today.
Verdict
SLEEPER scored 1h ago
- Hype
- 5
- Reality
- 63
- Hype Gap
- -58
- Momentum
- -
- Confidence
- 85%
- Adopted moves Reality +13 points.
- Responsive moves Reality -9 points.
- Maintained moves Reality +0 points.
- Old and widely used: its maintenance score is held at 50, so few recent pushes do not count against it.
Rule verdict-2.0, scoring score-2.0. How we score. Backtest.
Repository on GitHub Project homepage
Maintained by
Maintained by 1 primary developer, 1 external contributor in the last 90 days.
- rogerbinns is a GitHub individual account.
- GitHub account created January 2011.
- Top contributors by commits: rogerbinns 99%, dependabot[bot] 1%, grantjenks 0%.
Why now 0% of its stars arrived in the last 7 days. Gaining 0.2x its usual weekly pace. No Hacker News posts in the last 7 days.
- Stars StarsThe number of GitHub stars on the repository at our latest reading.
- 957
- Gain 7d Gain 7dStars gained since our latest reading from at least 7 days ago.
- +2
- Pace Velocity (Nx usual pace)This week's star gain divided by the project's usual weekly gain. The usual gain is the average weekly gain over the 4 weeks before (days 8 to 35 ago), counted as at least 10 stars. 2.0x means twice the usual pace. Without a reading from 35 days ago, the ranking assumes 2% of the stars the project had 7 days ago as its usual weekly gain. More on the methodology page
- 0.2x usual 2 a week
- HN points HN pointsHacker News points added up across posts that mention the project, published in the last 7 days.
- 0 7 days
- Downloads DownloadsDownloads per day of the project's package, as the registry (npm or PyPI) reports them.
- 81,050 latest day
- Contributors Contributors, all timePeople and anonymous contributors who have ever committed to the repository, as GitHub counts them. A small number is context, not a flaw: many solid projects are kept by one or two people.
- 7
- Last release Latest releaseDays since the latest GitHub release was published.
- 34 days ago
Gain 24h Gain 24hStars gained since our latest reading from at least 24 hours ago. 0. Forks ForksThe number of GitHub forks of the repository at our latest reading. 111. Open issues Open issuesThe number of open issues on the repository at our latest reading, as GitHub counts them. 29. Days since push Days since pushDays since the last push to the repository. 0 days. Archived ArchivedWhether the owner has archived the repository on GitHub. An archived repository is read-only. no. Hacker News posts in 7 days Hacker News postsThe number of Hacker News posts that mention the project, published in the last 7 days.: 0. Watchers WatchersThe number of GitHub users watching the repository for notifications, at our latest reading. 29.
Facts
Nerd stuff
CLI
- Interfaces
- CLI (detected)
- Docs
- examples/ folder (detected)
- Package ecosystem
- Python packaging (detected)
The Receipts
| Source | Evidence | Date |
|---|---|---|
| Hacker News | Thread, 89 points, 33 comments | 11 Oct 2026 |
| Package | PyPI apsw | 21 Nov 2026 |
| deps.dev | OpenSSF Scorecard: 3.5/10 | 22 Nov 2026 |
| deps.dev | Dependent packages on PyPI: 285 | 22 Nov 2026 |
| deps.dev | Security advisories on PyPI: 0 | 22 Nov 2026 |
What changed recently
GitHub release dates we stored. We do not track license changes yet.
Cite this
apsw is a GitHub project at https://github.com/rogerbinns/apsw written mainly in C, described there as "Another Python SQLite wrapper".
Source: https://midorreal.com/project/rogerbinns-apsw, checked 22 November 2026. The same facts as JSON: /project/rogerbinns-apsw.json.
Rank history
Peak day: +43 stars on 12 Oct 2026, 41 days ago.
Stars
PyPI downloads
Packages
| Registry | Package |
|---|---|
| PyPI | apsw |
Only packages whose registry page links back to this repository are listed.
Signals
| Source | What we measured | Checked |
|---|---|---|
| GitHub | 957 stars, 2 gained in 7 days | 21 Nov 2026 |
| Hacker News | 1 post stored, 0 points in the last 7 days | 18 Oct 2026 |
| Feed mentions | Not tracked yet | - |
| npm | No linked package found | - |
| PyPI | 81,050 downloads on the latest day | 21 Nov 2026 |
| Docker Hub | No linked package found | - |
| crates.io | No linked package found | - |
| Homebrew | No linked package found | - |
| deps.dev | 285 PyPI dependents | 22 Nov 2026 |
| Hugging Face | Not tracked yet | - |
| Bluesky | Not tracked yet | - |
| Stack Exchange | Not tracked yet | - |
| YouTube | Not tracked yet | - |
Attention vs adoption
Attention: above 33% of tracked projects
Star velocity against all tracked projects
Adoption: above 95% of tracked projects
Strongest of downloads, dependents and pulls (deps.dev)
Adoption runs ahead of attention: star velocity above 33% of tracked projects, best adoption figure above 95%. This describes the numbers; it is not a verdict.
Compared with Developer tools
| Measure | This project | Category median |
|---|---|---|
| Star velocity | 0.2 | 0.5 |
| Days since release | 34.0 | 9.2 |
| Contributors, all time | 7 | 3 |
| Median time to first reply on issues | 7 hours | 12 hours |
| Commits in the last 30 days | 3 | 41.5 |
Star velocity: above 32% of Developer tools projects
Days since release: above 82% of Developer tools projects
Contributors, all time: above 62% of Developer tools projects
Median time to first reply on issues: above 38% of Developer tools projects
Commits in the last 30 days: above 15% of Developer tools projects
Compared with the project's first category only. A percentile line appears only where at least 30 projects in the category have the measure. This describes the numbers; it is not a verdict.
Compare with
Hacker News
| Post | Points PointsThe points the post has on Hacker News. | Comments CommentsThe number of comments on the post on Hacker News. | Date |
|---|---|---|---|
| Hacker News post | 89 | 33 | 11 Oct 2026 |
Caveats
- rogerbinns made 99% of all commits. Source
Repo health
- Languages LanguagesShare of the repository's code by bytes, as GitHub's language detection reports it. The five biggest languages are named and the rest are grouped as Other.C 81%, Python 19%
- License LicenseThe SPDX license id GitHub detects, and a class: Open source (OSI) if the license is on the Open Source Initiative approved list, Source-available if the code is readable but the license limits use, Unclear if GitHub cannot match a known license, No license detected if it finds none. A public repository without a license is not open source.Unclear
- Repository age Repository ageTime since the repository was created on GitHub. This is the repository, not necessarily the project, which may have existed elsewhere before.12 years, created 29 Dec 2013
- Release dates Release datesThe date of the first and the latest GitHub release, and the latest release tag. Projects that ship without GitHub releases show none.First release 29 Dec 2013, current version 3.54.1.0 (19 Oct 2026)
Development
- Commits in the last 7 days Commits in the last 7 daysCommits to the repository in the last 7 days, as GitHub counts them.0
- Commits in the last 30 days Commits in the last 30 daysCommits to the repository in the last 30 days, as GitHub counts them.3
- Commits in the last 90 days Commits in the last 90 daysCommits to the repository in the last 90 days, as GitHub counts them.165
- Contributors, all time Contributors, all timePeople and anonymous contributors who have ever committed to the repository, as GitHub counts them. A small number is context, not a flaw: many solid projects are kept by one or two people.7
- Releases ReleasesThe number of GitHub releases, and how many days ago the latest one was published.96, latest release 34 days ago
- Releases in the last 90 days Releases in the last 90 daysHow many GitHub releases were published in the last 90 days.2
- Issues in the last 30 days Issues in the last 30 daysIssues opened and issues closed in the last 30 days, as GitHub search counts them.4 opened, 0 closed
- Pull requests merged in the last 30 days Pull requests merged in the last 30 daysPull requests merged in the last 30 days, as GitHub search counts them.0
- Packages that depend on the latest version Packages that depend on the latest versionHow many other packages list the project's latest published version as a dependency, from deps.dev, added up across npm and PyPI.285
Maintenance
- Median time to first reply on issues Median time to first reply on issuesMedian time between an issue being opened and the first comment from someone other than its author, over a sample of the last 30 closed issues. Issues with no reply are left out of the median and counted separately.7 hours
- Median time to close issues Median time to close issuesMedian time from opening to closing, over a sample of the last 30 closed issues.3 days
- Sampled issues with no reply Sampled issues with no replyHow many of the sampled closed issues never got a comment from someone other than their author.10 of 18
- Stale open issues Stale open issuesOpen issues with no update in the last 90 days, as GitHub search counts them.15
- Open pull requests Open pull requestsPull requests open now, as GitHub search counts them.0
Hygiene
- Automated tests or builds (CI) Automated tests or builds (CI)Whether the repository has at least one GitHub Actions workflow file in .github/workflows.Yes
- A tests folder A tests folderWhether the repository has a top-level folder named tests, test, __tests__ or spec.No
- A license A licenseWhether GitHub detects a license file in the repository.Yes
- Contributing guide Contributing guideWhether the repository has a contributing guide.No
- Code of conduct Code of conductWhether GitHub finds a code of conduct in the repository.No
- CODEOWNERS file CODEOWNERS fileWhether the repository has a CODEOWNERS file, which names who reviews changes to which files.No
- A Dockerfile A DockerfileWhether the repository has a Dockerfile at its top level.No
Security
- Security policy Security policyWhether the repository has a SECURITY.md or SECURITY.rst file.Yes
- Unpatched high or critical advisories Unpatched high or critical advisoriesPublished GitHub security advisories rated high or critical on this repository that list a vulnerable version with no patched version.0
- Signed latest release Signed latest releaseWhether the latest GitHub release has an attached signature file (.sig, .asc or .sigstore).No
- OpenSSF Scorecard OpenSSF ScorecardThe overall score from 0 to 10 that the OpenSSF Scorecard gives the repository's security practices, as reported by deps.dev.3.5/10
- Known advisories on the latest version Known advisories on the latest versionSecurity advisories deps.dev lists against the project's latest published version, added up across npm and PyPI.0
Badge
For maintainers: one measured fact, no verdict.
Markdown
[](https://midorreal.com/project/rogerbinns-apsw)
HTML
<a href="https://midorreal.com/project/rogerbinns-apsw"><img src="https://midorreal.com/badge/rogerbinns-apsw.svg" alt="Mid or Real"></a>
Verdict badge: It shows the verdict as this page shows it today.
Markdown
[](https://midorreal.com/project/rogerbinns-apsw)
HTML
<a href="https://midorreal.com/project/rogerbinns-apsw"><img src="https://midorreal.com/badge/rogerbinns-apsw.svg?style=verdict" alt="Mid or Real: SLEEPER"></a>
Passport
Copy these facts into a post, a README or a page. Cite as "Source: Mid or Real". Full record: JSON.
First tracked 11 Oct 2026 at 876 stars.
- GitHub data 8 h old
- Hacker News data 34 d old
Is this your project? Claim it
Figures by method 1.0