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 used in
real programs.
Big can
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 in
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
@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 can be defined
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
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 handed to SQLite get to be. I'm
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 the
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