Re: [sqlite] INSERT INTO ???

2013-09-20 Thread Bernhard Amann
> > INSERT INTO SELECT * FROM ; > > However, this only works if already exists, which is actually > quite cumbersome.. > Is there a way to make the new table 'on the fly"? create table newtable as select * from oldtable; Bernhard ___ sqlite-users

[sqlite] INSERT INTO ???

2013-09-20 Thread B.W.H. van Beest
Hi folks, I would like to query a table and put the result in a new table, as in INSERT INTO SELECT * FROM ; However, this only works if already exists, which is actually quite cumbersome.. Is there a way to make the new table 'on the fly"? Regards, Bertwim

Re: [sqlite] Regression: Query takes 10x longer when using version 3.8.x

2013-09-20 Thread Simon Slavin
On 21 Sep 2013, at 12:14am, Jared Albers wrote: > I was unsure if the rowid of a subquery even existed until I selected it. I > reviewed the output and determined that it was what I expected of a rowid > from a subquery (simply an auto-incremented int of the result set

Re: [sqlite] Regression: Query takes 10x longer when using version 3.8.x

2013-09-20 Thread Jared Albers
>After laboriously translating your schema and query into something >readable, I get script shown below. Apologies. I assumed you planned on recreating the database and that readability wouldn't be an issue. >We (all SQLite developers have been consulted and agree) conclude that the >result of

Re: [sqlite] Any tool to create erd from sqlite database?

2013-09-20 Thread gwenn
Hello, There is a minimalist one here: https://github.com/gwenn/sqliterd It depends on c/go compilers and the graphviz dot command... Regards. On Fri, Sep 20, 2013 at 2:26 PM, Jason H wrote: > Don't forget about ODBC tools... Just use ta SQLite ODBC driver... > > >

Re: [sqlite] racing with date('now') (was: Select with dates)

2013-09-20 Thread Richard Hipp
On Fri, Sep 20, 2013 at 9:23 AM, Keith Medcalf wrote: > > Nice fix Richard, and it works as you have documented. > > With the added [cebd6fc551] to reset iCurrentTime when the statement is > reset, my testing indicates that if the p->iCurrentTime=0; added at line > 570 of

Re: [sqlite] racing with date('now') (was: Select with dates)

2013-09-20 Thread Keith Medcalf
Nice fix Richard, and it works as you have documented. With the added [cebd6fc551] to reset iCurrentTime when the statement is reset, my testing indicates that if the p->iCurrentTime=0; added at line 570 of vdbe.c by the original patch [daf6ba413c] (change fragment [56e648f5ba9a9181]) is

Re: [sqlite] Any tool to create erd from sqlite database?

2013-09-20 Thread Jason H
Don't forget about ODBC tools... Just use ta SQLite ODBC driver... From: dd To: General Discussion of SQLite Database Sent: Friday, September 20, 2013 8:11 AM Subject: [sqlite] Any tool to create erd from sqlite

[sqlite] Any tool to create erd from sqlite database?

2013-09-20 Thread dd
I am looking for tool which generates er diagrams from existing database. Any suggetions? Thanks in advance. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] COMMIT or ROLLBACK failure

2013-09-20 Thread Clemens Ladisch
Igor Korot wrote: > I need to check if the COMMIT is successful. > But what should I do if it fails? If the database is currently locked, you should try again later. (But this would be better handled with a busy handler.) If there is some I/O error that prevents you from writing, the COMMIT