Thoughts on BLOBs in SQLite

Glen Bojsza gbojsza at gmail.com
Wed Aug 23 14:56:49 EDT 2017


Thanks Steve...it looks like (in my current case) that the encode / decode
SQLite text field is the easiest way to get me solution.

Glen

On Wed, Aug 23, 2017 at 1:43 PM, Stephen MacLean via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Hi Glen,
>
> First, as Richard G. mention, internet wars have been fought over this
> issue… to me it’s your choice.
>
> I’ve done both and both have their ups and downs.
>
> For mobile, I’ve sided with keeping it in the DB. It keeps everything
> together and the way I’m querying the DB, I’m already pulling the data and
> the image just comes along with it. My experience is that it’s very fast.
>
> As does Jonathan L, I store my images as base64 encoded so they can be
> transmitted over the internet as needed and decode them on the fly when
> needed by the app. The added benefit is you can store them in a TXT field
> in SQLite. LC is very fast at decoding them.
>
> As for growing in size, especially for mobile, something is going to grow
> either way… wether it’s the files on the file system or the DB file, as you
> add, it’s going to grow.
>
> Sorry, I don’t have anything resembling a example stack to share, but in
> keeping the above in mind, it’s not too hard to implement.
>
> HTH,
>
> Steve MacLean
>
>
> > On Aug 23, 2017, at 12:11 PM, Glen Bojsza via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >
> > Hello,
> >
> > I was looking for feedback on whether it is better to store images as
> BLOBs
> > in an SQLite database for a LC app or store paths to the images in the
> > SQLite database and the images in a separate folder.
> >
> > Any help in understanding possible performance and memory issues is what
> I
> > am looking for.
> >
> > Can I assume that any issues would be the same for both Android and iOS?
> >
> > thanks,
> >
> > Glen
> > _______________________________________________
> > 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
>
>
>
> _______________________________________________
> 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