# sqlite-utils

5 Hacker News commenters recommended sqlite-utils and 2 criticized it, November 2025 to November 2026. It was recommended in 4 of 13 months.

**Verdict:** 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.

## Why people recommend it

- Solves ALTER TABLE and migration limits (2 comments): "offers solutions to both the alter table limitations and the need for schema migrations" ([source](https://news.ycombinator.com/item?id=49096257)) "I use my own sqlite-utils CLI/Python library to work around these limitations" ([source](https://news.ycombinator.com/item?id=48330217))
- Broad feature set people like (2 comments): "there's all kinds of stuff there." ([source](https://news.ycombinator.com/item?id=49096644)) "I'm a big fan of sqlite-utils" ([source](https://news.ycombinator.com/item?id=48792563))

## What people warn about

- Bugs in 4.0 release candidate (2 comments): "delete_where() leaves the state corrupted" ([source](https://news.ycombinator.com/item?id=48792739)) "Brutal bugs for a release candidate." ([source](https://news.ycombinator.com/item?id=48793459))

## Alternatives hackers recommend

- [Polars](https://hackerapproved.com/p/polars.md): 152 recommend
- [pandas](https://hackerapproved.com/p/pandas.md): 93 recommend
- [NumPy](https://hackerapproved.com/p/numpy.md): 86 recommend
- [SciPy](https://hackerapproved.com/p/scipy.md): 12 recommend
- [sh Python library](https://hackerapproved.com/p/sh.md): 10 recommend

## Cite as

Hacker Approved, "sqlite-utils", https://hackerapproved.com/p/sqlite-utils/ (counts from 1,795,640 Hacker News comments, November 2025 to November 2026).