Thoughts on BLOBs in SQLite

jonathandlynch at gmail.com jonathandlynch at gmail.com
Thu Aug 24 18:22:56 CEST 2017


The advantage comes if you are displaying the image through a web browser - you can put in the URL for the image and let the webview handle concurrent image loading.

I still went the other way, for other reasons, but that is one of the advantages.

The other is database file size.

Sent from my iPhone

> On Aug 24, 2017, at 10:56 AM, Sannyasin Brahmanathaswami via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Tom Glod wrote:
> 
>    so I base encode the binary variable and then save it in a text field in
>    table. no problems and no bs ever.
> 
> 
> Others do this also. I'm curious from an "uber architecture" point of view, what pros there are to keeping the image data in a base encoded form in the data base versus just keeping a file.jpg on disk?
> 
> BR
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list