[sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote: > > Many people do not "do" web forums. I am one of them. If there is not a > mailing list then it does not exist. I completely agree. I read and post to the SQLite mailing via Gmane, and I used to do the same for Fossil. Now that

Re: [sqlite] Create VIEW passing despite invalid column name specified

On Thursday, 26 Jul 2018 7:58 PM -0400, Richard Hipp wrote: > On 7/26/18, Tomasz Kot wrote: >> Hello, >> >> Beneath sql shall throw an error on CREATE VIEW statement (as invalid >> column is specified), but it passes (SQLite 3.23.1). > > The error is deferred until you try to use the view. The

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

ince it's fairly short, I include it here. --8<---cut here---start->8--- #!/bin/sh # Compare two SQLite3 databases. # If invoked under the name "tksql3diff", the diff is displayed graphically # using tkdiff to display the differences. # # Last mod

Re: [sqlite] Fixes to the transliteration table in ext/misc/spellfix.c

On Friday, 30 Mar 2018 11:38 AM -0400, Ian Zimmerman wrote: > On 2018-03-30 11:28, Marcin Ciura wrote: > >> { 0x0426, 0x54, 0x63, 0x00, 0x00 }, /* Ц to Tc */ >> { 0x0446, 0x74, 0x63, 0x00, 0x00 }, /* ц to tc */ >> >> This Cyrillic letter is usually transliterated as Ts. Unless "Tc" is >>

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

On Friday, 16 Mar 2018 11:37 AM -0400, 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? 0 -- Will ___ sqlite-users mailing list

Re: [sqlite] Why isn't my time formatting working?

On Wednesday, 8 Mar 2017 3:40 PM -0500, Paul Sanderson wrote: > The vast majority of dates I see in SQLite databases are unix epoch integer ^ > times (seconds since 1/1/1980) with unix milli seconds a close second. ^ > Efficient to store, sort and do date

[sqlite] warning on glob [was: SQLite3 Tutorial error]

On Friday, 6 Jan 2017 3:48 PM -0500, Keith Medcalf wrote: > > On Friday, 6 January, 2017 12:49, James K. Lowden > wrote: > >> On Fri, 6 Jan 2017 10:23:06 +1100 >> "dandl" wrote: >> >> > Unix globbing for Linux is defined here: >> >

[sqlite] using sqlite extensions within Ruby

I don't usually see questions about using SQLite3 from Ruby here, so I hope this is not out of place. Ruby is my normal programming language of choice nowadays, and I've been very happy with the sqlite3 ruby gem to use SQLite3 within my programs. I'd now like to make use of the SQLite3 session

[sqlite] Native sqlite4 on FreeBSD

On Friday, 11 Sep 2015 10:12 AM -0400, Valentin Davydov wrote: > On Thu, Sep 10, 2015 at 01:30:37PM +0200, Eduardo Morras wrote: >> >> Use gmake to compile. > > It didn't work either. Finally I've just installed some brand new linux > on a nearby virtual machine, made there make -f

[sqlite] design problem involving trigger

On Monday, 24 Aug 2015 2:46 AM -0400, Mark Lawrence wrote: >> It's theoretically possible, but in that case I would be content to >> force a difference in the title. It should be possible to have the >> following: >> >> 'History of Scotland' | -> 'A. Jones' >> 'History of Scotland' | -> 'T.

[sqlite] design problem involving trigger

On Saturday, 22 Aug 2015 1:05 PM -0400, R.Smith wrote: > > > On 2015-08-21 11:23 PM, Will Parsons wrote: >> On 21 Aug 2015, R.Smith wrote: >>> >>> On 2015-08-21 04:47 AM, Will Parsons wrote: >>>> I'm working on a program that involves a catalogue of b

[sqlite] design problem involving trigger

On 21 Aug 2015, Scott Robison wrote: > Another consideration: it is possible that two different anonymous books > are indeed different books. It is also possible a given "author" releases a > new rewritten book with the same name. I'm thinking of the Hardy Boys > series in particular from my

[sqlite] design problem involving trigger

On 21 Aug 2015, R.Smith wrote: > > > On 2015-08-21 04:47 AM, Will Parsons wrote: >> I'm working on a program that involves a catalogue of books. Part of >> the database schema looks like this: >> >> create table Books(id integer primary key, >>

[sqlite] design problem involving trigger

I'm working on a program that involves a catalogue of books. Part of the database schema looks like this: create table Books(id integer primary key, title text collate nocase not null, author references Authors(id), ...

Re: [sqlite] SQLite version 3.8.6 coming soon

Richard Hipp wrote: > On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden > wrote: > >> On Wed, 6 Aug 2014 07:40:43 -0400 >> Richard Hipp wrote: >> >> > > >> > > PS: backward compatibility, no s, no? >> > > >> > >> > A google search shows that you see it

Re: [sqlite] capturing and testing a hot journal

mm.w wrote: >> Can someone please get this a*h*l* banned? -- Will ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Useful - A Portable Class Library (PCL) for low-level (raw) access to SQLite

Thought some of you would find this useful ... https://github.com/ericsink/SQLitePCL.raw ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Embedded Javascript for User-defined Functions

Has anyone embedded a javascript engine (like http://duktape.org/) in sqlite or vice versa to allow creating user defined functions in javascript? Any pointers would be helpful ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to detect database change made by another application

I have two applications that access the same database and that can run at the same time. If changes are made to the database by one application, I would like the other application to update its display to reflect the change. The total_changes() function only works from a single connexion so

[sqlite] ordering doesn't work the way I expected

would have expected? Note that if I remove the unique constraint from column b it works as expected. -- William Parsons ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users