[sqlite] Allow inclusion of generate_series function

2018-10-25 Thread Nathan Green
Hi, According to the online documentation (https://www.sqlite.org/series.html), generate_series is compiled into the command line shell. As it turns out, this is not so. It is not even an option in the build system from what I can tell. It would be nice to at least have a build flag to enable it.

Re: [sqlite] Allow inclusion of generate_series function

2018-12-04 Thread Digital Dog
On Thu, 25 Oct 2018 09:32:05 -0700 Nathan Green wrote: > According to the online documentation (https://www.sqlite.org/series.html ), > generate_series is compiled into the command line shell. As it turns out, > this is not so. It is not even an option in the build system from what I > can tell. I

Re: [sqlite] Allow inclusion of generate_series function

2018-12-04 Thread Richard Hipp
On 12/4/18, Digital Dog wrote: > > I vote for GENERATE_SERIES to be included in official sqlite3 binary and > libraries. That seems unlikely, since you can accomplish the same thing using a recursive common table expression. We are under pressure to keep SQLite as small and compact as possible.

Re: [sqlite] Allow inclusion of generate_series function

2018-12-04 Thread Digital Dog
On Tue, Dec 4, 2018 at 5:57 PM Richard Hipp wrote: > > On 12/4/18, Digital Dog wrote: > > > > I vote for GENERATE_SERIES to be included in official sqlite3 binary and > > libraries. > > We are under pressure to keep SQLite as small and compact as possible. > We cannot go adding every feature that

Re: [sqlite] Allow inclusion of generate_series function

2018-12-06 Thread Nathan Green
On Tue, Dec 4, 2018 at 11:25 AM Digital Dog wrote: > On Tue, Dec 4, 2018 at 5:57 PM Richard Hipp wrote: > > > > On 12/4/18, Digital Dog wrote: > > > > > > I vote for GENERATE_SERIES to be included in official sqlite3 binary > and > > > libraries. > > > > We are under pressure to keep SQLite as

Re: [sqlite] Allow inclusion of generate_series function

2018-12-06 Thread Keith Medcalf
On Thursday, 6 December, 2018 08:23, Nathan Green wrote: >On Tue, Dec 4, 2018 at 11:25 AM Digital Dog wrote: >> On Tue, Dec 4, 2018 at 5:57 PM Richard Hipp wrote: >> > On 12/4/18, Digital Dog wrote: >> > > I vote for GENERATE_SERIES to be included in official sqlite3 >> > > binary and librar

Re: [sqlite] Allow inclusion of generate_series function

2018-12-11 Thread Digital Dog
On Thu, Dec 6, 2018 at 8:06 PM Keith Medcalf wrote: > > Why one would want a particular capability available in the shell that is > not available when compiling the amalgamation code directly is beyond my > ken. The issue is not limited to generate_series (although that one seems to be pain poi

Re: [sqlite] Allow inclusion of generate_series function

2018-12-11 Thread sub sk79
Hi, I think both your requirements and Dr Hipp's point-of-view are valid if we continue to see SQLite as just a tool. Yes, SQLite is an amazing tool for all the things it does and especially for a great design which almost never stands in the way of user customization and extension. However, SQLit