Re: [sqlite] More built-in functions for basic math

We all know this but it bears repeating: At some point it's time to use a different database engine or offload to other code. Sqlite could easily burgeon to the size of the other databases if everything asked for was included. Where, then, would we get a small but still functional SQL engine?

Re: [sqlite] SQLite Bug Disclosure

Thank you, Dr. Hipp! On Sun, Jan 22, 2017 at 9:40 AM, Richard Hipp wrote: > Thanks for sending the bug report, Ian. Unfortuantely, the repro > script did not work for me. I think you sent the wrong file. > Nevertheless, I was able to track down and fix the problem based on >

Re: [sqlite] Query question: order by ascending, return the two largest values in ascending order

. Keith On Mon, Jul 11, 2016 at 11:12 PM, J Decker <d3c...@gmail.com> wrote: > SELECT DISTINCT date_time_stamp FROM general ORDER BY date_time_stamp DESC > LIMIT 2 > > isn't it simply to use DISTINCT? > > On Mon, Jul 11, 2016 at 4:25 PM, Keith Christian <keith1c

[sqlite] Query question: order by ascending, return the two largest values in ascending order

A table has a column of dates and times that look like this: 2015-10-02 07:55:02 2015-10-02 07:55:02 2015-10-02 10:00:03 2015-10-02 10:05:02 2015-10-02 10:10:02 Schema: CREATE TABLE general ( id integer primary key autoincrement, server text, date_time_stamp text); Would like to get the

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

On Tue, Nov 10, 2015 at 3:35 PM, Scott Robison wrote: > On Nov 10, 2015 2:19 PM, "John McKown" > wrote: >> >> On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian < > keith1christian at gmail.com> >> wrote: >> >> > A great thing for Wi

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

A great thing for Windows users. My only caveat is: Beware corporate pressure. Stay Free. On Tue, Nov 10, 2015 at 12:41 PM, Richard Hipp wrote: > http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/ > > -- > D. Richard Hipp > drh at sqlite.org >

[sqlite] Feedback request: JSON support in SQLite

Pardon me, but: At what point does the code required for the inclusion of a multitude of supported data formats exceed the core purpose of the executable? At some point, obtaining a desired output format (from the potentially dozens available) might be offloaded to a different executable that

Re: [sqlite] Is there a way to load a blob from the shell?

