[sqlite] 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 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

[sqlite] RE: sqlite testing with Boundschecker

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

[sqlite] Semantic Database Design

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: [sqlite] Re: In Mem Query Performance

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

Re: [sqlite] Semantic Database Design

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 (

Re: [sqlite] Re: In Mem Query Performance

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)

Re: [sqlite] sqlite testing with Boundschecker

"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

Re: [sqlite] Semantic Database Design

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

[sqlite] error in step

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

[sqlite] SQL query assistance...

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

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 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

Re: [sqlite] SQL query assistance...

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

Re: [sqlite] SQL query assistance...

- 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

Re: [sqlite] SQL query assistance...

- 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

Re: [sqlite] Semantic Database Design

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 >

Re: [sqlite] Semantic Database Design

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

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

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

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

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

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

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

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

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