Hi Michael You can find more info about this at http://www.sqlite.org/atomiccommit.html#brokenlocks
In general, it's risky accessing SQlite databases over a network unless you are only querying the database and not doing any insert/update/delete operations for the reasons explained in the link. Usually, options like shared cache are turned on and off using PRAGMA statements but I couldn't find one for this purpose. It looks like you enable shared cache when the database is opened by using a filepath similar to: file:<pathtomydb>?cache=shared when calling revOpenDatabase but I haven't tried it so not sure if LC would accept it. If it doesn't, we should probably file a bug report. There are some client/server tools out there for SQLite. Some are listed at http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork and no doubt a Google search will find others. I've never tried any of them so not sure how well they play with LC. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Tue, Mar 11, 2014 at 7:41 AM, Michael Gruenthal <mgruent...@mac.com>wrote: > I¹m interested in having a small (<20) number of users simultaneously > connected to an sqlite DB on a shared network drive as an alternative to > hosting on a server. I found some old (2010) discussions about this without > a clear answer. I¹m wondering if sqlite share-cache mode will permit this. > I > have a very rudimentary understanding of SQL so perhaps I¹m > misunderstanding > what shared-cache mode does, but I¹m hoping that the upgraded sqlite > support > in LC 6.6 in combination with shared-cache mode will allow at least a > limited number of concurrent connections. > > If so, does anyone know if there¹s a way to use revOpenDatabase() to open a > connection with shared-cache mode enabled? If I understand correctly it is > disabled by default. Thanks. > > Michael > > > _______________________________________________ > 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