t;d...@sqlite.org> wrote: > On Mon, Apr 7, 2014 at 6:56 PM, Keith Christian > <keith1christ...@gmail.com>wrote: > >> >> However, on production *nix machines, the path to the SQLite 'sar' >> will probably have to be absolute, or else the native 'sar' (System

Re: [sqlite] Is there a way to load a blob from the shell?

Hi Richard, 'SAR' looks like a great utility! However, on production *nix machines, the path to the SQLite 'sar' will probably have to be absolute, or else the native 'sar' (System Activity Reporter) will run instead. Perhaps add a caveat to the docs for SQLite's 'sar?' Keith On Sun, Apr 6,

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

k down why the Makefile changes in 3.8.4 don't produce a sqlite3.exe file when compiling in the tea/ directory. Thanks for the new 3.8.4.1 for Cygwin. Keith On Tue, Mar 11, 2014 at 2:54 PM, Jan Nijtmans <jan.nijtm...@gmail.com> wrote: > 2014-03-11 17:45 GMT+01:00 Keith Chri

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

23 AM, Tim Streater <t...@clothears.org.uk> wrote: > On 11 Mar 2014 at 16:11, Keith Christian <keith1christ...@gmail.com> wrote: > >> The resulting file is quite large, almost 14 times the size of the >> sqlite3 version 3.8.3 packages with Cygwin: >> >> l

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .quit Keith On Tue, Mar 11, 2014 at 8:30 AM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian > <keith1christ...@gmail.com>wrote: >

[sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

A few days ago, I successfully compiled the previous version of the autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a sqlite3.exe file was produced on a Cygwin environment. This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked, ran 'make clean' and 'make', but no

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

OK Warren, you've helped greatly, thanks again for the assistance, will check other forums if the shared object / dll problems continue. Keith On Tue, May 14, 2013 at 10:53 AM, Warren Young <war...@etr-usa.com> wrote: > On 5/14/2013 09:14, Keith Christian wrote: > >> >

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

t 8:10 PM, Warren Young <war...@etr-usa.com> wrote: > On 5/13/2013 16:36, Keith Christian wrote: > >> gcc -o libtclsqlite3.so -shared tea/generic/tclsqlite3.c -lpthread -ldl >> -ltcl >> > > Don't build it that way. It appears that the TEA build system sees Cygwin &g

[sqlite] Compiling libtclsqlite3.so on Cygwin

I have the latest version of Cygwin installed (CYGWIN_NT-6.1-WOW64 1.7.18(0.263/5/3) 2013-04-19 10:39 i686 Cygwin) and the latest autoconf archive (sqlite-autoconf-3071602.tar.gz) because it had the required tclsqlite3.c file in order to build the libtclsqlite3.so shared object. I ran the

Re: [sqlite] Select statements using date function such as date('-1 day')

On Fri, Dec 28, 2012 at 12:26 PM, Igor Tandetnik wrote: > You forgot to tell date() function which date it's supposed to subtract one > day from. Make it date('now', '-1 day') Thanks, Igor, that fixes the problem, both of these work! select * from general where

[sqlite] Select statements using date function such as date('-1 day')

Running SQLite version 3.7.13 2012-06-11 02:05:22. A table has a date field with entries in this range: 2012-10-25 through 2012-12-27. 2735080|2012-12-27 2735081|2012-12-27 2735083|2012-12-27 2735084|2012-12-27 2735085|2012-12-27 2735086|2012-12-27 2735087|2012-12-27 2735088|2012-12-27

Re: [sqlite] sqlite3_analyzer

Richard, thank you for the details of the compilation instructions. I'll give that a try. Keith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_analyzer

I found the links mentioned above at the bottom of the Downloads page, and went to this site: http://www2.sqlite.org/cgi/src I logged in to the SQLite timeline using anonymous and a random password as instructed. Once there, I downloaded SQLite-256cdbdc810cae23.tar.gz, 3.8 mb in size. After

Re: [sqlite] Widen output of file field for .databases CLI command

On Thu, Aug 25, 2011 at 6:47 PM, Clark Christensen wrote: > Hi Keith, > > How about > > pragma database_list; > >  -Clark I'll try it! Thanks! Keith ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Widen output of file field for .databases CLI command

Is there a parameter that will widen the "file" column when ".databases" is typed at the sqlite> prompt? Occasionally the database is several directories deep and the filename is lost or truncated if the complete path is more than 58 characters wide. If no parameter exists, could the "file"

Re: [sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

On Fri, Jun 3, 2011 at 3:01 PM, Simon Slavin wrote: > However, there are ways to do many things the dot commands do.  For instance, > > http://www.sqlite.org/pragma.html#pragma_database_list Got it, Simon, this works: set dblist [db1 eval {pragma database_list;}] puts

Re: [sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

On Fri, Jun 3, 2011 at 2:42 PM, Simon Slavin wrote: > Use the form > > CREATE TABLE IF NOT EXISTS ... > > http://www.sqlite.org/lang_createtable.html Thank you, Simon. I have another question about the TCL interface: What is the syntax to execute the commands available

[sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

I've successfully compiled libtclslqite3.so on CentOS 5.5 Linux and have run the example sqlite3 code from http://www.sqlite.org/tclsqlite.html. The TCL script below is almost verbatim from the above web page's examples. Problem - After the first pass, it obviously attempts to CREATE TABLE

[sqlite] Can't download the gzip archives from the list info page

Hello Sqlite List, Clicking a Gzip'd Text xxxKB link on the archives page (http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users) displays a page with this message: No such list 2011-june.txt.gz What is the procedure to obtain the list archives? Thanks. ==Keith