I imagine it is sqlite3 itself that is creating them. How one can get it to
change the way it does things I do not know. As I say it seems to work ok
with another app that is in the same setup. So why sqlite should behave in
an app specific way I do not know.
Peter
--
Resources:
- http://web2
On Friday, January 29, 2016 at 7:34:57 AM UTC-8, peter wrote:
>
> The strange thing is that it works okay with another app. So what I can I
> do about permissions. The permissions for the databases folder are okay. If
> I change the permissions on those files the changes are non persistent. So
The strange thing is that it works okay with another app. So what I can I
do about permissions. The permissions for the databases folder are okay. If
I change the permissions on those files the changes are non persistent. So
I am stuck.
On Friday, 29 January 2016 14:58:26 UTC, Niphlod wrote:
>
file permissions should be the issue because those files are not usual
ones.
On Friday, January 29, 2016 at 3:45:09 PM UTC+1, peter wrote:
>
> I am restating my problem with all that I now know.
>
>
>> I have a version of sqlite3 that is 3.7...
>>
>> I have been having problems with the databa
I am restating my problem with all that I now know.
> I have a version of sqlite3 that is 3.7...
>
> I have been having problems with the database being locked.
>
> So I tried
> db.executesql("PRAGMA journal_mode=WAL;")
>
> (just once)
>
> I then cannot access the application without getting
I will make sure not to delete this post. lol. Cool. glad to help.
On Thursday, January 28, 2016 at 11:38:48 AM UTC-5, peter wrote:
>
> Oh Ron, I see this might be a way of avoiding the lock problem without
> resorting to WAL. Thanks.
> Peter
>
> On Thursday, 28 January 2016 15:47:54 UTC, peter w
Oh Ron, I see this might be a way of avoiding the lock problem without
resorting to WAL. Thanks.
Peter
On Thursday, 28 January 2016 15:47:54 UTC, peter wrote:
>
> I have a version of sqlite3 that is 3.7...
>
> I have been having problems with the database being locked.
>
> So I tried
> db.exe
I have looked into it further, and two new files are created in my
databases directory.
storage.sqlite-wal
and
storage.sqlite-shm
They need their group write permissions to be set. However, they seem to
keep on getting deleted and recreated. Each time they are created their
group write permis
Have you tried db.commit()?
On Thursday, January 28, 2016 at 10:47:54 AM UTC-5, peter wrote:
>
> I have a version of sqlite3 that is 3.7...
>
> I have been having problems with the database being locked.
>
> So I tried
> db.executesql("PRAGMA journal_mode=WAL;")
>
> (just once)
>
> I then ca
9 matches
Mail list logo
