#1 2016-12-19 19:40:31

DavidRM
Member
Registered: 2016-12-19
Posts: 29

BigTable with mORMot?

I'm researching possible solutions for an issue I have. Specifically, I'm looking for a way to store media files (which can be large) separately from my main Sqlite database (where, yes, they're currently stored). I don't want to use a file system for various reasons I won't go into.

BigTable caught my eye. Then I started reading through the mORMot documentation. But I'm not seeing BigTable in there (just one passing reference). Am I missing something?

Thanks.

-David

Offline

#2 2016-12-20 11:11:35

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,388
Website

Re: BigTable with mORMot?

BigTable was not meant to store a lot of content, since it uses memory mapped file for its storage.
All data should be mapped in memory.
So BigTable is not  good option for your specific task...

IMHO such media files should be stored in a file system, not in a DB...
See https://www.sqlite.org/intern-v-extern-blob.html
If you add some encryption (e.g. using our fast SynCrypto unit), file storage may be safe and efficient.

Offline

#3 2016-12-20 14:08:56

DavidRM
Member
Registered: 2016-12-19
Posts: 29

Re: BigTable with mORMot?

OK. That clears that up. BigTable is off the table.

But it brings up the related question of using file system storage with mORMot. Are there any hooks for doing that?

Thanks!

-David

Offline

#4 2016-12-20 18:24:02

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,388
Website

Re: BigTable with mORMot?

See e.g. sample 26.

It published a TSQLNoteFile table via REST, and allow custom REST storage of blobs in local files.

Offline

Board footer

Powered by FluxBB