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 key-value-pairs types and
> recast
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 Mo
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 "some
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...
Yo
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 y
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
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 especially
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 default
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
>
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
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
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: Monta
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 co
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
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
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
reco
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 bel
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
sqlit
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
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:
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 binaries for the .NET Framew
21 matches
Mail list logo