SQLite

Raised as a usability problem by 52 people on Hacker News over 16 years (2011–2026), in 47 threads.

People raised many different problems with SQLite, but no single problem has yet been raised by 3 people in 3 different months and threads.

Unreviewed issues were grouped by machine: Claude Haiku labelled each comment as a usability complaint, named what it's about and summed up the problem in a line, and a small model grouped similar problems. Nobody has checked them by hand. Expect mistakes.

The newest 50 complaints

Changing a column requires risky manual schema edits that can corrupt the database2026-07-29
Lets wrong-typed values like '1' and '0' into Boolean columns, causing silent data errors2026-07-11
Inserts fail on concurrent writes by default; retry/timeout must be set per connection2026-04-12
Hard to inspect or maintain SQLite databases; requires SSH and raw SQL2026-04-07
Deadlocks freeze all reads and writes; WAL file grows and queries slow badly2025-12-03
Dropped into a complicated interface with no explanation of purpose2025-10-13
The setting named NORMAL silently risks data loss, misleading newcomers about its safety2025-08-24
Documentation about fsync behavior under WAL is confusing to readers2025-08-24
Deferred transactions fail without waiting, in a non-intuitive way, unless BEGIN IMMEDIATE is used2025-07-16
WAL file grows unbounded, causing very slow reads and writes until manually truncated2025-07-15
Databases become unusable in other tools lacking the application-specific date functions2025-06-17
UTC timestamps lack trailing Z, so JavaScript parses them as local time and causes debugging2025-06-15
Hard to find out how to do things; docs are difficult or outdated2025-02-17
Images of text are inaccessible to readers with accessibility needs2024-12-31
Shared connections cause threads to interfere, with confusing results that appear only on slower machines2024-11-09
Adding a new contact requires cascading changes because of strict constraints2024-10-22
Write round trips to S3 are so slow that users must batch saves2024-10-02
Using UUID primary keys randomly corrupts the index, forcing a schema migration2024-08-09
API is confusing and not user friendly to use2024-08-06
Startup takes a second or two, worse on first boot when creating tables2024-07-18
Large blob offsets require walking all prior pages, so access is not truly random2024-02-02
Documentation says one thing but behaviour differs, so users following docs get broken results2024-01-22
Documentation for the case_sensitive_like pragma is confusing to understand2023-11-01
Must switch import/query modes back and forth and can't remember the commands2023-10-19
Hard for end users to edit directly, unlike spreadsheets2023-09-13
Giant SQL statements with nested JSON are very hard to read and reason about2023-08-11
Too much typing needed to work with the data2023-06-28
Combining full-text and regular column filters requires manual subqueries or joins, which is unfriendly2023-02-07
Makes it incredibly frustrating to manage multiple instances accessing the database2022-11-11
Commenter could not find a link to the source code on the page2022-10-28
SQLite becomes painfully slow under load when stored on an NFS mount2022-10-25
Foreign key checks are off by default and must be enabled on every connection, easy to miss2022-10-20
Accepts over-length strings in VARCHAR columns silently, so mistakes go unnoticed2022-10-20
Table model with rowids and WITHOUT ROWID is confusing to users from Postgres2022-10-20
Commenter couldn't tell from the blog post what the project does2022-08-01
One-liner prints the query text back instead of running it in bash2022-06-21
Only highlighted text gets submitted when running queries, unexpectedly2022-05-27
Highlighted-text run behavior is hard to discover and causes confusing errors by accident2022-05-27
Ctrl+Enter runs every query, forcing users to delete or comment out old ones2022-05-27
UI is not well-optimized for mobile devices, so it is hard to use on phones2022-05-26
No visible way to clear the database; refreshing the page loses preferences2022-05-26
No visible way to clear the database without refreshing, which loses preferences2022-05-26
JSON1 query syntax feels confusing at first, unlike SQL or object access2022-05-16
Schema changes are painful to perform with SQLite2022-04-15
Schema changes are annoying to make, even with known workarounds2022-04-15
Hard to report bugs, with poor UI, limited search and confusing navigation2021-07-05
Bulk inserts crawl with no clear indication of which hidden default setting is the cause2021-02-16
Query planner indexing API is exceedingly unintuitive and hard to understand2020-08-16
Queries stall for 30 seconds under parallel reads and writes, so simple reads block during writes2020-05-24
Full text search was confusing to set up, and it can't do simple contains queries2020-02-20