Re: [sqlite] Custom aggregate functions in Tcl

2019-01-30 Thread Andy Goth
On 1/30/19 3:27 PM, Andy Goth wrote: The next chance I get (probably tomorrow morning), I'll go ahead and add "step" or "final" as the initial argument to aggregate functions. I'll also lift the prohibition on aggregate functions with no arguments. This change is now committed.

Re: [sqlite] Custom aggregate functions in Tcl

2019-01-30 Thread Andy Goth
On 1/30/19 1:59 PM, Richard Hipp wrote: It seems that you distinguish between the xStep and xFinal methods by the number of argments. xStep [has] 1+N argument (where N is the number of function parameters) and xFinal has just 1. Yes. I was explicit about that in my first email. Dan

Re: [sqlite] Custom aggregate functions in Tcl

2019-01-30 Thread Richard Hipp
It seems that you distinguish between the xStep and xFinal methods by the number of argments. xStep as 1+N argument (where N is the number of function parameters) and xFinal has just 1. Dan suggests (and I agree) that this will not extend well to window functions. It might be better to have an

Re: [sqlite] Claimed vulnerability in SQLite: Info or Intox?

2019-01-30 Thread Simon Slavin
Since we're on this subject anyway, today's release of Chrome (version 72 for Mac, Windows and Linux) blocks the vulnerability two ways, even if it is somehow using a vulnerable pre- 3.26.0 version of SQLite. Simon. ___ sqlite-users mailing list

Re: [sqlite] Custom aggregate functions in Tcl

2019-01-30 Thread Andy Goth
On 1/29/19 1:15 AM, Andy Goth wrote: I wish to define custom aggregate functions in Tcl Initial implementation: https://chiselapp.com/user/andy/repository/sqlite-andy/info/e0689f05d1f8792d Sample program, intended to be run from the root of a built SQLite tree: #!/usr/bin/env tclsh load

Re: [sqlite] SQLite slow when lots of tables

2019-01-30 Thread Wout Mertens
Ah yes very true, it's easy to forget ones biases - I make single threaded web services with mostly-read access. This is a great use case for sqlite (provided you solve the data distribution problem). Wout. On Wed, Jan 30, 2019, 2:06 AM Keith Medcalf On Tuesday, 29 January, 2019 16:28, Wout