I stand corrected, thank you Andrew. I seriuosly doubt it is a bug in
SQlite, but I have had a hell of a time with sqlite and binding
dynamically allocated text and binary data.
On 7/1/07, Andrew Finkenstadt <[EMAIL PROTECTED]> wrote:
On 7/1/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
>
> I wa
On 7/1/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
I was trying to look through the SQLITE source code to see how the
sqlite3_bind_blob routine worked.
sqlite3_bind_blob passes the data pointer to bindText
bindText passes the data pointer to sqlite3VdbeMemSetStr
sqlite3VdbeMemSetStr then does.
On 7/1/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
On 7/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Rich Rattanni" <[EMAIL PROTECTED]> wrote:
> > All:
> > I am using SQlite to store several rows of binary data into a
> > database. In my code I have a several character arrays conta
On 7/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Rich Rattanni" <[EMAIL PROTECTED]> wrote:
> All:
> I am using SQlite to store several rows of binary data into a
> database. In my code I have a several character arrays containing
> data. I then do the following...
>
> 1.Begin Transa
FYI, here is a good article describing how to serialize .NET data (as BLOB) to
Sqlite database:
http://www.windevtools.com/show_article.asp?pg=dotNET%20Serialization%20to%20SQLite%20Database/howto.html
cheers
This message was s
On 7/1/07, Mov GP 0 <[EMAIL PROTECTED]> wrote:
2007/7/1, Trevor Talbot <[EMAIL PROTECTED]>:
>
> On 7/1/07, Mov GP 0 <[EMAIL PROTECTED]> wrote:
>
> > I'm searching for a database backend for a .NET project that involves a
> > semantic database backend. The problem is that I want to store any
> gen
"Rich Rattanni" <[EMAIL PROTECTED]> wrote:
> All:
> I am using SQlite to store several rows of binary data into a
> database. In my code I have a several character arrays containing
> data. I then do the following...
>
> 1.Begin Transaction
> 2.For each blob...
> 2a.sqlite3_prepare("Insert s
- Original Message -
From: "Jeff Godfrey" <[EMAIL PROTECTED]>
Thanks Gerry,
Indeed, I have tried exactly that.
Hmmm... This seems to be a thread for eating crow... ;^)
Hi Gerry,
My actual query is a bit more complex than the sample I posted. I
thought my posted sample was a valid
All:
I am using SQlite to store several rows of binary data into a
database. In my code I have a several character arrays containing
data. I then do the following...
1.Begin Transaction
2.For each blob...
2a.sqlite3_prepare("Insert statement...")
2b.call sqlite3_bind_blob(stmt, col#, dataPoi
- Original Message -
From: "Andrew Finkenstadt" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 01, 2007 4:45 PM
Subject: Re: [sqlite] SQL query assistance...
On 7/1/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote:
Hi All,
Given the following sample data...
ID Name Version
--- - ---
- Original Message -
From: "Andrew Finkenstadt" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 01, 2007 4:45 PM
Subject: Re: [sqlite] SQL query assistance...
On 7/1/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote:
Hi All,
Given the following sample data...
ID Name Version
--- - ---
- Original Message -
From: "Gerry Snyder" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 01, 2007 4:40 PM
Subject: Re: [sqlite] SQL query assistance...
Jeff Godfrey wrote:
Hi All,
Given the following sample data...
ID Name Version
--- - ---
1 name1 0.9
2 name1 1.0
3
On 7/1/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote:
Hi All,
Given the following sample data...
ID Name Version
--- - ---
1 name1 0.9
2 name1 1.0
3 name2 1.2
4 name3 1.0
5 name3 1.7
6 name3 1.5
I need to create a query that will group the data together by Name, but
f
Jeff Godfrey wrote:
Hi All,
Given the following sample data...
ID Name Version
--- - ---
1 name1 0.9
2 name1 1.0
3 name2 1.2
4 name3 1.0
5 name3 1.7
6 name3 1.5
I need to create a query that will group the data together by Name, but for
each group will return the r
Hi All,
Given the following sample data...
ID Name Version
--- - ---
1 name1 0.9
2 name1 1.0
3 name2 1.2
4 name3 1.0
5 name3 1.7
6 name3 1.5
I need to create a query that will group the data together by Name, but for
each group will return the record with the highest
Hi all,
Any idear about this error:
2007-07-01 17:01:48,145 (BotTopicData.java:getTopics:342) ERROR -
sSql=SELECT * FROM topic WHERE value LIKE 'O';
2007-07-01 17:01:48,155 (SQLite.java:execQuery:79) ERROR - SQLite.Exception:
error in step
After that (not sure), my tomcat server go to ERROR 404
2007/7/1, Trevor Talbot <[EMAIL PROTECTED]>:
On 7/1/07, Mov GP 0 <[EMAIL PROTECTED]> wrote:
> I'm searching for a database backend for a .NET project that involves a
> semantic database backend. The problem is that I want to store any
generic
> kind of custom .NET datatype and not only SQL-prim
"Damian Slee" <[EMAIL PROTECTED]> wrote:
>
> I have done some testing with 3.2 and now 3.4, visual studio2003 and
> boundschecker (and XP).
Thank you for the report.
I have analyzed the errors reported by boundschecker and they
all appear to be false postives. The SQLite 3.4.0 code base
is cor
Hi Joe/John
Appreciate your reply.
Result: with your suggestions it is to down to 3 secs.
But i need to get it to 1sec. Possible?
Here are the findings,
1) With Mem db default compile options and with suggestions(bind+ index) you
have
provided to use bind performance stands at 10-11secs.
2) With
On 7/1/07, Mov GP 0 <[EMAIL PROTECTED]> wrote:
I'm searching for a database backend for a .NET project that involves a
semantic database backend. The problem is that I want to store any generic
kind of custom .NET datatype and not only SQL-primitives.
CREATE TABLE @TableName
(
Obj
It looks as if you would do better to run your job as one or more
transactions and to use the Sqlite API, with the sequence:
sqlite3_prepare
begin transaction
loop
sqlite3_bind
sqlite3_step
sqlite3_reset
end
Hi,
I'm searching for a database backend for a .NET project that involves a
semantic database backend. The problem is that I want to store any generic
kind of custom .NET datatype and not only SQL-primitives.
First, the Database should have a triple store for the semantic relations
that is built
Re-submitted cause line color in red didn’t come thru. [] around the
reported line
Subject: sqlite testing with Boundschecker
Hi,
I have done some testing with 3.2 and now 3.4, visual studio2003 and
boundschecker (and XP). I get a few reported errors when I simply do the
.dump command
Hi,
I have done some testing with 3.2 and now 3.4, visual studio2003 and
boundschecker (and XP). I get a few reported errors when I simply do the
.dump command with no db. Happens on other times with a db, this is easier.
Line numbers are from the downloaded 3.4.0 source. I don’t really know ho
24 matches
Mail list logo