-boun...@mailinglists.sqlite.org] On Behalf Of Janke, Julian
Sent: Mittwoch, 22. April 2015 13:13
To: ambrus at math.bme.hu; General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
Thank you for the hint. I'll check that.
-Original Message-
From: s
, 22. April 2015 12:59
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 4/22/15, Janke, Julian wrote:
> The embedded system has various storage media, with different read /
> write speeds.
> A quick and dirty test shows that the outso
t: Re: [sqlite] Problems with pragma journal_mode
On Wed, Apr 22, 2015 at 10:46 AM, Janke, Julian
wrote:
> I have tested some of the other pragmas and none worked. After
> discussing with you now I come to the conclusion that the problem is
> caused more by my local setup. I
In that case,
ble_info=TABLE;". See the complete list at
(https://www.sqlite.org/pragma.html#toc). Are any pragmas working on your
system?
On 4/20/15, Janke, Julian wrote:
> I'm pretty sure that they are completely. Later this discussion I
> added
> -DSQLITE_DEFAULT_LOCKING_MODE=1
>
te.org] On Behalf Of Richard Hipp
Sent: Montag, 20. April 2015 15:55
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 4/20/15, Janke, Julian wrote:
>
> PRAGMA compile_options; shows 0
This makes me think that the list of compile-time optio
Sent: Montag, 20. April 2015 12:18
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 4/20/15, Janke, Julian wrote:
> 'EXPLAIN PRAGMA journal_mode=WAL' returns 2 rows
>
> 0: 0 Init 0 0 0
> 1: 1 Halt 0 0 0
>
You shoul
Hipp
Sent: Freitag, 17. April 2015 16:59
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 4/17/15, Janke, Julian wrote:
> Hello,
> Thanks for your reply.
>
> I changed my code again:
>
> 1) rc = sqlite3_open(dbPath, &db); -->
es at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Dominique
Devienne
Sent: Freitag, 17. April 2015 13:50
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On Fri, Apr 17, 2015 at 12:59 PM, Janke, Julian
General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 17 Apr 2015, at 11:12am, Janke, Julian wrote:
> I changed my code again:
Move the DROP TABLE command on line 5 to after the _finalize() call. But I
don't think it'll make any differe
ent: Donnerstag, 16. April 2015 17:56
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 16 Apr 2015, at 2:33pm, Janke, Julian wrote:
> rc = sqlite3_step(stmt);
> --> returns SQLITE_DONE
After the above two lines, print the value
ehalf Of Simon Slavin
Sent: Donnerstag, 16. April 2015 14:15
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode
On 16 Apr 2015, at 10:10am, Janke, Julian wrote:
> rc = sqlite3_open(dbPath, &db);
> rc = sqlite3_exec(db, "PRAGMA jour
April 2015 11:23
To: sqlite-users at mailinglists.sqlite.org
Subject: Re: [sqlite] Problems with pragma journal_mode
Janke, Julian wrote:
> PRAGMA journal_mode=WAL;
>
> Unfortunately, after these lines, the journal mode is not changed.
>
> -DSQLITE_OS_OTHER=1
Do you have mmap sup
ubject: Re: [sqlite] Problems with pragma journal_mode
On 16 April 2015 at 10:10, Janke, Julian wrote:
> Hi everyone,
>
> I'm relatively new to SQLite and currently I'm experimenting a little bit
> with the SQLite database on an embedded system.
> I want to change the jo
Hi everyone,
I'm relatively new to SQLite and currently I'm experimenting a little bit with
the SQLite database on an embedded system.
I want to change the journal mode of a database to WAL. So I did the following:
rc = sqlite3_open(dbPath, &db);
rc = sqlite3_exec(db, "PRAGMA journal_mode=WAL;",
Hello,
we plan to port the SQLite library on an embedded system, which runs on a
platform other than the ones that are supported out of the box (it’s an SMX
based system). For the first step, we don’t need a working mutex subsystem,
because we have no multithreaded environment. The required standa
Firma: Capgemini Deutschland GmbH
Aufsichtsratsvorsitzender: Antonio Schnieder • Geschäftsführer: Dr. Michael
Schulte (Sprecher) • Jost Förster • Dr. Peter Lempp • Dr. Volkmar Varnhagen
Amtsgericht Berlin-Charlottenburg, HRB 98814
This message contains informati
16 matches
Mail list logo