Store PDF, image other binary data

HollosCs · 2017-09-21 17:15:03

Dear mORMot community!

Is good idea store large blob in Sqlite file with information? Or store information only Sqlite and blob store as files in folder? I would use mORMotish way as possible?

Thanks, Csaba

ab · 2017-09-21 18:45:37

Big blobs are rather stored as files, imho.
Then tables contain the metadata.
https://www.sqlite.org/intern-v-extern-blob.html

HollosCs · 2017-09-21 19:25:35

Thanks ab, it is really useful information. I will make a test for hybrid storage depends on size.

mORMot Open Source

#1 2017-09-21 17:15:03

Store PDF, image other binary data

#2 2017-09-21 18:45:37

Re: Store PDF, image other binary data

#3 2017-09-21 19:25:35

Re: Store PDF, image other binary data

Board footer