On Monday, 9 March, 2020 18:18, Peng Yu wrote:
>But I never experience the problem in my original email when I used
>python3's default sqlite3 module (WAL was not used). What is the
>difference between the default sqlite3 module and apsw? Thanks.
THe relevant difference is that the sqlite3 wrap
On 3/8/20, Keith Medcalf wrote:
>
> On Sunday, 8 March, 2020 21:24, Peng Yu wrote:
>
>>When I open an sqlite3 db using the following python code,
>
>>conn=apsw.Connection(filepath, flags = apsw.SQLITE_OPEN_READONLY)
>
>>, I got the following error.
>
>>Traceback (most recent call last):
>> File
On Monday, 9 March, 2020 08:33, Simon Slavin wrote:
>If your .shm and .wal files still exist when no apps are accessing the
>database, the most likely cause is that at least one of the apps is not
>closing its connection correctly.
or you are opening the database connection with SQLITE_OPEN_REA
On 9 Mar 2020, at 2:16pm, David Raymond wrote:
> In general I believe the last connection tries to do a complete checkpoint
> when it closes, and if it succeeds then it'll delete the -wal and -shm files.
> If you have automatic checkpointing turned off (maybe you're doing regular
> checkpoints
I see this. What does it mean? Does it mean even when the sqlite3
session is closed there is still -wal and -shm left on the disk?
"""
There is an additional quasi-persistent "-wal" file and "-shm" shared
memory file associated with each database, which can make SQLite less
appealing for use as an
I see this. What does it mean? Does it mean even when the sqlite3
session is closed there is still -wal and -shm left on the disk?
"""
There is an additional quasi-persistent "-wal" file and "-shm" shared
memory file associated with each database, which can make SQLite less
appealing for use as an
[This explanation is much simplified for clarity. Before filling in missing
details please consider what the OP wants. Don't just show off your exhaustive
knowledge of SQLite.]
A database is normally in delete journal mode, as if you'd executed
PRAGMA journal_mode=DELETE
In this journal mode
On Sunday, 8 March, 2020 21:24, Peng Yu wrote:
>When I open an sqlite3 db using the following python code,
>conn=apsw.Connection(filepath, flags = apsw.SQLITE_OPEN_READONLY)
>, I got the following error.
>Traceback (most recent call last):
> File "/xxx.py", line 21, in
>for x in c.execu
When I open an sqlite3 db using the following python code,
conn=apsw.Connection(filepath, flags = apsw.SQLITE_OPEN_READONLY)
, I got the following error.
Traceback (most recent call last):
File "/xxx.py", line 21, in
for x in c.execute('SELECT (data) FROM sqlar'):
File "src/cursor.c", l
9 matches
Mail list logo