On 28 Jul 2010, at 6:56am, Roger Binns wrote:
This works:
create table ( );
The obfuscated SQLite contest closed three months ago.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Tuesday, July 27, 2010 6:43 PM, Richard Hipp wrote:
[ ... ]
However, I have also attached journaltest2.log which I think does
demonstrate the memory leak. Having trawled through the full log file,
it
seems that the memory leak is coming from the FTS3 tests, so the
journaltest2.log
It seems apparent from the docs (and the function headers) that there is no way
to cause Sqlite's Virtual Table xUpdate function to notify the implementation
of the exact fields that were altered.
For example, if I do
UPDATE people SET age=40 WHERE name='jim'
then it would be great if the
On Fri, Jul 23, 2010 at 5:11 AM, Taras Glek tg...@mozilla.com wrote:
Hello,
Recently I spent some time investigating sqlite IO patterns in Mozilla.
Two issues came up: keeping sqlite files from getting fragmented and
fixing fragmented sqlite files.
Funny, that's why I like reading
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2010 07:37 AM, Ben Harper wrote:
then it would be great if the xUpdate function could inform one that only the
field 'age' is being altered. As it is now, every field is fed to xUpdate,
causing a circumventable read/verify/write burden
I have a large deployment of thousands of SQLite databases accessed
from the same multi-threaded process, and up until recently, I didn't
even consider thread safety, because
1) I only ever talk to a SQLite database connection from one thread at
a time, and
2) I am dumb.
I do maintain SQLite
Thanks for the clarity. I can live with it.
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On
Behalf Of Roger Binns [rog...@rogerbinns.com]
Sent: Wednesday, July 28, 2010 6:29 PM
To: General Discussion of SQLite Database
Subject:
Suppose that I have a table of 4 columns.
S R1 R2 T
s1r1 r2 t1
s1r1 r2 t2
s2r3 r4 t5
s2r5 r4 t6
s3r6 r7 t7
s3r6
I'm not sure what do you want to return for the case like this:
s1r1 r2 t1
s1r1 r2 t2
s1r1 r3 t2
But for your initial request the following query will be good:
select t1.*
from table_name t1,
(select s, count(*) cnt
Hello,
It seems that Composite Foreign Key constraint fails when it should not. For
example:
PRAGMA foreign_keys=ON;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER);
CREATE UNIQUE INDEX i1 ON t1(a,b);
INSERT INTO t1 VALUES(100,200);
CREATE TABLE t2(w INTEGER,x INTEGER,y
Peng Yu pengyu...@gmail.com wrote:
Suppose that I have a table of 4 columns.
S R1 R2 T
s1r1 r2 t1
s1r1 r2 t2
s2r3 r4 t5
s2r5 r4 t6
s3
On Tue, 27 Jul 2010 22:56:23 -0700, Roger Binns
rog...@rogerbinns.com wrote:
You can if you quote it. Note use double quotes to quote table column
names, single quotes for strings. You can also quote names using square
brackets - eg [table name].
Thanks Roger for the tip.
I have two tables, one with bank accounts, one which holds groupings of those
accounts, as follows:
Table Accounts
aName
aBalance
Table GroupMembers
gName
aName
What SQL query would total the account balances (aBalance) for all the
accounts (aName) associated with each group (gName)? Each
zipforbrains jtdavid...@gmail.com wrote:
I have two tables, one with bank accounts, one which holds groupings of those
accounts, as follows:
Table Accounts
aName
aBalance
Table GroupMembers
gName
aName
What SQL query would total the account balances (aBalance) for all the
accounts
Brilliant. Thanks a million. It's moments like these when I love the
internet.
Igor Tandetnik wrote:
zipforbrains jtdavid...@gmail.com wrote:
I have two tables, one with bank accounts, one which holds groupings of
those
accounts, as follows:
Table Accounts
aName
aBalance
Table
15 matches
Mail list logo