mORMot Open Source

MageCP

Member

Registered: 2022-02-02

Posts: 1

Files, Blob, Sqlite3, Insert, Retrieve

Hello guys,

I have few questions...

How can i save a file on db as blob?

How can i retrieve this file ?

THANKS FOR HELP!

SEE YOU SOON.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,206

Website

Re: Files, Blob, Sqlite3, Insert, Retrieve

You have blob-related methods for the ORM.

But they use RawByteString so are limited to the memory.
They are meant for small content - up to a few MB, not huge files.

For big files, a direct storage in a local folder is better, from our experiment.