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

181 points by joseferben 3 years ago | 94 comments

SQLite JSON at full index speed using generated columns(dbpro.app)

334 points by upmostly 10 months ago | 102 comments

A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.

Why you should probably be using SQLite(epicweb.dev)

280 points by rrampage 3 years ago | 243 comments

SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s(phiresky.github.io)

152 points by Maksadbek 3 years ago | 57 comments

Understanding database indexes in PostgreSQL(blog.mastermind.dev)

230 points by mrpotato 3 years ago | 15 comments

Do you even need a database?(dbpro.app)

240 points by upmostly 6 months ago | 268 comments