SQLite Locking

Peter Haworth pete at mollysrevenge.com
Wed Dec 1 14:19:24 EST 2010


Yep, these dot commands only mean anything to the sqlite3 command line  
program, not SQlite itslef.  I thought of executing a script to issue  
the .time but honestly, the LC loop is 6 lines of code so it's not a  
big deal to keep it in LC.

STill got to get around to doing my tests over a network though.

Pete Haworth

On Dec 1, 2010, at 10:09 AM, Bob Sneidar wrote:

> NVM I tried it. I guess it's only a shell command. Still, you might  
> wanna try shelling into the database before opening it and executing  
> this command. Check out this link:
>
> http://www.sqlite.org/sqlite.html
>
> Bob
>
>> Have you tried this?
>>
>> .timeout MS            Try opening locked tables for MS milliseconds
>>
>> Set that to 2000 for a 2 second "retry" on the cheap maybe?
>>
>> Bob
>>
>>
>> On Nov 30, 2010, at 4:13 PM, Peter Haworth wrote:
>>
>>> Good idea, but it got thrown back with an error.  It's not a valid  
>>> SQL statement, just something the tcl/c api understands I think.   
>>> Not a big deal though, it's pretty easy to set that timeout loop  
>>> in within LC.
>>>
>>> Pete Haworth
>>>
>>> On Nov 30, 2010, at 12:05 PM, Bob Sneidar wrote:
>>>
>>>> Did you try to issue this as a query, with and without  
>>>> substituting db1 with your database name?
>>>>
>>>> Bob
>>>>
>>>>
>>>> On Nov 29, 2010, at 4:46 PM, Peter Haworth wrote:
>>>>
>>>>>> db1 timeout 2000
>>>>>> The argument to the timeout method is the maximum number of  
>>>>>> milliseconds to wait for the lock to clear. So in the example  
>>>>>> above, the maximum delay would be 2 seconds.
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>
> _______________________________________________
> 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