condition with lots of columns.
- Original Message -
From: [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Date: Wed, 09 May 2007 23:32:53 +
Subject: [sqlite] Longest "real" SQL statement
> I'm looking for an upper bound on how big legitimate
> SQL statements hand
Hi Richard,
I tend to use a series of CREATE VIEW AS SELECT type statements to
effectively nest my SELECT statements, making them more humanly
editable and manageable. Consequently, the size of the maximum sized
single SQL statement is reduced, though the total SQL statement
effectively
@sqlite.org
Subject: [sqlite] Longest "real" SQL statement
I'm looking for an upper bound on how big legitimate
SQL statements handed to SQLite get to be. I'm not
interested in contrived examples. I want to see
really big SQL statements that are actually used in
real programs.
"Big&
Hi Richard,
Our longest select so far this one:
select * from log where ((aut not like '6%' and aut not like '-1%') or
(avm not like '6%' and avm not like '-1%') or (lam not like '6%' and lam
not like '-1%') or (pam not like '6%' and pam not like '-1%') or (pas
not like '6%' and pas not like
I am the author of the package SQLiteDF for R (a statistical package),
some sort of sqlite backed "data set". It's "raison d'etre" is to deal
with very large datasets, which could be tables with thousands of
columns. I am not much on the infinite length sql statement, but I
need lots of columns
y 2007 00:33
To: sqlite-users@sqlite.org
Subject: [sqlite] Longest "real" SQL statement
I'm looking for an upper bound on how big legitimate
SQL statements handed to SQLite get to be. I'm not
interested in contrived examples. I want to see
really big SQL statements that are actually
Dave Dyer <[EMAIL PROTECTED]> wrote:
> I've recently been storing images in Sqlite datbases, and
> for various reasons don't want to use the normal "blob"
> mechanisms. Consequently, a 10mb JPG image file would be
> encoded as slightly larger than 10mb sqlite "insert xx" command.
>
The use of
I'm looking for an upper bound on how big legitimate
SQL statements handed to SQLite get to be. I'm not
interested in contrived examples. I want to see
really big SQL statements that are actually used in
real programs.
"Big" can be defined in several ways:
* Number of bytes of text in
8 matches
Mail list logo
