Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

If that is not an option, then you should probably create a function taking the HSTORE key and the sought key and returning the corresponding value or NULL. On Mon, Mar 17, 2014 at 11:41 PM, Tiago Rodrigues wrote: > Generally, I'd suggest you take these HSTORE

Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

Generally, I'd suggest you take these HSTORE key-value-pairs types and recast them as a separate table (say, HSTORE (STORE integer primary key, KEY text, VALUE text) ) and then query (SELECT VALUE FROM {TABLE1} JOIN HSTORE ON HSTORE.STORE = {TABLE1}.{HSTORECOLUMN} WHERE VALUE = 'some_key';) On

[sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

Hi, I have a column which contains a string structure taken from the PostgreSQL HSTORE key-value-pairs type. This is an example of one column value: "operator"=>"police","name"=>"Zurich","some_key"=>"some_value" Any suggestions on how to query this most efficiently (like [select value from

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Ok, tomorrow i'll try again to use followind your instructions and i'll feedback answer this emaili hope to be able... Il 17/03/2014 22.27, Joe Mistachkin ha scritto: Stefano Ravagni wrote: I cannot recompile because i run under Windows XP and without Visual C, i use Visual Basic...

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Stefano Ravagni wrote: > > I cannot recompile because i run under Windows XP and without Visual C, > i use Visual Basic... > You would need to recompile your application against the new System.Data.SQLite assembly, not System.Data.SQLite itself. > > properties in next compiled versione ? If

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

A... ok...is this the problem... I cannot recompile because i run under Windows XP and without Visual C, i use Visual Basic... I use SQLite as a referenced library, so i have to wait for a new compiled version... I will found the StickyHasRows properties in next compiled versione ? If

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Stefano Ravagni wrote: > > Joe i tryed the beta library you propose to me... but i obtain this error: > > "Exception has been thrown by the target of an invocation." > Can you make sure that all the binaries included in that ZIP file end up in the application binary directory? This is

Re: [sqlite] SQLite Interop exception

Rishi Ravindran wrote: > > Is this normal behavior or am I missing any step? > It looks like you are attempting to use managed System.Data.SQLite binaries compiled in the "Debug" build configuration with native System.Data.SQLite binaries compiled in the "Release" build configuration. By

[sqlite] failure to build static library with -DSQLITE_ENABLE_ICU

2014-03-14 0:30 GMT+01:00 Alex Loukissas : > I have verified that adding the said include fixes the issue (1-line patch): > > diff --git sqlite3.c sqlite3.c > index 7c6d3e2..a9399e4 100644 > --- sqlite3.c > +++ sqlite3.c > @@ -145656,6 +145656,7 @@ SQLITE_API int sqlite3_rtree_init( > #include >

[sqlite] Escaping conventions for FTS4 virtual table queries

This may seem rather esoteric, but if I want to find all FTS matches for a literal string containing an asterisk, how do I escape the asterisk so that it's not interpreted as a wildcard? Specifically, this query: SELECT docid FROM fts WHERE text MATCH 'any*'; will give me docids of documents

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Joe i tryed the beta library you propose to me... but i obtain this error: "Exception has been thrown by the target of an invocation." The error happen in this line of my code: MyDBFactory = DbProviderFactories.GetFactory("System.Data.SQlite") I forgot something ?? I can see the beta library

Re: [sqlite] Error "Database or disk if full" shown when indexing for 2 billion records.

I think the idea was to SELECT md5_str FROM WHERE rowid = ?; instead of SELECT md5('mm' || ?); or even SELECT rowid FROM WHERE md5_str = ?; which is a fast way of finding the inverse function for md5. -Ursprüngliche Nachricht- Von: RSmith [mailto:rsm...@rsweb.co.za] Gesendet:

Re: [sqlite] Error "Database or disk if full" shown when indexing for 2 billion records.

On 03/17/2014 08:32 PM, Yi Wang wrote: I inserted 2 billion records with only 1 column with name of "str_md5", the value is the MD5 encrypted value of "mm"+rowid(such like MD5(mm121212...). I didn't not create primary key for the only column b/c i am not sure it would slow the speed of insert

Re: [sqlite] Error "Database or disk if full" shown when indexing for 2 billion records.

Oh, by the way in 2b entries, you may hit duplicate MD5 hashes... which will fail the insert when they are primary-keyed Also, the index does not add 30% as a norm.. it very much depends how wide the data is the index is on, so be careful to take that as a rule... Also, I know there

Re: [sqlite] Error "Database or disk if full" shown when indexing for 2 billion records.

That's insane... well done :) To create the Index you will need at least as much disk space as already used... so you will need another 87GB (approx), not just another 50GB. And it will take no longer to create the table + Index from the start than it will take to create first the table, then

[sqlite] Error "Database or disk if full" shown when indexing for 2 billion records.

I inserted 2 billion records with only 1 column with name of "str_md5", the value is the MD5 encrypted value of "mm"+rowid(such like MD5(mm121212...). I didn't not create primary key for the only column b/c i am not sure it would slow the speed of insert command. The whole insert of 2 billion

[sqlite] SQLite Interop exception

Hello, When compiling and debugging the test.2010.csproj project I got a couple of exceptions. Initially it complained of missing SQLite.Interop.dll and when I copied it to the "sqlite-netFx-source-1.0.91.0\bin\2010\Debug\bin" folder from the binaries folder I ran into the exception reproduced

Re: [sqlite] Problem with sqlite3_exec

Thank you Kees Nuyt It solves the problem. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-sqlite3-exec-tp74523p74579.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

Re: [sqlite] System.Data.SQLite Deployment Mystery

Hi, Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > > dpybus wrote: > > > > I have an identical problem. I cannot deploy an app which uses either > > Net > 4.5 > > or 4.5.1 with the appropriate sqlite dll. It can be fixed by > > installing > the > > sqlite package

Re: [sqlite] System.Data.SQLite Deployment Mystery

Oh boy! This sounds like another good reason to stay with C++. .Net is becoming more and more problematic as I explore it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Monday, March 17, 2014 12:34 AM To:

Re: [sqlite] [sqlite-dev] Final preparations for the releaseof System.Data.SQLite v1.0.92.0 have begun...

Thank you Joe, today i Will try if work in my intentions and i'll feedback to you Joe Mistachkin ha scritto: > >Stefano Ravagni wrote: >> >> If yes, i like this way! When could i try the compiled version for make >somes tests? >> > >Here is a temporary set of debug

Re: [sqlite] [sqlite-dev] Final preparations for the releaseof System.Data.SQLite v1.0.92.0 have begun...

Stefano Ravagni wrote: > > If yes, i like this way! When could i try the compiled version for make somes tests? > Here is a temporary set of debug binaries for the .NET Framework 4.0 (or higher): https://system.data.sqlite.org/temporary/System.Data.SQLite-StickyHasRows-59 fcdb.zip -- Joe

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Hello and thanks for reply ... You want say i have just to add " Flags=StickyHasRows;" to normal string connection and i could use hasrows in the way i say? If yes, i like this way! When could i try the compiled version for make somes tests? Joe Mistachkin ha scritto: