Re: [sqlite] .import error: cannot open large file

Hi, Often I pipe tables (from .gz or multiple files). I found it also work for large files that otherwise fail with `Error: cannot open :huge.file"`: cat huge.file | sqlite3 somedb '.import /dev/stdin hugetable' But it could be slower that using `real` file import. Anyone have an idea? L.

Re: [sqlite] SQLite ADO.NET for .Net Compact Framework 3.9

Paolo Patierno wrote: > > I want to compile SQLite managed code for .Net Compact Framework 3.9 (to > run on Windows Embedded Compact 2013). What is the better way to do this ? > If you have the Windows Embedded Compact 2013 SDK installed, you may be able to import the Visual Studio 2008 project

Re: [sqlite] Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies on Windows XP. Ideas?

My recollection is that in your first message (to which I replied [to this list] that your one crashing user might have been someone using 32-bit Windows; almost all XP installs are 32-bit) you said that you had built things 64-bit. You cannot deploy a 64-bit build on 32-bit Windows XP and

Re: [sqlite] Simple string question

Suppose I have a table with one text column. I insert like this: INSERT INTO my_table (col1) VALUES ('arbitrary UTF-8 string'); * Isn't it true that the string must indeed be surrounded by single quotes as I do above? * Isn't it true that I have to replace all occurrences of ' in the

Re: [sqlite] GROUP BY

Yeah, something like SELECT order_id,issued,reference, company, department_id, SUM(quantity) AS quantity, SUM(dispatch) AS dispatch, SUM(surplus) AS surplus FROM orders_surplus GROUP BY order_id I have however to sum quantity, dispatch and surplus fields to force the view to calculate the

Re: [sqlite] Foreign key vs index (continue)

On 11/13/2013 11:14 PM, Igor Korot wrote: But then in order to speed up this query I need to create an index leaguescorehitter(scoreid), right? I don't know. My crystal ball is cloudy lately, I can't quite make out your database schema from here. -- Igor Tandetnik

Re: [sqlite] Simple string question

On 14 Nov 2013, at 12:58pm, L. Wood wrote: > Suppose I have a table with one text column. I insert like this: > > INSERT INTO my_table (col1) VALUES ('arbitrary UTF-8 string'); > > * Isn't it true that the string must indeed be surrounded by single quotes as > I do above? >

Re: [sqlite] GROUP BY

How to query and/or group complex SQL? Add the language to create a SQL VIEW before your SELECT statement: CREATE VIEW viewname AS SELECT [your SQL] http://www.sqlite.org/lang_createview.html Then use the viewname in a second SELECT statement as you would a table. SELECT order_id, issued,

[sqlite] SQLite ADO.NET for .Net Compact Framework 3.9

Hi, I want to compile SQLite managed code for .Net Compact Framework 3.9 (to run on Windows Embedded Compact 2013). What is the better way to do this ? Paolo. -- *Ing. Paolo Patierno* *Software Engineer / Software Embedded Engineer* Blogs on* DotNetCampania, TinyCLR & Embedded101*

Re: [sqlite] Simple string question

On Thu, Nov 14, 2013 at 2:14 PM, Richard Hipp wrote: > On Thu, Nov 14, 2013 at 7:58 AM, L. Wood wrote: > > > Suppose I have a table with one text column. I insert like this: > > > > INSERT INTO my_table (col1) VALUES ('arbitrary UTF-8 string'); > > > > * Isn't

Re: [sqlite] Simple string question

On Thu, Nov 14, 2013 at 7:58 AM, L. Wood wrote: > Suppose I have a table with one text column. I insert like this: > > INSERT INTO my_table (col1) VALUES ('arbitrary UTF-8 string'); > > * Isn't it true that the string must indeed be surrounded by single quotes > as I do above?

[sqlite] Simple string question

Suppose I have a table with one text column. I insert like this: INSERT INTO my_table (col1) VALUES ('arbitrary UTF-8 string'); * Isn't it true that the string must indeed be surrounded by single quotes as I do above? * Isn't it true that I have to replace all occurrences of ' in the original

Re: [sqlite] Enable WAL on a QNX system

On Thu, Nov 14, 2013 at 4:42 AM, Sandu Buraga wrote: > I am starting to believe that WAL is not a viable choice on a QNX system. > All Blackberry phones and tables use it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] GROUP BY

HI clemens I've resolve with SELECT order_id,issued,reference, company, dep_id, SUM(qty) AS quantity, SUM(dispatch) AS dispatch, SUM(surplus) AS surplus FROM( SELECT orders.order_id AS order_id, orders.reference AS reference, strftime('%d-%m-%Y', orders.issued) AS issued,

Re: [sqlite] GROUP BY

Giuseppe Costanzi wrote: > order_idissuedcompany dep_id qty,dispatch surplus > "1""12-11-2013" "Siemens" "1" "6""4""2" > "1""12-11-2013" "Siemens" "1" "2""2""0" > "2""13-11-2013" "Siemens" "2" "10" "10"

Re: [sqlite] Enable WAL on a QNX system

For a QNX system Richard suggested to set locking mode EXCLUSIVE before trying to set the WAL journal mode. When PRAGMA main.journal_mode=WAL is executed, the sqlite code checks whether EXCLUSIVE lock is enabled, or if shared memory is supported. The shared-memory implementation from sqlite is

Re: [sqlite] What takes the most time

On Wed, Nov 13, 2013 at 11:50 PM, David de Regt wrote: > If a single _step() call takes a long time to execute (a few minutes), is my > only option to just wait for it? Does SQLite not allow any kind of callback > mechanism for each _step() to indicate how many percentages