Re: [sqlite] Trigger name missing

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 declaration in > &

Re: [sqlite] Can I search all tables and columns of SQLite database for a specific text string?

archstr $val] } Field t0c on table0 has the string plus : 2 plus 2 equals 4 Field t12 on table1 has the string plus : 1 plus 1 equals 2 John G On Thu, 13 Feb 2020 at 15:24, Jose Isaias Cabrera wrote: > > Scott, on Thursday, Febru

Re: [sqlite] Query for Many to Many

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

Re: [sqlite] function named geopolyCosine is a misnomer

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? >

Re: [sqlite] Docs typo JSON1 @ 4.13

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

Re: [sqlite] Recursive references in subqueries

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 ...> ) ...>

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

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

Re: [sqlite] Can an SQL script be built from within sqlite?

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 2018 at 15:00

Re: [sqlite] sqlite3_column_decltype and max and min

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 <war...@etr-usa.com> wrote: > On Jan 11, 2018, at 5:47 AM, John G <rjkgilles...@gmail.com> wrote: > > > > Is this because I am stuck

Re: [sqlite] sqlite3_column_decltype and max and min

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

Re: [sqlite] Does sqlite have official development testing tool?

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 <haveagoodtime2...@gmail.com> wrote: > Hello Richard, > > I hope to

Re: [sqlite] Why Unicode is difficult

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

Re: [sqlite] Many ML emails going to GMail's SPAM

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. >

Re: [sqlite] Need help with SQL query

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 13:11

Re: [sqlite] Which pragmas are persistent?

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 <to...@acm.org> wrote: > -Original Message- From: no...@null.net > >> What would be useful (at least via the shell CLI) is a "

[sqlite] Tcl Interface - minor docs suggestion

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

Re: [sqlite] Command line not accepting multi-line statements.

Thanks, that worked. John Gillespie On 8 November 2016 at 14:30, Richard Hipp <d...@sqlite.org> wrote: > On 11/8/16, John G <rjkgilles...@gmail.com> wrote: > > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > > I downloaded version 3.15.1 from the

[sqlite] Command line not accepting multi-line statements.

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

Re: [sqlite] Virtual table

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 allows attachi

Re: [sqlite] Version of the database

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 <rsm...@rsweb.co

[sqlite] Problem with sqldiff

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.sqlite.org/src/artifact/37a

[sqlite] Problem with sqldiff

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

[sqlite] Fwd: OT: Oracle functions for SQlite

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: > > >

Re: [sqlite] Hints for the query planner

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