Re: [sqlite] Update the SQLite package in Tcl

On Sunday, 19 November, 2017 20:46, Joseph R. Justice wrote: >On Sun, Nov 19, 2017 at 4:49 PM, Keith Medcalf >wrote: >> On 19 November, 2017 10:50, Joseph R. Justice >asked: >> The same applies for SQLite and anything else

Re: [sqlite] Update the SQLite package in Tcl

On Sat, Nov 18, 2017 at 1:06 PM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: I have installed Tcl/Tk from a couple of places on the web (activetcl > and magicsplat), and I find that neither of them has the latest version of > sqlite3 as the standard sqlite3 package. ActiveTcl

Re: [sqlite] Update the SQLite package in Tcl

On Sun, Nov 19, 2017 at 4:49 PM, Keith Medcalf wrote: > On 19 November, 2017 10:50, Joseph R. Justice asked: > > >I'd think that dropping a newer version of SQLite, compiled as a run- > >time linkable library, into a pre-existing binary compiled to

[sqlite] A walIndexAppend() crash after calling "PRAGMA journal_mode"

I tracked down a occasional system crash problem of calling "PRAGMA journal_mode" and found that walIndexRecover()->walIndexAppend() is finally called before the crash according to my callstack. In sqlite3.c, walIndexAppend() can be called after walIndexRecover() only when nSize, the size of

Re: [sqlite] Good resources for TCL/TK

Thus said Cecil Westerhof on Sat, 18 Nov 2017 14:43:23 +0100 I found the benefits for TCL/TK. But this is a SQLite mailing list, so not the right place to ask questions if it is not connected to SQLite also. What would be good resources for TCL/TK? There's also a pretty active IRC room on

Re: [sqlite] Update the SQLite package in Tcl

On 19 November, 2017 10:50, Joseph R. Justice asked: >I'd think that dropping a newer version of SQLite, compiled as a run- >time linkable library, into a pre-existing binary compiled to use a >previous version of SQLite would require the ABI for SQLite (compiled >for use

Re: [sqlite] Update the SQLite package in Tcl

On Nov 18, 2017 1:22 PM, "Richard Hipp" wrote: On 11/18/17, Balaji Ramanathan wrote: > Hi, > > I have installed Tcl/Tk from a couple of places on the web (activetcl > and magicsplat), and I find that neither of them has the latest version of >

Re: [sqlite] Update the SQLite package in Tcl

Are there equivalent instructions for Windows? Thank you. Balaji Ramanathan -- Forwarded message -- From: Richard Hipp To: SQLite mailing list Cc: Bcc: Date: Sat, 18 Nov 2017 13:22:45 -0500 Subject: Re: [sqlite] Update the

Re: [sqlite] Confusion about DISTINCT keyword

This is great information. Thank you very much for a clear explanation, Keith. I guess I have to go back to using CTE's to get what I want in this case. Balaji Ramanathan -- Forwarded message -- From: Keith Medcalf To: SQLite mailing list

Re: [sqlite] SQL top 3

Dear David, could you help me to understand why your query does what it does? The magic seems to be in this bit where the field country is self-referenced: where c.country = countries.country Only: I don't understand why this does what we want it to do. I tried to build a query of

Re: [sqlite] Unexpected echo when setting locking_mode

I'm not against rationalising the PRAGMA commands, but this wouldn't help with the example you gave. "page_size" is more accurately "the page size I would like it to be" and so can be "successfully" set at any time (providing it's a power of 2). The only time the current setting gets _acted_

Re: [sqlite] Does wal-file support MMAP？

On 19 Nov 2017, at 6:15am, Howard Kapustein wrote: > On 10 Nov 2017, at 8:49am, advancenOO wrote: > >> hAve you optimised your column orders ? > What is optimal? SQLite reads only up to the last column it needs to execute the