Hacker News new | ask | show | jobs
by gizmo 1272 days ago
SQLite has also measured the performance impact for storing larger BLOBs:

https://www.sqlite.org/intern-v-extern-blob.html

The verdict: storing blobs in the database is totally fine. Stable diffusion is totally compute bound, the overhead of storing a 1mb file in a sqlite db is miniscule.