Multi user sqlite via shared-cache mode?

[Michael Gruenthal]

Thanks Pete,

I received some advice off list that convinced me to not risk pushing the
bounds of SQLite in this fashion, but URI filenames should be part of the
updated SQLite support, nonetheless.

Michael

On 3/11/14, 1:02 PM, "Peter Haworth" <pete at lcsql.com> wrote:

>Hi Michael,
>I just verified that URI filenames don't work in LC v6.6 and have filed
>bug
>report # 11919.
>
>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
><mgruenthal at 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 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