I haven't used SQLite for that yet (I will in the near future) but with mysql
my longes statement was at least several megabytes.
I create statements automatically. I think so far the longes created
statement was a PCA trafsformation from table with about 2000 columns
(would have been more if
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
We don't do it in SQLite but as an example of how large a legitimate SQL
statement can be, in a previous project we generated a pseudo-cube from the
current database in a single sql statement. Basically we wanted to
implement a fast complex search routine where users can choose any fields
from
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
This is one of my biggest and it is part of a number of queries to
transpose a table:
INSERT OR REPLACE INTO A3BP619_J(PATIENT_ID, ENTRY_ID_E1, START_DATE_E1,
ADDED_DATE_E1, SYST_E1, DIAST_E1, ENTRY_ID_E2, START_DATE_E2, ADDED_DATE_E2,
SYST_E2, DIAST_E2, ENTRY_ID_E3, START_DATE_E3, ADDED_DATE_E3,
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
7 matches
Mail list logo
