Re: [sqlite] LIMIT

2018-06-28 Thread Richard Rousselot
Just wanted to support the idea of adding windowing functions to SQLite as it is the biggest hurdle for me to get others to use it. If size is an issue, I would love to have a build option to enable it. My $0.02 On Tue, Jun 26, 2018 at 8:27 AM Gert Van Assche wrote: > Thanks Olivier, very

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

2018-06-11 Thread Richard Rousselot
If FTS5 is enabled by default in the amalgamation, the documentation needs to be updated. https://sqlite.org/fts5.html Section 2.1 On Mon, Jun 11, 2018 at 9:57 AM Richard Hipp wrote: > On 6/11/18, Lonnie Abelbeck wrote: > > > >> On Jun 11, 2018, at 7:23 AM, Richard Hipp wrote: > >> > >> On

Re: [sqlite] Site error

2018-03-19 Thread Richard Rousselot
The error is back I think. I am getting same message. Also, since I have your attention, why not just make the search box always visible vs. having to click it. Seems like an unnessary step. Richard On Fri, Mar 16, 2018 at 1:03 PM Richard Hipp wrote: > On 3/16/18, David

Re: [sqlite] Simple read-only program very slow

2017-12-03 Thread Richard Rousselot
Had similar issue a few years ago; we were using the SQLite3.exe. We recompiled the exe as 64 bit which allowed it to use more than 4 GB of ram, loaded the machine with as much memory as we could. Voila, super fast processing. Can the Python libraries be made 64 bit some how? On Thu, Nov 30,