[sqlite] Text file import by column number

2013-10-25 Thread Joe.Fisher
Is it possible to import data by column number without using any delimiters? We have massive text based data files where each record of the data is segmented and consistent (Col 1-3, 4-9, 10-12, etc.). I've never had experience importing without some delimiter. Joe Fisher Oregon State Univer

Re: [sqlite] Break on cumulative sum

2013-03-05 Thread Joe.Fisher
One of the reasons why we have to use PostgreSQL and/or Oracle is for the 'Window Functions' (AKA: Analytic Functions). We use SQLite all the time and love it but this one missing feature bites us. Could we get some advice from the SQLite core team on the feasibility of this? Could it be just a