Thread: JSON vs SQLITE
View Single Post
Old 03-17-2026, 10:18 PM   #10
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 46,198
Karma: 29626604
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You use sqlite if you need to modify individual rows in the larger dataset with good performance and make queries against the larger dataset using indices for speed. If nether of those are a concern either because of the design or because the dataset is not large then use JSON.
kovidgoyal is offline   Reply With Quote