Hacker ApprovedDepartments

sqlite-utils

Shares rank 13 of 14 Python libraries by recommenders

People recommend this free Python library and command-line tool for working around SQLite's ALTER TABLE limits and handling schema migrations. Critics point to bugs in the 4.0 release candidate.

People recommend this free Python library and command-line tool for working around SQLite's ALTER TABLE limits and handling schema migrations. Critics point to bugs in the 4.0 release candidate.

7 people gave an opinion

recommend it
5
criticize it
2
approval share
71%
Each figure is one person. RecommendsCriticizes

Recommended in 4 of 13 months

  1. November 2025: not recommended
  2. December 2025: not recommended
  3. January 2026: recommended
  4. February 2026: recommended
  5. March 2026: not recommended
  6. April 2026: not recommended
  7. May 2026: recommended
  8. June 2026: not recommended
  9. July 2026: recommended
  10. August 2026: not recommended
  11. September 2026: not recommended
  12. October 2026: not recommended
  13. November 2026: not recommended (month in progress)

Why it doesn’t carry the badge

  • 5 people recommend itNeeds 10 or more, not met.
  • 2.5 recommenders for every criticNeeds 2 to 1 or better, met.
  • Recommended in 4 of 13 monthsNeeds 4 or more, met.

The same three rules apply to every product, and the badge can’t be bought. How the badge works

What people say about it

The reasons people give, with the number of comments that give each one. Open a reason to read what they said.

Why people recommend it

Each mark is one comment

  • Solves ALTER TABLE and migration limits

    “offers solutions to both the alter table limitations and the need for schema migrations”

    Comment from 29 Jul 2026 in “SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers”

    “I use my own sqlite-utils CLI/Python library to work around these limitations”

    Comment from 29 May 2026 in “SQLite is all you need for durable workflows”
  • Broad feature set people like

    “there's all kinds of stuff there.”

    Comment from 29 Jul 2026 in “SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers”

    “I'm a big fan of sqlite-utils”

    Comment from 5 Jul 2026 in “sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)”

What people warn about

Each mark is one comment

  • Bugs in 4.0 release candidate

    “delete_where() leaves the state corrupted”

    Comment from 5 Jul 2026 in “sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)”

    “Brutal bugs for a release candidate.”

    Comment from 5 Jul 2026 in “sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)”

Other Python libraries people recommend

The four most recommended other Python libraries, with the same counts for each, so you can compare like for like. The tick on each bar marks the 2 to 1 line the badge needs.

sqlite-utils compared with 4 alternatives
ProductRecommendCriticizeApprovalMonthsOwnedBadge
Polars1525075%121 yr3 ownersApproved
pandas939849%1110 yrs7 owners—
NumPy863273%12—Approved
SciPy12286%7—Approved
sqlite-utilsThis page5271%4——
See all 14 Python libraries, ranked

What people said

8 of the 10 comments that mention it, newest first. Each links to the original comment.

“there's all kinds of stuff there.”

RecommendsComment from 29 Jul 2026 in “SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers”

“offers solutions to both the alter table limitations and the need for schema migrations”

RecommendsComment from 29 Jul 2026 in “SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers”

“you can now use it to transform non-strict tables to strict (and vice-versa)”

RecommendsComment from 12 Jul 2026 in “Prefer Strict Tables in SQLite”

“Brutal bugs for a release candidate.”

CriticizesComment from 5 Jul 2026 in “sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)”

“delete_where() leaves the state corrupted”

CriticizesComment from 5 Jul 2026 in “sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)”

“I'm a big fan of sqlite-utils”

RecommendsComment from 5 Jul 2026 in “sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)”

“I use my own sqlite-utils CLI/Python library to work around these limitations”

RecommendsComment from 29 May 2026 in “SQLite is all you need for durable workflows”

“I remain very proud of my current open source projects too”

RecommendsComment from 10 Feb 2026 in “AI Doesn't Reduce Work–It Intensifies It”

Counts come from 1,795,640 Hacker News comments, November 2025 to November 2026. How we count. Report a mistake.