[sqlite] crashed

Hi all, crashed at winShmBarrier from sqlite free/sqlite mutex leave/sqlite page apis. application using database extensively on windows that time. any idea? Thanks, d b ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Tcl variable substitution issue

On Sun, Jan 26, 2014 at 7:06 PM, Donald Allen wrote: > my approach will be to use a language > better matched to sqlite, > You should do what you want, of course. But this statement is surprising since SQLite is really just a TCL extension that has "escaped" into the

Re: [sqlite] Tcl variable substitution issue

Richard Hipp wrote: This statement sets x to the string value "1", not the numeric value 1. Try instead: set x [expr 1] My response: In my actual program, not the cut-down example I gave, I set an amount to be inserted into a numeric field the same way as I did in my example, with a simple

Re: [sqlite] pragmas in subselects?

On 26 Jan 2014, at 10:32pm, Petite Abeille wrote: > What SQLite would really benefit from is a proper, consistent, queryable data > dictionary such as the the standard information schema: > > http://en.wikipedia.org/wiki/Information_schema I would like that for in

Re: [sqlite] pragmas in subselects?

On Jan 26, 2014, at 11:19 PM, big stone wrote: > ==> Is it the reason ? Well, that pragmas are not directly queryable from SQL just add insult to injury. What SQLite would really benefit from is a proper, consistent, queryable data dictionary such as the the standard

Re: [sqlite] pragmas in subselects?

There is a non-logicality of having "pragma table_info(my_table)" : - answering like a select, - but being not usable as a "select", nor queriable by a "select". Other databases seem more logical on this practical matter. Multi-motor tools, like dbeaver, have currently much less good support of

Re: [sqlite] pragmas in subselects?

Chapter 10 of Using SQLite covers virtual tables. One of the examples given shows how to wrap a PRAGMA statement, so it can be used as system catalog and used in normal SELECT statements. It would be pretty easy to expand the given example to cover almost any SQL statement (including any

Re: [sqlite] pragmas in subselects?

On 26-01-2014 17:09, Stephan Beal wrote: Hi, all, is there a syntactical construct which will allow me to use a pragma in a subselect? e.g. i'm trying to do... sqlite> pragma table_info(vfile); cid|name|type|notnull|dflt_value|pk 0|id|INTEGER|0||1 1|vid|INTEGER|0||0 ... sqlite> select name

Re: [sqlite] Tcl variable substitution issue

On Sun, Jan 26, 2014 at 10:37 AM, Donald Allen wrote: > This script > > #!/usr/bin/env tclsh > > package require sqlite3 > > set x 1 > This statement sets x to the string value "1", not the numeric value 1. Try instead: set x [expr 1] > > sqlite3 db /tmp/foo > >

Re: [sqlite] pragmas in subselects?

On Jan 26, 2014, at 5:09 PM, Stephan Beal wrote: > Is this possible? Sadly, no. Much of a PITA. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Tcl variable substitution issue

There's a several-year-old discussion of this issue here: http://wiki.tcl.tk/19627 It looks like 'impedance mis-match' is an appropriate term for this and that the tcl/sqlite type relationship is problematic, due to the typelessness of tcl and the omission in the api of a way to indicate the

[sqlite] pragmas in subselects?

Hi, all, is there a syntactical construct which will allow me to use a pragma in a subselect? e.g. i'm trying to do... sqlite> pragma table_info(vfile); cid|name|type|notnull|dflt_value|pk 0|id|INTEGER|0||1 1|vid|INTEGER|0||0 ... sqlite> select name from (pragma table_info(vfile)); Error: near

[sqlite] Tcl variable substitution issue

This script #!/usr/bin/env tclsh package require sqlite3 set x 1 sqlite3 db /tmp/foo db eval {select (2 > :x) as foo} { puts "foo was $foo" } run on an up-to-date Arch Linux system produces foo was 0 obviously incorrect. There seems to be an issue with variable substitution here.

Re: [sqlite] Query executes in sqlite manager but not sqlite database in android

Features are not available before they are introduced. For example, CTE's will not work with 3.6.22. The "ignore cruft from brain-dead SQL code generators" feature was not added to the parser until after 3.6.22. select * from A JOIN B ON a = b is mere syntactic sugar for select * from A,B

Re: [sqlite] Graphic SQLite Client Tool

Hi Again, Is there a longtime user of "http://sqlitestudio.pl; here that could write about his user experience ? ==> It looks a much simpler tool than dbeaver (no java ! no painfull installations on 40 old PCs !) ==> I would like to know if it is stable to rely on it for a classroom.

[sqlite] Some intresting from speco_

You got message From: spe...@hotmail.com Start http://moppetadvisor.co.uk/newsletters/opatip.php End ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Query executes in sqlite manager but not sqlite database in android

Hello I have used  #sqlite3 --version at command line and got 3.6.22 as the version Does that mean the type of query i am trying wont work? On Sunday, January 26, 2014 8:57 AM, big stone [via SQLite] wrote: It seems Android use a pretty outdated

[sqlite] Graphic SQLite Client Tool

Hello sqlite-users, I'm looking for a Graphic SQLite Client Tool to equip a classroom of old windows PC. So far, the best option I found is : - dbeaver 2.3.6 (multi-motors : SQLite, Mysql, Postgresql) - with the latest Xerial driver sqlite-jdbc4-3.8.2-SNAPSHOT.jar (with SQLite3.8.2) Has