SQLite database Recent threads

Threads	Replies	First post	Last post
What does "The use of the amalgamation is recommended for all applications." mean, precise By: Sidney Cadot Dear all, On the support page http://www.sqlite.org/howtocompile.html, it says: "The use of the amalgamation is recommended for all applications." Is this a general recommendation, to use the amalgamated source file as the preferred way of…	15	May 24 2012 10:44	May 25 2012 07:45
SQLite SELECT performance problem By: Nick Hello! I have a program that does some math in an SQL query. There are hundreds of thousands rows (some device measurements) in an SQLite table, and using this query, the application breaks these measurements into groups of, for example, 10000…	13	May 24 2012 14:59	May 25 2012 07:23
How to write and read the same sqlite3 DB in memory concurrently in two thread? By: 吴毅 Now I am writing datas to sqlite3 DB in memory(":memory:") in a thread . And concurrently I want to read the datas of the same DB in memory too. but While i used the same object of sqlite3 to write and read, i had got the error:SQLITE_MISUSE. If i…	0	May 25 2012 07:16	May 25 2012 07:16
Re: Update Query By: IQuant Thanks for your suggestion Igor Tandetnik: Scope creep expanded the original query to the actual trading instruments and the refactored code has evolved to:: update TICKDATA set IQ_A = ROUND(ASK - ( select t2.ASK from TICKDATA t2 where…	2	May 24 2012 21:04	May 24 2012 22:39
Advice on the proper use of sqlite3 - Database Connection Handle By: Andrew Cherednik Hi, I have converted a legacy program that has used a Microsoft Jet (Access) database. The program is written in Visual C++. It is an client-server MFC application that used OLE-DB interfaces to directly connect to the database. I have managed to…	19	May 24 2012 19:56	May 24 2012 21:30
ADO.NET Provider, targeting any cpu By: Damien Hi, I don't know if question has already been asked, and i appologize if it is the case... For the SQLite ADO.NET provider, there are precompiled binaries for both x86 and x64. Is there a way to have an assembly targeting "any cpu", that chooses…	6	May 23 2012 04:01	May 24 2012 14:07
GROUP BY question By: Mike King Is this Select statement valid? In Oracle, it wouldn't be because what is the aggregate of A. Is this behavior defined anywhere? create table T (A,B); insert into T (A,B) values (1,3); insert into T (A,B) values (2,3); select A,B from T group…	4	May 24 2012 12:22	May 24 2012 12:55
(no subject) By: IQuant How can I construct a update query to calculate and set a record field "latency" with the difference between "timestamps" by "deviceid"? Appears sqlite doesn't support lag and lead. ie. I have a table with 1,000,000 + records collecting real time…	1	May 24 2012 10:46	May 24 2012 11:52
Possible memory leaks on sqlite3_close By: Alfred Sawaya Hello, SQLite version 3.7.9 2011-11-01 00:52:41 Valgrind reports some memory leaks : ==9709== HEAP SUMMARY: ==9709== in use at exit: 94,248 bytes in 42 blocks ==9709== total heap usage: 1,338 allocs, 1,296 frees, 1,066,595 bytes allocated…	1	May 24 2012 07:34	May 24 2012 10:10
SQLite reading old data By: Fabrizio Steiner Hello I'm currently facing a problem with the System.Data.SQLite ADO.NET Provider. I'm using stamps (simple integer column) on the rows in order to detect if another user has altered the same datarow during the time the first user started the edit…	7	Dec 15 2011 06:59	May 24 2012 02:42
ICU extension not working as expected By: Courtney Grimland I've downloaded and compiled icu.c according to the instructions in the included README (though I had to add -fPIC to the compiler options). Now, when searching a table, I'm not getting the kind of diacritic-insensitive behavior I was expecting:…	4	May 23 2012 13:11	May 23 2012 17:13
Feature Request: Change busy error message By: Shaun Seckman (Firaxis) The two errors SQLITE_BUSY and SQLITE_LOCKED are very similar but also very different. SQLITE_LOCKED implies that the contention is on the same connection whereas SQLITE_BUSY implies that the contention is from another connection and can be…	5	May 23 2012 11:40	May 23 2012 13:55
Serialized + Prepared Statement Clarification By: Sander Jansen Hi, I was always under the impression that prepared statements can only be used from one thread at a time, so if 2 threads need to perform the same query independently, you need to have a prepared statement for each thread. Now I came across the…	2	May 23 2012 12:52	May 23 2012 13:08
Re: sqlite-users Digest, Vol 53, Issue 22 By: Peter Haworth Thanks Donald. I have a utility that imports csv files to sqlite so just trying to get a handle on what I need to deal with! Pete lcSQL Software <http://www.lcsql.com> On Wed, May 23, 2012 at 9:00 AM,…	0	May 23 2012 11:23	May 23 2012 11:23
sqlite3_analyzer failing for large files By: Demper Delic When trying to analyze a 3.5 GB database file (which passes PRAGMA integrity_check) using the Windows analyzer provided in the download page, it fails immediately with an "Empty or malformed database: db.sqlite" error message. It works on some…	1	May 23 2012 07:11	May 23 2012 09:13
Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil By: Marcelo Paiva Marcelo Paiva, home user, I am bazilian, I don´t speak or write English, I need help around sqlite?????, my question: How question in sqlite the sentence like the sentence in Posthe tgreSQL: data -> date type -> example -> 22/05/2012…	2	May 23 2012 07:10	May 23 2012 07:38
Bug? Shell (sqlite3.exe) exits after ".read"-ing a file that contains two errors By: K. Frank Hello List! I see unexpected behavior using sqlite3's .read command. The basic problem is illustrated by the following test file: C:\>type test2.sql -- two errors, sqlite3 exits select count() from no_table_a; select count()…	0	May 23 2012 07:11	May 23 2012 07:11
Disable lock control in Sqlite (windows) By: Marco Turco Hi all, I need to disable the Sqlite3 locking system for a Windows app that runs on a Mac using the Wine/Crossover API, this due to the fact Wine/Crossover have problem to manage the locking status on a network shared drive. My app already…	0	May 23 2012 06:11	May 23 2012 06:11
SQL Query - finding rows in a table that are not present in another By: Paul Sanderson I have a couple of table seach of which has one column but millions of rows, the column is a text column. I need to return all of the rows in table B that are not present in table A What is the most efficient way of doing this?	1	May 23 2012 04:12	May 23 2012 04:33
Fwd: Re: Licence By: Oliver Schneider Re-sending because the list still complains about PGP signatures. -------- Original Message -------- Subject: Re: [sqlite] Licence Date: Tue, 22 May 2012 20:55:06 +0000 On 2012-05-22 20:48, Net Surfer wrote: >> Just a quick question. To…	0	May 22 2012 19:36	May 22 2012 19:36