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.macm...@gmail.com> wrote: > On Sat, Apr 26, 2014 at 12:04 AM, Mike Kerner <mikeker...@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
