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
http://sqlite.org:8080/cgi-
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 wild.
--
D. Richard Hipp
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
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 SQLite4. Something close to
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 information schema:
ht
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
"
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 PRAG
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 fro
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
>
> db eval {select (2 > :x)
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
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 type
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 "
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. Changi
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 w
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.
sqlitestud
You got message
From: spe...@hotmail.com
Start
http://moppetadvisor.co.uk/newsletters/opatip.php
End
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit
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 motor : SQlite 3.7.1 = march
20th,
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 anyo
18 matches
Mail list logo