2 ms·
Even better from the SQLite page (https://www.sqlite.org/intern-v-extern-blob.html https://www.sqlite.org/intern-v-extern-blob.html), comparing storing content
by rakoo 11y ago
Even better from the SQLite page (https://www.sqlite.org/intern-v-extern-blob.html https://www.sqlite.org/intern-v-extern-blob.html), comparing storing content in SQLite versus storing content in files and filenames in SQLite. The bonus of mixing both is that you get all niceties from a SQL store (transactions, using SQL to query...).
The takeaway is that for content < 20K you should use SQLite, and for content < 100K you should also use it with possibly some tuning to do.