MIDREAL
Menu

Home / apsw

rogerbinns

apsw

WatchingWatchingNone of the above. Nothing stands out yet. More on the methodology page

rogerbinns/apsw

Another Python SQLite wrapper

CCategories: Developer tools

Social preview image for apsw

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

Find them on

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

Language
C source, checked 22 Nov 2026
Homepage
https://rogerbinns.github.io/apsw/ source, checked 22 Nov 2026
Last release
3.54.1.0, 19 Oct 2026 source, checked 22 Nov 2026
Releases
96 source, checked 21 Nov 2026
Contributors
7 source, checked 21 Nov 2026
Archived
no source, checked 22 Nov 2026

Nerd stuff

CLI

Languages
C (detected), Python (detected), Makefile (detected), Shell (detected)
Interfaces
CLI (detected)
Docs
examples/ folder (detected)
Package ecosystem
Python packaging (detected)

The Receipts

SourceEvidenceDate
Hacker NewsThread, 89 points, 33 comments11 Oct 2026
PackagePyPI apsw21 Nov 2026
deps.devOpenSSF Scorecard: 3.5/1022 Nov 2026
deps.devDependent packages on PyPI: 28522 Nov 2026
deps.devSecurity advisories on PyPI: 022 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

Stars each day Stars each dayThe highest star count we recorded on each day., last 42 days. Without JavaScript this shows the last 30 days.
Stars gained each day Stars gained each dayThe difference in the daily peak star count between consecutive days that both have a reading., between readings on consecutive days. Last 30 days in the fallback.

PyPI downloads

Downloads DownloadsDownloads per day of the project's package, as the registry (npm or PyPI) reports them.. Latest day 81,050, busiest day 119,028, 5,756,674 in total, 25 Aug 2026 to 21 Nov 2026.

Packages

RegistryPackage
PyPIapsw

Only packages whose registry page links back to this repository are listed.

Signals

SourceWhat we measuredChecked
GitHub957 stars, 2 gained in 7 days21 Nov 2026
Hacker News1 post stored, 0 points in the last 7 days18 Oct 2026
Feed mentionsNot tracked yet-
npmNo linked package found-
PyPI81,050 downloads on the latest day21 Nov 2026
Docker HubNo linked package found-
crates.ioNo linked package found-
HomebrewNo linked package found-
deps.dev285 PyPI dependents22 Nov 2026
Hugging FaceNot tracked yet-
BlueskyNot tracked yet-
Stack ExchangeNot tracked yet-
YouTubeNot tracked yet-

Attention vs adoption

Attention: above 33% of tracked projects 33%
Star velocity against all tracked projects

Adoption: above 95% of tracked projects 95%
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

MeasureThis projectCategory median
Star velocity0.20.5
Days since release34.09.2
Contributors, all time73
Median time to first reply on issues7 hours12 hours
Commits in the last 30 days341.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

Points by day Hacker News points by dayPoints on Hacker News posts that mention the project, grouped by the day each post was published. across 1 post and 1 day, 89 points in total.
PostPoints 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. First spotted by Mid or Real at 876 stars on 11 Oct 2026

Markdown

[![Mid or Real](https://midorreal.com/badge/rogerbinns-apsw.svg)](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: Mid or Real: SLEEPER It shows the verdict as this page shows it today.

Markdown

[![Mid or Real: SLEEPER](https://midorreal.com/badge/rogerbinns-apsw.svg?style=verdict)](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.

Projects blowing up

How we call a verdict

Is this your project? Claim it

Figures by method 1.0