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

HollosCs
Member
Registered: 2015-12-08
Posts: 56

Store PDF, image other binary data

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

Offline

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

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,700
Website

Re: Store PDF, image other binary data

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

Offline

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

HollosCs
Member
Registered: 2015-12-08
Posts: 56

Re: Store PDF, image other binary data

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

Offline

Board footer

Powered by FluxBB