[sqlite] Version 3.13.0 coming soon

On Tue May 03, 2016 at 08:33:30AM -0400, Richard Hipp wrote: > On 5/2/16, Rolf Ade wrote: > > > > Richard Hipp writes: > >> A change summary for 3.13.0 is at > >> https://www.sqlite.org/draft/releaselog/3_13_0.html > > > > Change the temporary directory search algorithm on Unix to allow > >

[sqlite] FOREIGN KEY constraint failed

On Tue Apr 05, 2016 at 11:56:53PM +0200, R Smith wrote: > > On 2016/04/05 11:15 PM, Keith Medcalf wrote: > >Are we confusing immediate constraints (checked per statement) with > >DEFERRED constraints (checked at COMMIT time) again? > > > > We might be - though I assume the OP implicated only defe

[sqlite] EXPLAIN QUERY PLAN for non-SELECT statements?

I wanted to see how SELECT queries within triggers are using indexes (or not) which of course lead me to https://www.sqlite.org/eqp.html: EXPLAIN QUERY PLAN is most useful on a SELECT statement, but may also be appear with other statements that read data from database tables (e.g. UPDA

[sqlite] MIN/MAX query

On Wed Feb 17, 2016 at 06:17:40PM +, David Bicking wrote: > I have a table > I? L? V1 1?? A1 2?? A1 3?? A1 4?? B1 5 ? B1 6?? A1 7?? A2 1 ? C2 2?? C The formatting of this (and your desired results) does not make the question clear enough. Can you resend with each row on a separate line and p

[sqlite] FOREIGN KEY enhancement request

On Wed Nov 25, 2015 at 10:45:07AM +, Simon Slavin wrote: > > REFERENCES foreign-table ( column-name [[, column-name]]) ... > > It would be useful if rather than having to specify a column name for > each item one could specify a fixed value (or perhaps an expression, > though that might be mo

[sqlite] Database sybchronisation

On Thu Aug 13, 2015 at 10:06:44AM +0200, Dominique Devienne wrote: > > The new RBU [1] extension, coupled with the new sqldiff utility, > might be of interest too.--DD > > [1] http://www.sqlite.org/rbu.html Is there a table of contents or index of SQLite extensions somewhere on the main website?

[sqlite] Patch that add ".dumpdata" command to shell.c

> This command should behave exactly like ".dump" but without the > database schema. I would occasionally find that command useful. > Here is a small patch that adds ".dumpdata" for "shell.c" in sqlite3. This mailing list does not accept attachments. Perhaps you can post a link? -- Mark La

[sqlite] Contstant WHERE terms still require table scan?

On Fri Jun 12, 2015 at 09:49:29AM +, Hick Gunter wrote: > Seems the correct code is already generated... Thanks Hick, that shows a bit more detail I didn't think to look for. It seems that this only works for bind values, as the comparison and goto statements aren't present when the term is de

[sqlite] Contstant WHERE terms still require table scan?

> This would potentially allow me to shortcut some largish UNION > statements. I should clarify: I don't want to have to force my callers to use their own if/then/else statements in order to pick a specific query. I want a single general-purpose query they can call that shortcuts based on a bind v