Anonymous
05/04/2023 (Thu) 22:32
No.
1488
del
I don't suppose there'd be any interest in making it possible to store media in a blob table in the database?
That requires some tuning to retain good performance (mostly related to the in-memory cache size), but it'd make backing up a lot easier and partial/incomplete files from crashes and other annoyances would be gone. SQLite (
https://sqlite.org/c3ref/blob_open.html)
can do incremental IO in blobs (so can others) and Python (
https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.blobopen)
actively supports it.