[sqlite] The Simplest SQLite Common Table Expression Tutorial

2015-09-28 Thread Gert Van Assche
You're a great teacher, David. Thanks for sharing this! gert 2015-09-25 22:17 GMT+02:00 David Barrett : > Hey all, just wanted to share this in case anybody is also looking for a > very simple tutorial for CTE's in sqlite: > > >

[sqlite] The Simplest SQLite Common Table Expression Tutorial

2015-09-28 Thread Swithun Crowe
Hello DB> Hey all, just wanted to share this in case anybody is also looking for DB> a very simple tutorial for CTE's in sqlite: DB> http://blog.expensify.com/2015/09/25/the-simplest-sqlite-common-table-expression-tutorial/ Yes, that was a great introduction to recursive SQL. Last week I wrote

[sqlite] SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE

2015-09-28 Thread Florian Weimer
Relatively rarely, while starting a transaction on a concurrently modified SQLite database in WAL mode, I get a SQLITE_BUSY_SNAPSHOT error for just-prepared "BEGIN IMMEDIATE" statement. When I look at the list of statements with sqlite3_stmt_next, I cannot find any busy statement. Is it possible

[sqlite] Query containing correlated subquery gets "stuck"

2015-09-28 Thread gunnar
Hi Clemens et all, I found no difference when executing the query while inserting and not inserting records at the same time. For one of the identical databases the query still doesn't return. But I think the reason is in the correlated subquery together with how the database is filled

[sqlite] The Simplest SQLite Common Table Expression Tutorial

2015-09-28 Thread Drago, William @ CSG - NARDA-MITEQ
David, Thank you for sharing that. I found it very helpful. Regards, -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] Creating a stable database

2015-09-28 Thread Aaron Digulla
Am Montag, 28. September 2015 15:55 CEST, "R.Smith" schrieb: > > > On 2015-09-28 11:30 AM, Aaron Digulla wrote: > > > > Am Freitag, 25. September 2015 20:46 CEST, Warren Young > etr-usa.com> schrieb: > > > >> > >> That suggests a good test for Aaron, then: > >> > >> sqlite3

[sqlite] Creating a stable database

2015-09-28 Thread R.Smith
On 2015-09-28 11:30 AM, Aaron Digulla wrote: > > Am Freitag, 25. September 2015 20:46 CEST, Warren Young > schrieb: > >> >> That suggests a good test for Aaron, then: >> >> sqlite3 my.db .dump > dump.sql >> sqlite3 a.db < dump.sql >> sqlite3 b.db < dump.sql > Thank you

[sqlite] Creating a stable database

2015-09-28 Thread Simon Slavin
On 28 Sep 2015, at 10:30am, Aaron Digulla wrote: > That leaves me with a bug in my code or some really odd behavior because of > the Java VM. That's a nice bit of detective work. Is there anyone on the Java VM team you can contact and explain the bug to ? Simon.

[sqlite] Creating a stable database

2015-09-28 Thread Aaron Digulla
Am Freitag, 25. September 2015 20:46 CEST, Warren Young schrieb: > On Sep 25, 2015, at 11:59 AM, Richard Hipp wrote: > > > > On 9/25/15, Aaron Digulla wrote: > >> > >> I was wondering if it was possible to create the same database (= no binary > >> difference) twice with sqlite. > > > >