News for hackers. Stuff that matters.
Re:Using SQLite as storage for web server static content by pkphilip on Monday October 28, 2024 @11:01AM (#41971695)
If it is static content why have a database at all?
Re:Using SQLite as storage for web server static content by marc136 on Tuesday October 29, 2024 @04:13AM (#41980780)
In general, e.g. to place the files and their metadata like checksum, access rights, image previews, foreign keys right next to each other.

In the authors use case, it might also be easier to drop the executable and one big database file on a random shared file store in the company network instead of many small files and a database file for metadata.

And it might be faster to read files from db than from fs https://sqlite.org/fasterthanfs.html