Just to nitpick :
SQLite version 3.16.0 2016-11-04 19:09:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
sqlite> with recursive count_down(v) as (
...> select 5
...> union all
...> select n - 1 from count_down where n > 0
...> )
...> s
In that same JSON page, in 1. Overview the text mentions '12 of 14 SQL
functions' but the listing shows different numbers - 13 numbered items in
the first section, 2 in the second, numbered 1 - 15.
Should that be "twelve of the *fifteen* SQL functions" or "*thirteen* of
the *fifteen* SQL functio
If I missed i tin earlier posts, sorry. Is there any documentation on the
geopoly extension? With possible uses or examples?
John
On Thu, 29 Nov 2018 at 14:39, Richard Hipp wrote:
> On 11/29/18, Thomas Kurz wrote:
> > Could it be that the one angle is north-based, the other one east-based?
>
>
I know this is an older thread, but shouldn't that reference be on the ITEM
table ? So ...
CREATE TABLE ATTRIBUTES (
ITEM_ID INTEGER REFERENCES ITEM(ID) ON DELETE CASCADE,
KEY TEXT,
VALUE TEXT,
PRIMARY KEY (ITEM_ID,KEY)
) WITHOUT ROWID;
John G
On 11 September 2017 at
I agree - keep the list on email. Simple, convenient.
John Gillespie
On 22 November 2017 at 19:49, Niall O'Reilly wrote:
> On 21 Nov 2017, at 16:27, Drago, William @ CSG - NARDA-MITEQ wrote:
>
> > Please, not a forum. The email list is instant, dynamic, and convenient.
> I don't think checking
Fascinating article.
Thanks.
John Gillespie
On 4 December 2017 at 13:08, Simon Slavin wrote:
> Every so often someone asks on this list for Unicode to be handled
> properly. I did it myself. Then other people have to explain how hard
> this is. So here’s an article which, after introductory
If you don't have Tcl/Tk ... if you are using MacOS or Linux you already
have it.
On Windows you can download it from https://www.activestate.com/activetcl
John G
On 14 December 2017 at 12:19, advancenOO
wrote:
> Hello Richard,
>
> I hope to run some tests by myself and I thin
Keith
Looks like a good idea but I get :
sqlite> create view if not exists SysColumns
...> as
...> select ObjectType collate nocase,
...>ObjectName collate nocase,
...>ColumnID collate nocase,
...>ColumnName collate nocase,
...>Affinity collate noc
Thanks Warren. Sorry about that, I had an old version in /opt/local/bin.
John Gillespie
On 11 January 2018 at 15:24, Warren Young wrote:
> On Jan 11, 2018, at 5:47 AM, John G wrote:
> >
> > Is this because I am stuck with version 3.8.8.3 which is what MacOS
> Sierra
> &
I've not tried it, but this article from OSXdaily says you can get the
command line (Terminal) in iOS.
http://osxdaily.com/2018/01/08/get-terminal-app-ios-command-line/
That probably does not solve the fork requirement, and I'm sure it is
sandboxed.
John G
On 15 January 201
0
(Out of 3 databases. )
On 16 March 2018 at 15:37, Richard Hipp wrote:
> This is a survey, the results of which will help us to make SQLite faster.
>
> How many tables in your schema(s) use AUTOINCREMENT?
>
> I just need a single integer, the count of uses of the AUTOINCREMENT
> in your overal
I saw sqldiff mentioned and decided to try it (compiled from
sqlite-src-3090200) and got an SQL error.
./sqldiff: SQL statement error: near "1": syntax error
"SELECT B.rowid, 1, -- changed row
A.id IS NOT B.id, B.id,
A."desc" IS NOT B."desc", B."desc"
FROM main.A A, aux.A B
WHERE
WHERE rowid=3;
On 7 November 2015 at 18:37, Richard Hipp wrote:
> On 11/7/15, John G wrote:
> > I saw sqldiff mentioned and decided to try it (compiled from
> > sqlite-src-3090200) and got an SQL error.
> >
>
> Please try the latest trunk version
> (https://www.sq
On 13 September 2015 at 10:06, Domingo Alvarez Duarte <
sqlite-mail at dev.dadbiz.es> wrote:
> Hello !
>
> Due the way sqlite manages it's source code (with fossil-scm) I propose to
> anyone that has any extension/custom sqlite code fork this project on
> github:
>
>
> https://github.com/mackyle/s
1) Can't see the 'attachment' - this list does not accept them.
Can you copy/paste sample code into an email?
John G
On 31 August 2016 at 14:34, Maria de Jesus Philadelpho <
jesus.ph...@gmail.com> wrote:
> Hi,
>
> I implement the SQLite extension, virtcsv, which
I normally use the 3.8.8.3 supplied with MacOS El Capitan.
I downloaded version 3.15.1 from the Download page - precompiled
command-line tools : (sqlite-tools-osx-x86-3150100.zip).
When I tried copying and pasting multiple or multi-line statements from my
editor (jEdit) the command-line shell igno
Thanks, that worked.
John Gillespie
On 8 November 2016 at 14:30, Richard Hipp wrote:
> On 11/8/16, John G wrote:
> > I normally use the 3.8.8.3 supplied with MacOS El Capitan.
> > I downloaded version 3.15.1 from the Download page - precompiled
> > command-line tools :
Having used the Tcl interface to SQLite for 10+ years I was caught out when
accessing someone else's DB. I don't see a satisfactory way to fix it, but
a warning would help.
Example to illustrate:
sqlite3 dbcmd grbg.db
package require sqlite3
dbcmd eval {create table a (Xyz text)}
dbcmd eval {inse
PRAGMA foreign_keys=1 is transient, but it would be nice if it were
persistent.
John G
On 13 April 2017 at 12:35, Tony Papadimitriou wrote:
> -Original Message- From: no...@null.net
>
>> What would be useful (at least via the shell CLI) is a "list_pragmas"
&g
Dr Hipp
I second Kyan's suggestion of a pseudo-comment hinting syntax:
... that the planner hint is not interleaved inside normal SQL
> syntax. Instead I propose a special comment-like syntax instead, as
> Oracle's /*+ */ or --+, but replacing "+" with another symbol, e.g. ">":
>
Having had to s
I don't see the '.dbinfo' command in the shell in the version supplied
with MacOS X 10.10 (Yosemite) - 3.8.8.3.
Was this introduced after this.
I know Apple is a bit slow in updating, but I can't use a personally
compiled verion.
John G
On 5 May 2016 at 23:42, R Smith
Or without the added calories (syntactic sugar) :
select a.*, b.*
from author_books ab, author a, books b
where a.author_id = ab.author_id
and b.book_isbn = ab.book_isbn
On Tue, 27 Aug 2019 at 15:52, David Raymond
wrote:
> It does support natural joins. changes" comments here>
>
> USING n
error "too many fields"
}
}
}
dbcmd eval $SQL {
puts [format "Field %-15s on %-15s has the string %-15s: %s" $cn $tn
$searchstr $val]
}
Field t0c on table0 has the string plus : 2
plus 2 equals 4
Field t12 on table1
the next version of SQLite3.
John G
On Wed, 26 Feb 2020 at 19:09, Jean-Luc Hainaut
wrote:
> On 26/02/2020 12:18, Richard Hipp wrote:
> > On 2/26/20, Jean-Luc Hainaut wrote:
> >> Hi all,
> >>
> >> It seems that SQLite (version 31.1) accepts a trigger declara
24 matches
Mail list logo