Really basic SQLite questions

Peter Haworth pete at lcsql.com
Mon Apr 28 16:59:27 CEST 2014


Well I guess it depends on the application but how do you manage locks
and/or cursors when continually opening/closing?

I'm also interested in what type of errors you've encountered that make
your database inaccessible? SQLite is most definitely designed for multiple
connections, just not by different users over a network.  There's no reason
why a Livecode application and a management tool running on the same
computer shouldn't be able to access the same database at the same time.

Pete
lcSQL Software
On Apr 27, 2014 10:26 PM, "Kay C Lan" <lan.kc.macmail at gmail.com> wrote:

> On Sat, Apr 26, 2014 at 12:04 AM, Mike Kerner <MikeKerner at roadrunner.com
> >wrote:
>
> > Bob, I agree that in general...  Since SQLite is a local file-store DB,
> > it's a little different.  it isn't designed for transaction loads,
> > multi-users, etc.
> >
>
> Which is why I'll offer one instance where it may make sense to open/close
> the connection after each query - during development. Because SQLite is not
> designed for multi-connections it makes it hard to troubleshoot unexpected
> results with another db Management Tool. I also note that some management
> tools I consider better than others because they DO close their connection
> after each query whilst others do NOT - which you'll eventually figure out
> by the new errors you get when you can't get LC to access the Tables you
> previously could.
>
> So I eventually learnt to open the SQLite db, do my query, close. Has sped
> up my development process no end. YMMV. In the end, it's actually so fast
> that I usually don't even bother changing it after everything is sorted
> out, although if there is a sequence of Queries I will only open at the
> beginning and close at the end.
> _______________________________________________
> 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