[sqlite] [feature request] Quirk-fixing compile-time options

s to opt out of these behaviors, as it would help prevent many difficult-to-find bugs. Any feedback on this suggestion by a SQLite3 dev would be much appreciated! Warmly, Joshua Wise ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] ANN: SQLite3 Decimal Extension

Julian dates are definitely floating point numbers, not integers. On Thu, Apr 4, 2019, 3:37 PM James K. Lowden wrote: > On Thu, 4 Apr 2019 11:21:41 -0400 > Joshua Wise wrote: > > > > On the other hand, what table has a floating point number in its > > > key? > >

Re: [sqlite] ANN: SQLite3 Decimal Extension

owden wrote: > > On Wed, 3 Apr 2019 17:29:47 -0400 > Richard Hipp wrote: > >> On 4/3/19, Joshua Wise wrote: >>> From my naive understanding, memcmp() is used to efficiently >>> compare long strings of bytes. But where in SQLite3 is it necessary >>> to com

Re: [sqlite] ANN: SQLite3 Decimal Extension

Oh of course, that makes sense. I suppose that means querying on REAL indexes should be slower than querying on INTEGER indexes, in the current SQLite3 implementation? Has a benchmark of this ever been done? > On Apr 3, 2019, at 5:29 PM, Richard Hipp wrote: > > On 4/3/19, Joshua Wi

Re: [sqlite] ANN: SQLite3 Decimal Extension

From my naive understanding, memcmp() is used to efficiently compare long strings of bytes. But where in SQLite3 is it necessary to compare long strings of floating point numbers? I, of course, can imagine SQL queries plucking single floating point values from rows or indexes, but I can’t

Re: [sqlite] WAL grows without bounds, short concurrent writes & reads

Awww sadness. Regardless, thanks for the update. > On Mar 29, 2019, at 11:07 AM, Richard Hipp wrote: > > On 3/29/19, Joshua Wise wrote: >> Dan, are there any plans to merge the wal2 branch into the trunk? > > No, not at this time. > > > -- >

Re: [sqlite] WAL grows without bounds, short concurrent writes & reads

Dan, are there any plans to merge the wal2 branch into the trunk? > On Mar 29, 2019, at 7:10 AM, Dan Kennedy wrote: > > > There's code here, if you want to experiment with it: > > https://sqlite.org/src/timeline?r=wal2 > > Docs: > > https://sqlite.org/src/artifact/a807405a05e19a49 > >

Re: [sqlite] Feature request: dynamically referenced bind parameters

Yes, but the problem is that I need to also retrieve the articles themselves. If I were to embed the articles query inside the staff query (as you’ve shown), the database would have to execute the article query twice. > On Mar 27, 2019, at 4:42 PM, Keith Medcalf wrote: > > > You mean

Re: [sqlite] Row locking sqlite3

I’ve seen the server mode branch, but to me it’s a deal-breaker that it requires SYNCHRONOUS = OFF. This BEGIN CONCURRENT idea really interests me. By using WAL mode,

Re: [sqlite] read-only database in WAL mode and temporary files

From my understanding, the SHM file is needed to communicate to writers that they are in fact performing a read operation (i.e., locks). Without that communication, a writer might insert some data and then perform a checkpoint, without knowing that there is a database reader, and thus overwrite

Re: [sqlite] Recursive CTE on tree with doubly linked items

> On Mar 18, 2019, at 5:21 AM, Keith Medcalf wrote: > > UPDATE tree > SET position = (SELECT position FROM _children WHERE id = tree.id) -- > Multiply by x to number by x > WHERE id IN (SELECT id FROM _children); > DELETE FROM _children; > END; I don’t see the window function causing

Re: [sqlite] Documentation is lying to me

; <mailto:sqlite-users-boun...@mailinglists.sqlite.org>] On Behalf Of Joshua > Wise > Sent: Wednesday, February 27, 2019 2:13 PM > To: SQLite mailing list > Subject: Re: [sqlite] Documentation is lying to me > > I can confirm that it also doesn’t work with SQLite version 3.24.0

Re: [sqlite] Documentation is lying to me

I can confirm that it also doesn’t work with SQLite version 3.24.0 on a completely different machine. > On Feb 27, 2019, at 9:23 AM, Joshua Thomas Wise > wrote: > > Joshuas-MBP:sqldark josh$ sqlite3 > SQLite version 3.25.0 2018-09-15 04:01:47 > Enter ".help" for usage hints. > Connected to a