[sqlite] Problems with pragma journal_mode

-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

[sqlite] Problems with pragma journal_mode

, 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

[sqlite] Problems with pragma journal_mode

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,

[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, as you have a custom vfs, could you check if it's your

[sqlite] Problems with pragma journal_mode

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Montag, 20. April 2015 16:32 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode If the compile-time options you have shown are complete, then the PRAGMA command ought to be

[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 outsourcing of the journal files on a > faster medium may be a significant speed boost. > Is there a possibility to write journal(temporar

[sqlite] Problems with pragma journal_mode

On 4/22/15, Zsb?n Ambrus wrote: > > In that case, as you have a custom vfs, could you check if it's your > vfs that is handling those pragmas? The documentation at > "http://sqlite.org/c3ref/c_fcntl_busyhandler.html#sqlitefcntlpragma"; > describes that when you run a PRAGMA statement on a databas

[sqlite] Problems with pragma journal_mode

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

[sqlite] Problems with pragma journal_mode

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

[sqlite] Problems with pragma journal_mode

org > [mailto:sqlite-users-bounces at mailinglists.sqlite.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:

[sqlite] Problems with pragma journal_mode

g > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard > Hipp > 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: >> &#x

[sqlite] Problems with pragma journal_mode

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); -->

[sqlite] Problems with pragma journal_mode

, 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(db

[sqlite] Problems with pragma journal_mode

On Fri, Apr 17, 2015 at 12:59 PM, Janke, Julian wrote: > Unfortunately, I can't run the shell tool on the es and try the same > sequence of commands. > Why? Don't you have some kind of shell on that embedded system that can run executables? According to https://www.sqlite.org/howtocompile.html,

[sqlite] Problems with pragma journal_mode

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

[sqlite] Problems with pragma journal_mode

On 17 Apr 2015, at 11:59am, Janke, Julian wrote: > I've changed the stmt to "SELECT 'Hello World !!';" > In this case, > > sqlite3_step() returns SQLITE_ROW > sqlite3_column_text() returns 'Hello World !!' > > That, looks right. I agree. And it shows that your C code is working perfectly. F

[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 difference. You should not be getting SQLITE_DONE back from your call to _step(). The documentation says that th

[sqlite] Problems with pragma journal_mode

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

[sqlite] Problems with pragma journal_mode

Thanks for your help > > > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Simon > Slavin > Sent: Donnerstag, 16. April 2015 17:56 > To: General Discussion of SQL

[sqlite] Problems with pragma journal_mode

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

[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 returned by sqlite3_column_text(stmt, 0) I'm not good at C off the top of my head but I think it's something like - const unsigned

[sqlite] Problems with pragma journal_mode

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

[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 journal_mode=WAL;", testCallbackPrint, 0, > &zErrMsg); > [?] > sqlite3_close(db); Execute your PRAGMA as if it's a SELECT call (i.e. use sqlite3_prepare_v2(), sqlite3_step(), and

[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 support? says: | WAL normally requires that the VFS support shared-memory primitives. | The built-in uni

[sqlite] Problems with pragma journal_mode

On Thu, Apr 16, 2015 at 11:10 AM, Janke, Julian wrote: > 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;", testCallbackPrint, 0, > &zErrMsg); > [?] > sqlite3_close(db); > > Unfo

[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 journal mode of a database to WAL. So I did the > following: > > rc = sqlite3_open

[sqlite] Problems with pragma journal_mode

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

[sqlite] Problems with pragma journal_mode

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

[sqlite] Problems with pragma journal_mode

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;",