On Thu, Dec 6, 2018 at 8:06 PM Keith Medcalf <[email protected]> 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 point for many users). The issue is that all sqlite downloads offered on the project's home page could contain more extensions by default, because they target capable platforms. Only some platforms these days are restricted. Projects using these platforms require custom builds of sqlite anyway. Why I want fully-fledged sqlite shell? To be able to easily juggle data straight from the OS shell, using one-liners, pipelines or bash scripts without having to compile/enable/whatever my own sqlite shell. To just be able to download sqlite3 executable and start working. By offering sqlite shell with most (or all) extensions enabled, the authors would increase out-of-the-box data processing abilities for all users who decide to download and just use the shell command. The ability to download and immediately start working with a really capable shell. Without risk of bringing malware from other downloads. Without the hassle of rebuilding it every time I need a new version. Without having to remember one or two years later upon returning to a stuff that need changes that there was a custom built sqlite shell there. Consistent across machines, because it was just downloaded from official download site. Yes, this is one of possible ways of thinking about consistency. I could reverse your deduction - why should I want the feature parity between sqlite embedded in an industrial device and sqlite running in Linux shell script that gathers data from such devices, processes them differently than the devices, aggregates them, compresses them and sends somewhere - that's beyond my ken. > I realize that consistency is the hobgobblin of little minds, but why > would one not want the same extensions available when compiling the > amalgamation into "some other" application but have that extension built > into the shell (which is merely yet another application)? > I will not comment on that one. It's not the level of discussion this mailing list expects. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
