Re: [sqlite] Committing changes to the database without releasing a writer lock

On Fri, 8 Feb 2019 at 20:03, Theodore Dubois wrote: > I'd like to essentially commit changes to disk in the middle of the > transaction, resulting in a transaction that is atomic with respect to > other database connections but is two atomic transactions with respect to > the filesystem. >

Re: [sqlite] Min/Max and skip-scan optimizations

On Tue, 5 Feb 2019 at 22:46, Simon Slavin wrote: > On 5 Feb 2019, at 8:59am, Rowan Worth wrote: > > > SELECT source1, source2, ts, value > > FROM rolling > > WHERE source1 = 'aaa' > > AND ts > 1 AND ts < 1 > > ORDER BY source1, source2, ts; > > > > And this index: > > > > CREATE INDEX

[sqlite] Bug: SQLite 3.27.1 does not compile with SQLITE_OMIT_WINDOWFUNC

In case it helps anyone else, I plan to use the patch below to bypass the compilation error in Chrome. I'd appreciate a sanity check. I would also be very grateful for a check-in that addresses the compilation issue, so we can remove our patch in a future update. Thank you very much! Victor