Database syntax

mike at doub.com mike at doub.com
Wed Dec 21 16:34:37 EST 2011


Not any hair left to pull out.  I am enjoying the banter and learning at the same time. 

Keep it coming!

  -= Mike
 
Sent from my BlackBerry device on the Rogers Wireless Network

-----Original Message-----
From: Pete <pete at mollysrevenge.com>
Sender: use-livecode-bounces at lists.runrev.com
Date: Wed, 21 Dec 2011 10:35:26 
To: How to use LiveCode<use-livecode at lists.runrev.com>
Reply-To: How to use LiveCode <use-livecode at lists.runrev.com>
Subject: Re: Database syntax

I think the guy who asked the original question must be tearing his hair
out by now!

One thing I mentioned earlier that might be relevant to him is that there's
no need to use blobs when storing LC arrays. Just use base64 encoding and
store it in a text field, works fine.  Some folks on this list pointed me
in that direction a few months back.

On Wed, Dec 21, 2011 at 12:48 AM, Bernard Devlin <bdrunrev at gmail.com> wrote:

> Actually, this was precisely the situation in which multiple LC
> arrays, being used as "tables", where the array key was the primary
> key of the "table", and joining these "tables" was far faster to do
> using LC arrays than any in-memory SQL database.  Admittedly these
> were only 2-way and 3-way joins, so _maybe_ if they were 7-way joins I
> might not have seen the same performance difference.
>
> If you need a RDBMS (and integrity checks, triggers, etc), then you
> probably do need it -- there's no point in re-inventing the wheel.
> But if you need to just store a list of blobs, then an array with
> pointers to blobs on the filesystem might still be much faster (and
> much simpler).
>
> I'm not opposed to RDBMS per se.  In my time, I've used Oracle,
> Firebird, Frontbase, Postgresql, Openbase, HSQL, Valentina and Sqlite,
> and I still use some of those if the situation needs it.
>
> Bernard
>
> On Wed, Dec 21, 2011 at 2:25 AM, Pete <pete at mollysrevenge.com> wrote:
> >  But as soon as you get into multiple datasets with links between them or
> > multiple ways to access one dataset or multiple users accessing the same
> > data, there's a strong justification to use a database unless the
> > performance/memory issues are so bad that you can't deal with them
> (which I
> > find difficult to believe).
>
> _______________________________________________
> 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
>
>


-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>
_______________________________________________
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