SQLite concurrency and why you should care about it(jellyfin.org)

339 points by HunOL 11 months ago | 155 comments

A Jellyfin server team blog post explaining SQLite concurrency limitations and how Jellyfin addresses database locking issues.

Things that surprised me while running SQLite in production(joseferben.com)

181 points by joseferben 3 years ago | 94 comments

Short-Circuiting Correlated Subqueries in SQLite(emschwartz.me)

6 points by emschwartz 10 months ago | 0 comments

What if we treated Postgres like SQLite?(maragu.dev)

52 points by markusw 1 year ago | 70 comments

SQLite does not do checksums(avi.im)

96 points by todsacerdoti 1 year ago | 68 comments

Subtleties of SQLite Indexes(emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments