[sqlite] Fw: how are you?

Hi friend! I've read an article recently nd it reminded me of you, please read it here and tell me your thoughts Good wishes, ronny.dierckx ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] When does SQLite open/create files?

> On Nov 23, 2016, at 1:31 PM, Richard Hipp wrote: > > Have you enabled the error and warning log? > (https://www.sqlite.org/errlog.html ) > IIRC, the error log will give > you the name of the file that could not be opened. No! I wasn’t

[sqlite] Warning message about "database schema has changed", although sqlite3_step succeeds

Now that I’ve enabled the SQLite error log, I’m seeing some unexpected messages, like this one during sqlite3_step: statement aborts at 28: [CREATE TABLE IF NOT EXISTS …] database schema has changed {at errorLogCallback:116} The DB schema must have changed since the statement

Re: [sqlite] Warning message about "database schema has changed", although sqlite3_step succeeds

On 11/23/16, Jens Alfke wrote: > Now that I’ve enabled the SQLite error log, I’m seeing some unexpected > messages, like this one during sqlite3_step: > > statement aborts at 28: [CREATE TABLE IF NOT EXISTS …] database > schema has changed {at

Re: [sqlite] SQLite binary with Math Functions for OS-X?

Keith … THANKS. I should have caught that — these senior citizen eyes ain’t what they used to be. > On Nov 23, 2016, at 8:24 AM, Keith Medcalf wrote: > > > If what appears is what was entered, then you need to change the closing ’ to > a closing ' (that is, from a

Re: [sqlite] SQLite binary with Math Functions for OS-X?

David, The brew/install worked and created the sqlite app and library in the locations specified in your instructions. I can load the math lib from the .load (dot load) command line, The median function works as I wanted but the ‘load_extension’ select statement did not work; I get a command

Re: [sqlite] SQLite binary with Math Functions for OS-X?

If what appears is what was entered, then you need to change the closing ’ to a closing ' (that is, from a funny word-processor symbol that looks like a quote but is really an apostrophe used in typesetting but is not a quote that terminates a string, into a quote to terminate the string) ...

Re: [sqlite] Pragma to flag unknown pragma?

Most pragmas allow you to issue them in a mode such as to query a current state. So to use your example pragma journal_mode = persist; followed by pragma journal_mode; with a subsequent check to see that the returned value is set to what you want it to be set to (actually the new value is

[sqlite] row values with BETWEEN

Hi, i hope I'm not overlooking something obvious, but the last result below is not what I would expect. Just wondering if this could somehow be correct and, if so, how to understand it. regards, Mark $ sqlite3 SQLite version 3.15.1 2016-11-04 12:08:49 Enter ".help" for usage hints.

Re: [sqlite] creating a table

Thank you! John On 11/22/2016 01:21 PM, R Smith wrote: On 2016/11/22 6:00 PM, John R. Sowden wrote: That was a throw back to years ago. I was trying to protect against y2k by making each dbf for 1 calendar year. Also, these files are about 800k in size, so I was worried about storage

Re: [sqlite] Pragma to flag unknown pragma?

On Tue, Nov 22, 2016 at 10:50 PM, R Smith wrote: > On 2016/11/23 2:08 AM, Scott Hess wrote: >> https://www.sqlite.org/pragma.html has: >> "No error messages are generated if an unknown pragma is issued. >> Unknown pragmas are simply ignored. This means if there is a typo in a

Re: [sqlite] row values with BETWEEN

On 11/23/16, Mark Brand wrote: > Hi, > > i hope I'm not overlooking something obvious, but the last result below > is not what I would expect. https://www.sqlite.org/src/info/1a68465637e1b014 -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] When does SQLite open/create files?

On 23 Nov 2016, at 7:54pm, Jens Alfke wrote: >> On Nov 22, 2016, at 2:10 PM, Richard Hipp wrote: >> >> No. Did you run "PRAGMA temp_store=MEMORY;"? This might be a >> statement journal opening. > > No. (The string “temp_store” does not appear anywhere

Re: [sqlite] Pragma to flag unknown pragma?

On Tue, 22 Nov 2016 16:08:49 -0800 Scott Hess wrote: > One could perhaps fake pedantic pragma with SQLITE_FCNTL_PRAGMA in a > custom VFS, but that seems a little excessive for something like this. > Something like "PRAGMA pedantic_pragma = on" would be much slicker. You might

Re: [sqlite] When does SQLite open/create files?

> On Nov 23, 2016, at 12:45 PM, Simon Slavin wrote: > > Are you checking the value returned by each call to the SQLite API to make > sure it's SQLITE_OK ? Yes. As I said, the error is returned from sqlite3_step(), but it doesn’t specify _what_ file couldn’t be opened.

Re: [sqlite] When does SQLite open/create files?

On 11/23/16, Jens Alfke wrote: > >> On Nov 23, 2016, at 12:45 PM, Simon Slavin wrote: >> >> Are you checking the value returned by each call to the SQLite API to make >> sure it's SQLITE_OK ? > > Yes. As I said, the error is returned from sqlite3_step(),

Re: [sqlite] When does SQLite open/create files?

> On Nov 22, 2016, at 2:10 PM, Richard Hipp wrote: > > No. Did you run "PRAGMA temp_store=MEMORY;"? This might be a > statement journal opening. No. (The string “temp_store” does not appear anywhere in the source code.) Any way I can get more info from SQLite about exactly