[sqlite] ADO.NET Provider, targeting any cpu

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 by itself the right dll to use at runtime ? I

[sqlite] SQL Query - finding rows in a table that are not present in another

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? ___ sqlite-users mailing

Re: [sqlite] ADO.NET Provider, targeting any cpu

Damien wrote: > > Is there a way to have an assembly targeting "any cpu", that chooses by > itself the right dll to use at runtime ? > The System.Data.SQLite managed-only assembly, when the native library pre-loading code is enabled (which it is by default starting with release 1.0.80.0), will

Re: [sqlite] SQL Query - finding rows in a table that are not present in another

On May 23, 2012, at 11:12 AM, Paul Sanderson wrote: > I need to return all of the rows in table B that are not present in table A You have at least 3 ways to express such a query: (1) Using 'in' select table_b.* fromtable_b where table_b.key not in ( select key from table_a ) (2)

Re: [sqlite] ADO.NET Provider, targeting any cpu

2012/5/23 Joe Mistachkin > > Damien wrote: > > > > Is there a way to have an assembly targeting "any cpu", that chooses by > > itself the right dll to use at runtime ? > > > > The System.Data.SQLite managed-only assembly, when the native library > pre-loading code is

[sqlite] Disable lock control in Sqlite (windows)

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 has a built-in locking system so it could runs also

[sqlite] Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil

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 -> diferent -> "22/05/2012" question/sentence: select *from

[sqlite] Bug? Shell (sqlite3.exe) exits after ".read"-ing a file that contains two errors

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(*) from no_table_b; C:\> Here's the result of running

[sqlite] sqlite3_analyzer failing for large files

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 smaller databases I've tested. My guess is that

Re: [sqlite] csv test cases (was Details On New Features)

-- Regarding: * I have a question about #9 of your test cases. According to RFC 4180, #9 is an invalid record. The RFC states "If fields are not enclosed with double quotes, then double quotes may not appear inside the fields."* My example #9 was: 9,imperial ("laughing") loon I'm no

Re: [sqlite] Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil

Here are the steps you must take: 1. Understand that sqlite3 does not have a DATE type, only text. It does have functions that can work with text strings to be treated as dates, for example strftime(). 2. Convert all your dates in the database and in your programmes to use a text format

Re: [sqlite] Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil

On 22 May 2012, at 7:25pm, Marcelo Paiva wrote: > data -> date type -> example -> 22/05/2012 -> diferent -> "22/05/2012" > > question/sentence: select *from tcontsif01 where data>='01/01/2012' and > data<='01/05/2012' SQLite has no datatype for dates. Your data

Re: [sqlite] ADO.NET Provider, targeting any cpu

-Original Message- The System.Data.SQLite managed-only assembly, when the native library pre-loading code is enabled (which it is by default starting with release 1.0.80.0), will now attempt to detect the processor architecture of the process it is being loaded into and then it will

Re: [sqlite] sqlite3_analyzer failing for large files

On 05/23/2012 05:06 PM, Demper Delic wrote: 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

Re: [sqlite] sqlite-users Digest, Vol 53, Issue 22

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 On Wed, May 23, 2012 at 9:00 AM, wrote: > Message: 15 > Date: Wed, 23 May 2012 08:11:17

[sqlite] Feature Request: Change busy error message

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 handled via a busy handler. The error message

Re: [sqlite] Feature Request: Change busy error message

> SQLITE_LOCKED implies that the contention is on the > same connection Where did you get this from? Nothing can prevent execution of several statements on the same connection. AFAIK, SQLITE_LOCKED implies that contention is from another connection using the same shared database cache. And it

Re: [sqlite] Feature Request: Change busy error message

On Wed, May 23, 2012 at 7:22 PM, Pavel Ivanov wrote: > AFAIK, SQLITE_LOCKED implies that contention is from another > connection using the same shared database cache. And it can be handled > either via a busy handler just like SQLITE_BUSY or via > sqlite3_unlock_notify().

Re: [sqlite] Feature Request: Change busy error message

On Wed, May 23, 2012 at 1:25 PM, Stephan Beal wrote: > On Wed, May 23, 2012 at 7:22 PM, Pavel Ivanov wrote: > >> AFAIK, SQLITE_LOCKED implies that contention is from another >> connection using the same shared database cache. And it can be handled >>

Re: [sqlite] Feature Request: Change busy error message

On Wed, May 23, 2012 at 7:37 PM, Pavel Ivanov wrote: > > #define SQLITE_BUSY 5 /* The database file is locked */ > > #define SQLITE_LOCKED 6 /* A table in the database is locked */ > > Was this quote supposed to answer some question or clarify something? i

[sqlite] Serialized + Prepared Statement Clarification

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 following which seems to contradict this: "

Re: [sqlite] Serialized + Prepared Statement Clarification

On 5/23/2012 1:51 PM, Sander Jansen wrote: 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 following

Re: [sqlite] Serialized + Prepared Statement Clarification

On Wed, May 23, 2012 at 1:05 PM, Igor Tandetnik wrote: > On 5/23/2012 1:51 PM, Sander Jansen wrote: >> >> 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,

[sqlite] ICU extension not working as expected

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: sqlite> .load lib/libSQLiteICU.so sqlite>

Re: [sqlite] ICU extension not working as expected

> I expected both statements to return the same result.  Am I overlooking > something or do I misunderstand the capabilities of ICU's "unicode-aware > LIKE operator"? I believe "unicode-aware LIKE operator" means case-insensitive for non-ASCII characters, not diacritic-insensitive. Pavel On

Re: [sqlite] ICU extension not working as expected

On Wed, May 23, 2012 at 2:11 PM, Courtney Grimland < cgriml...@cfa.harvard.edu> wrote: > 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 >

Re: [sqlite] Feature Request: Change busy error message

I got it from http://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked "Note that an SQLITE_LOCKED error is distinct from SQLITE_BUSY (5). SQLITE_BUSY means that another database connection (probably in another process) is using the database in a way that prevents you from using it. SQLITE_LOCKED

Re: [sqlite] ICU extension not working as expected

> > As you can see, this can get arbitrarily complex. We still don't > have a good answer. Your input is welcomed. > If only I knew enough about the subject to be able to provide any useful input. Naturally, I think it should work exactly as I want it to work at any given moment. ;) > >

Re: [sqlite] ADO.NET Provider, targeting any cpu

Rob Richardson wrote: > > This is the first I have heard of this feature or requirement or whatever this is. > This statement seems to be saying that the "System.Data.SQLite managed-only assembly" > is different from the "System.Data.SQLite assembly". Is that true? When I download > a new

Re: [sqlite] ICU extension not working as expected

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: sqlite> .load lib/libSQLiteICU.so sqlite>