Re: [sqlite] Re: How to check if the table has some specific values

2007-12-13 Thread Kees Nuyt
Hi Joanne, On Wed, 12 Dec 2007 16:20:17 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: >Hi Igor, >Thanks for the response. >Basiclly there is no SQL logic in SQLite. I'm not sure what you mean here. >I would like to check if the database version is xyz >then I will have different action

Re: [sqlite] Re: How to check if the table has some specific values

2007-12-13 Thread Trevor Talbot
I think Joanne's example may be simplified, and the question was really more general... On 12/12/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Basiclly there is no SQL logic in SQLite. Right, there's nothing like T-SQL. Even in other databases, most procedural logic along IF..THEN lines is done

[sqlite] ANN: SQLite Maestro 7.12 released

2007-12-13 Thread SQL Maestro Group
Hi! SQL Maestro Group announces the release of SQLite Maestro 7.12, a powerful Windows GUI solution for SQLite administration and database development. http://www.sqlmaestro.com/products/sqlite/maestro/ Please note that before December 31 you can purchase SQLite Maestro and our other

[sqlite] sqlite3_prepare / sqlite3_step not working

2007-12-13 Thread CAVALO SCHMIDT
Salutations, In the following simple C code (in Console program): sqlite3 *db; int ret = sqlite3_open("dict.db", ); sqlite3_stmt *stmt; char sql[256]; sprintf(sql, "%s", "select * from a where a = 'key1'"); int rc = sqlite3_prepare(db, sql, 0, , 0);

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Tom Briggs
> Something I will say about this, for people who don't know, is that > this columnar thing is strictly an implementation detail. While I think that this is an oversimplification. That's somewhat like saying that the way you use a sledge hammer is no different than how you use a claw

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Tom Briggs
Based on my experience with SQLite, it would be a huge undertaking to re-work it to use column-oriented storage. And I don't think it would really fit with SQLite's goal, either; column oriented databases are best suited to aggregate queries against large amounts of data, while SQLite is best

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread drh
Ion Silvestru <[EMAIL PROTECTED]> wrote: > >SW: Richard, We have written to you directly before to ask you to stop the > >FUD and incorrect statements, and you have chosen to continue. I suggest you > >not waste everyone's time by circulating deliberately misleading > >information. > > I think

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread steveweick
D. Richard Hipp wrote: > > Ion Silvestru <[EMAIL PROTECTED]> wrote: >> >SW: Richard, We have written to you directly before to ask you to stop >> the >> >FUD and incorrect statements, and you have chosen to continue. I suggest >> you >> >not waste everyone's time by circulating deliberately

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread steveweick
oops, I guess I need to get used to this message list protocol. First let me apologize for letting Richard get me mad. Most of my friends would describe me as one of the most laid back people they know. Why am I mad you ask? We wrote Richard back in August to correct his misstatements then. He

RE: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread Samuel R. Neff
Steve, I found the information you posted to be a good contrast and would love to learn more, but you didn't include any technical details. You said you have atomic commits without a rollback journal and instead use some revolutionary new way of doing commits. You said DeviceSQL performs

[sqlite] Casting bug

2007-12-13 Thread T
When I try: select cast( 141.70 * 100 as integer) I get 0.69, but should get 0.70 What's the problem? Seems like a bug. I tried some other numbers in place of 141.70, and they worked OK, though I imagine there are others that have the bug that I just haven't tried. The above is the

Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread Ion Silvestru
>We wrote Richard back in August to correct his misstatements then. He chose >to ignore the letter. August? We start to discuss about DeviceSQL some days ago, or I am wrong? - To unsubscribe, send email to [EMAIL

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread drh
steveweick <[EMAIL PROTECTED]> wrote: > D. Richard Hipp wrote: > > > > Unfortunately, Steve Weick might not see your comment > > since he appears to have unsubscribed from the mailing list > > immediately after sending his inflammatory missive. > > Hmmm... Further digging prompted by the

Re: [sqlite] Casting bug

2007-12-13 Thread Gerry Snyder
T wrote: When I try: select cast( 141.70 * 100 as integer) I get 0.69, but should get 0.70 Assuming you mean you got 14169, maybe you should look at http://sqlite.org/faq.html#q16 HTH, Gerry - To unsubscribe,

Re: [sqlite] sqlite3_prepare / sqlite3_step not working

2007-12-13 Thread Dennis Cote
CAVALO SCHMIDT wrote: In the following simple C code (in Console program): sqlite3 *db; int ret = sqlite3_open("dict.db", ); sqlite3_stmt *stmt; char sql[256]; sprintf(sql, "%s", "select * from a where a = 'key1'"); int rc = sqlite3_prepare(db, sql, 0, , 0);

RE: [sqlite] Casting bug

2007-12-13 Thread Cariotoglou Mike
well, first of all you must have a typo, since the sql you show will return 14170, not 0.69 or anything like it. however, one thing springs out: Total * 100 + 100 is wrong IMHO, unless you are looking for CEILING functionallity. "round" would need : total * 100 +50 (which rounds to nearest

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread drh
Ion Silvestru <[EMAIL PROTECTED]> wrote: > >We wrote Richard back in August to correct his misstatements then. He chose > >to ignore the letter. > > August? We start to discuss about DeviceSQL some days ago, or > I am wrong? > I have several support customer in Europe who have been visited by

Re: [sqlite] sqlite3_prepare / sqlite3_step not working

2007-12-13 Thread CAVALO SCHMIDT
Thank you, it now works. 2007/12/13, Dennis Cote <[EMAIL PROTECTED]>: > > CAVALO SCHMIDT wrote: > > In the following simple C code (in Console program): > > > > sqlite3 *db; > > int ret = sqlite3_open("dict.db", ); > > sqlite3_stmt *stmt; > > char sql[256]; > > sprintf(sql,

Re: [sqlite] How to get number of records in record set

2007-12-13 Thread drh
"Tom Parke" <[EMAIL PROTECTED]> wrote: > If I prepare() a sql stmt SELECT * FROM tbl WHERE col = n: > > How do I find out how many records were selected before calling step()? > The technically correct response to your question is that the answer is always zero. Nothing gets selected - the

Re: [sqlite] Casting bug

2007-12-13 Thread Dennis Cote
Cariotoglou Mike wrote: Total * 100 + 100 is wrong IMHO, unless you are looking for CEILING functionallity. "round" would need : total * 100 +50 (which rounds to nearest integer at two decimal points, not to the nearest LARGER integer, which is what your sample does) Shouldn't that be

[sqlite] How to get number of records in record set

2007-12-13 Thread Tom Parke
If I prepare() a sql stmt SELECT * FROM tbl WHERE col = n: How do I find out how many records were selected before calling step()? Tom

Re: [sqlite] Casting bug

2007-12-13 Thread T
oops, sorry, slight correction: When I try: select cast( 141.70 * 100 as integer) I get 14169, but should get 14170 Tom - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Casting bug

2007-12-13 Thread T
Hi Mike, well, first of all you must have a typo, since the sql you show will return 14170, not 0.69 or anything like it. Yes, typo, sorry. The short version returns 14169 but should give 14170, as per my correction a minute ago. however, one thing springs out: Total * 100 + 100 is

RE: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread steveweick
Hi Sam, re your points below: 1. I think I said "innovative", not "revolutionary". The scheme involves using "dirty bits" rather than a log to record the transactional state of a page. 2. We plan on publishing all the details of the benchmarks in a few days. But to answer your question about

[sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread drh
Ticket number #2822 http://www.sqlite.org/cvstrac/tktview?tn=2822 has provoked extensive changes to the way SQLite handles ORDER BY clauses. The current algorithm goes like this: (1) If an ORDER BY term is a constant integer k then sort by the k-th column of the result set.

RE: [sqlite] How to get number of records in record set

2007-12-13 Thread Tom Parke
Thanks, that makes sense. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 7:50 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to get number of records in record set "Tom Parke" <[EMAIL PROTECTED]> wrote: > If I

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Jeff Hamilton
My vote is for 3.5.4. -Jeff - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: Casting bug

2007-12-13 Thread Igor Tandetnik
T wrote: I shouldn't have complicated my question by using the word "round". It's not the rounding that I'm trying to do. The input values are already rounded to two decimal places (cents of the dollar). Realize that floating point numbers are stored by computers in binary, not in decimal.

Re: [sqlite] Casting bug

2007-12-13 Thread drh
T <[EMAIL PROTECTED]> wrote: > > >> select cast( 141.70 * 100 as integer) > > gives the incorrect 14169 14169 is the correct answer, believe it or not. There is no such thing as the number 141.70 in a 64-bit IEEE float. The closest you can get is

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread John Stanton
[EMAIL PROTECTED] wrote: Ion Silvestru <[EMAIL PROTECTED]> wrote: SW: Richard, We have written to you directly before to ask you to stop the FUD and incorrect statements, and you have chosen to continue. I suggest you not waste everyone's time by circulating deliberately misleading

RE: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Fred Williams
If you suspect "Group By" also may be broken, why not to an interim "bug fix" release and then do the version number change when both "Order By" and "Group By" are fixed? I seem to remember instances where both Order BY and Group By have given me "unexpected" results. But then again, my logical

[sqlite] Running multiple SQLite processes

2007-12-13 Thread kenmor
Hi Everyone, We are seeing the following strange behaviour with SQLite. Our environment is as follows 1. SQLite 3.5.3 2. Using MEMORY DB 3. Many databases 4. Sun Solaris machine T2000 (32 cores and 16G memory) 5. A single DB table with only 2 entries (so size is not an issue here!) 6. A

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Dustin Bruzenak
I'd vote 3.5.4 as well. [EMAIL PROTECTED] wrote: Ticket number #2822 http://www.sqlite.org/cvstrac/tktview?tn=2822 has provoked extensive changes to the way SQLite handles ORDER BY clauses. The current algorithm goes like this: (1) If an ORDER BY term is a constant integer k

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Tom Briggs
Heh, no, I've never tried, but I don't see much reason why I couldn't. I was just trying to make the point that labeling SQLite as "good ... for smaller databases" was not a slight. -T > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, December

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Joe Wilson
--- Tom Briggs <[EMAIL PROTECTED]> wrote: >For clarity, my definition of small is about 200GB, so I'm not > selling SQLite short here... Are you able to get decent performance out of sqlite3 for a 200GB database? How much RAM do you have on such a machine?

Re: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Tom Briggs <[EMAIL PROTECTED]> wrote: > >For clarity, my definition of small is about 200GB, so I'm not > > selling SQLite short here... > > Are you able to get decent performance out of sqlite3 for a 200GB database? > > How much RAM do you have

[sqlite] Testing SQLite

2007-12-13 Thread Brown, Daniel
Morning List, I've just started experimenting with SQLite to see if I can replace our current custom embedded database solution with it and trying to port SQLite to some of our embedded platforms. Are there are any testing frameworks (unit tests would be great) for SQLite? I'd like to be able to

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Joe Wilson
The reason why I asked is that I haven't had much luck with sqlite3 performance for databases larger than the size of RAM on my machine regardless of PRAGMA settings. Maybe querying speed is fine for multi gigabyte database files, but INSERT speed into tables with multiple indexes is slow when

Re: [sqlite] Testing SQLite

2007-12-13 Thread drh
"Brown, Daniel" <[EMAIL PROTECTED]> wrote: > Morning List, > > I've just started experimenting with SQLite to see if I can replace our > current custom embedded database solution with it and trying to port > SQLite to some of our embedded platforms. Are there are any testing > frameworks (unit

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Samuel R. Neff
That also brings up the simple solution in that if you know you're db is going to be in the 200GiB range, declare a larger page size before creating the DB. Sam --- We're Hiring! Seeking a passionate developer to join our team building Flex based

RE: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Mike Marshall
Seems like a 3.5.4 to me Mike - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Samuel R. Neff
3.5.4 --- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Dennis Cote
[EMAIL PROTECTED] wrote: The current algorithm goes like this: (1) If an ORDER BY term is a constant integer k then sort by the k-th column of the result set. (2) If an ORDER BY term is a simple identifer (like "x", not "x.y" and not "x.y.z") and if there if

Re: [sqlite] Casting bug

2007-12-13 Thread Dennis Cote
[EMAIL PROTECTED] wrote: T <[EMAIL PROTECTED]> wrote: select cast( 141.70 * 100 as integer) gives the incorrect 14169 14169 is the correct answer, believe it or not. There is no such thing as the number 141.70 in a 64-bit IEEE float. The closest you can get is

Re: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Dennis Cote
Samuel R. Neff wrote: That also brings up the simple solution in that if you know you're db is going to be in the 200GiB range, declare a larger page size before creating the DB. My thoughts exactly. Dennis Cote

Re: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Dennis Cote
[EMAIL PROTECTED] wrote: Whenever you start a new transaction, SQLite has to allocate and clear a bitmap used to record which pages have changes in the database file. The size of this bitmap is proportional to the size of the database file. The size of the bitmap is 256 bytes per megabyte of

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread Dennis Cote
steveweick wrote: the tests were done using Windows XP SP2 and Linux FC5 on a 3GHz P4 with 1MB That must be very slow. ;-) I'm sure you meant 1GB for windows XP. Dennis Cote - To unsubscribe, send email to [EMAIL

[sqlite] Convert readonly database file to :memory: ?

2007-12-13 Thread Thomas Heller
[Has also been posted to the pysqlite-users mailing list] I have a sqlite database in a readonly file. Is it possible to create a :memory: database and quickly initialize it from the file? Thanks, Thomas - To

[sqlite] sqlite3_exec() and callback

2007-12-13 Thread Tom Parke
>From what I think I have learned so far, if I call sqlite3_exec() giving it a call back function and a select * from tbl, I do not have any direct access to the column values other that the text representation in the values char array from within the callback()? This leads me to the question,

Re: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread drh
Dennis Cote <[EMAIL PROTECTED]> wrote: > > Richard, > > How was the current default page size of 1K determined? Was there any > testing to see if larger page sizes would be beneficial for general use? > Or is it just a historical circumstance (i.e. an arbitrarily chosen > value that has been

RE: [sqlite] Testing SQLite

2007-12-13 Thread Brown, Daniel
Ah, I just figured out why I thought I've not got the tests. I've been using the pre-processed C code version of SQLite (as I'm working in Visual Studio on Windows), I guess I'll need to get the full SQLite package building with make then to get the test functionality instead of using the

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-13 Thread steveweick
oops, fingers are moving faster than the brain :-) of course, you are right, Dennis. Steve Dennis Cote wrote: > > steveweick wrote: >> the tests were done >> using Windows XP SP2 and Linux FC5 on a 3GHz P4 with 1MB >> > > That must be very slow. ;-) > > I'm sure you meant 1GB for windows

[sqlite] create table with datatype = DATE

2007-12-13 Thread Joanne Pham
Hi All, I create the table as : create table test (name varchar(30), createDate DATE default DATETIME('NOW')); but I got the error message. I want to have the default as now if it is not specify. Thanks in advance, Joanne

Re: [sqlite] create table with datatype = DATE

2007-12-13 Thread John Stanton
The type DATE is a declared type, not an actual type and has no effect u nless your code specifically picks it out as a declared type. To do what you want use a trigger on insert and update the date field with datetime('now'); Joanne Pham wrote: Hi All, I create the table as : create

Re: [sqlite] DeviceSQL

2007-12-13 Thread steveweick
I hope this is not a double post, but this was answered in another thread. See http://www.nabble.com/Improving-performance-of-SQLite.-Anyone-heard-of-DeviceSQL--to14280006.html#a14317195 D. Richard Hipp wrote: > > John Stanton <[EMAIL PROTECTED]> wrote: >> I received an email promoting a

Re: [sqlite] DeviceSQL

2007-12-13 Thread steveweick
As shown another thread, Richard has his facts wrong. See http://www.nabble.com/Improving-performance-of-SQLite.-Anyone-heard-of-DeviceSQL--to14280006.html#a14317195 Steve A. Pagaltzis wrote: > > * John Stanton <[EMAIL PROTECTED]> [2007-12-12 17:55]: >> In general claims of "20x" or even "5x"

Re: [sqlite] DeviceSQL

2007-12-13 Thread steveweick
Richard has it right this time. Today DeviceSQL uses no SQLite code. One of the things we might consider is bolting the SQLite parser/front end to our table engine, in theory to get the both worlds. Just an idea at the moment. Steve D. Richard Hipp wrote: > > Joe Wilson <[EMAIL PROTECTED]>

[sqlite] Insert chinese characters in SQLite database

2007-12-13 Thread Kalyani Phadke
Table CREATE TABLE [Test2] ( [ipaddress] INTEGER, [Name] text ) The following query works fine Set Cmd1 = Server.CreateObject("ADODB.Command") Cmd1 .ActiveConnection = AuditLogConnection Cmd1 .CommandText = "INSERT INTO Test2(ipaddress, name) VALUES ('192.168.1.1' ,

[sqlite] Re: Insert chinese characters in SQLite database

2007-12-13 Thread Igor Tandetnik
Kalyani Phadke wrote: The following query inserts into the database Cmd1 .Parameters.Append(Cmd1 .CreateParameter("ipaddress", adLongVarChar, adParamInput, 50, ipaddress)) Try adLongVarWChar for parameter type. Igor Tandetnik

[sqlite] Update current record

2007-12-13 Thread Tom Parke
Using sqlite3_prepare and then sqlite3_step() ing through the records, is there a way to update or replace the current record in a table while sqlite3_step() is on that record without a reselecting that record and sqlite3_exec() update table where? Something like a dynamic cursor in MS SQL?

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Dr Gerard Hammond
On 14/12/2007, at 3:40 AM, [EMAIL PROTECTED] wrote: Ticket number #2822 http://www.sqlite.org/cvstrac/tktview?tn=2822 (2) If an ORDER BY term is a simple identifer (like "x", not "x.y" and not "x.y.z") and if there if the k-th column uses that same identifer as an AS

RE: [sqlite] Re: Insert chinese characters in SQLite database

2007-12-13 Thread Kalyani Phadke
Yes , It worked. Could you pls tell me whats the difference between adLongVarWChar and adLongVarChar? Does SQLite support Unicode encoding(UTF-8)? -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 4:13 PM To: SQLite Subject: [sqlite]

RE: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread Darren Duncan
At 7:59 AM -0500 12/13/07, Tom Briggs wrote: > Something I will say about this, for people who don't know, is that this columnar thing is strictly an implementation detail. While I think that this is an oversimplification. That's somewhat like saying that the way you use a sledge

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Nuno Lucas
On Dec 14, 2007 12:35 AM, Steven Fisher <[EMAIL PROTECTED]> wrote: > On 13-Dec-2007, at 8:40 AM, [EMAIL PROTECTED] wrote: > > > My question to the community is this: Are these > > differences sufficient to justify going with version > > 3.6.0 in the next release? Or can we call the change > > a

Re: [sqlite] DeviceSQL

2007-12-13 Thread James Steward
steveweick wrote: Richard has it right this time. Today DeviceSQL uses no SQLite code. One of the things we might consider is bolting the SQLite parser/front end to our table engine, in theory to get the both worlds. Just an idea at the moment. Such an interesting discussion to be

[sqlite] Re: Update current record

2007-12-13 Thread Igor Tandetnik
Tom Parke <[EMAIL PROTECTED]> wrote: Using sqlite3_prepare and then sqlite3_step() ing through the records, is there a way to update or replace the current record in a table while sqlite3_step() is on that record without a reselecting that record and sqlite3_exec() update table where? Something

[sqlite] Re: Re: Insert chinese characters in SQLite database

2007-12-13 Thread Igor Tandetnik
Kalyani Phadke wrote: Yes , It worked. Could you pls tell me whats the difference between adLongVarWChar and adLongVarChar? Does SQLite support Unicode encoding(UTF-8)? SQLite does support UTF-8. But I suspect ADO actually converts the data to Windows current code page when adLongVarChar is

[sqlite] Re: [Linux + PHP] Recommended way to access SQLite?

2007-12-13 Thread Gilles Ganault
On Mon, 10 Dec 2007 16:35:48 +0100, Kees Nuyt <[EMAIL PROTECTED]> wrote: >So I activated php_pdo_sqlite_external instead and copied >sqlite3.dll v3.5.3 to %serverroot%/bin . Thanks for the infos. So the options are: 1. use the old SQLite2 sqlite_() functions (or some class that turns this

Re: [sqlite] DeviceSQL

2007-12-13 Thread dcharno
I would like to recommend that Encriq create a forum or mailing list of their own for those who are interesting in learning more. For me, what might be an interesting product is quickly being overshadowed by this thread. You raise some interesting points. There is nothing secret about

Re: [sqlite] DeviceSQL

2007-12-13 Thread steveweick
Hi James, You raise some interesting points. There is nothing secret about the benchmarks. We will make the code that was used to run benchmarks available to anyone who wants to see it and verify results. If you want to find a third party to verify, be my guest. The benchmark report goes into

RE: [sqlite] Re: Update current record

2007-12-13 Thread Tom Parke
By a "regular update statement", I assume you mean a SQL update tab set col = value, but I don't understand how to apply a SQL update statement to a ROWID. How can I get the ROWID in the call back? Can you point me to some sample code that could help me understand? Tom -Original

[sqlite] Re: Re: Update current record

2007-12-13 Thread Igor Tandetnik
Tom Parke <[EMAIL PROTECTED]> wrote: By a "regular update statement", I assume you mean a SQL update tab set col = value, but I don't understand how to apply a SQL update statement to a ROWID. update tableName set col = value where ROWID = ?; How can I get the ROWID in the call back?

RE: [sqlite] DeviceSQL

2007-12-13 Thread Birt, Jeffrey
I concur. Quite an interesting marketing strategy; Join you competitors' mailing lists and trash talk them. LOL -Original Message- From: dcharno [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 8:30 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DeviceSQL I would like

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Trey Mack
3.6.0 in the next release? Or can we call the change a "bug fix" and number the next release 3.5.4? I guess I'm in the minority, but I'd find a change in the meaning of my queries surprising in a bug fix release. That sounds like a 3.6 to me. You may be in the minority, but you're not

Re: [sqlite] Update current record

2007-12-13 Thread drh
"Tom Parke" <[EMAIL PROTECTED]> wrote: > Using sqlite3_prepare and then sqlite3_step() ing through the records, > is there a way to update or replace the current record in a table while > sqlite3_step() is on that record without a reselecting that record and > sqlite3_exec() update table where?

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Robert L Cochran
Trey Mack wrote: 3.6.0 in the next release? Or can we call the change a "bug fix" and number the next release 3.5.4? I guess I'm in the minority, but I'd find a change in the meaning of my queries surprising in a bug fix release. That sounds like a 3.6 to me. You may be in the

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Rick Langschultz
My question first is can this fix be rolled into a group of related fixes thus creating a service patch? If not then my opinion is 3.5.4. If you can roll it in with 3 - 10 easy fixes call it 3.6.0. Just an opinion though. I am waiting for 4.0, like it is Xmas Eve... On Dec 13, 2007, at

Re: [sqlite] SQLite and Columnar Databases

2007-12-13 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > The reason why I asked is that I haven't had much luck with sqlite3 > performance for databases larger than the size of RAM on my machine > regardless of PRAGMA settings. > This is probably do to the cache locality problem. We know how to fix this, Joe.

Re: [sqlite] DeviceSQL

2007-12-13 Thread steveweick
Good idea... I'll pass it along to the right folks. Meanwhile, if anyone has further questions or comments, please feel free to write me here (if they think the group would be interested) or at [EMAIL PROTECTED] Steve I would like to recommend that Encriq create a forum or mailing list of

Re: [sqlite] DeviceSQL

2007-12-13 Thread John Stanton
I unfortunately missed the Encirq webinar thanks to a project commitment but have taken the time to download the Encirq demo and try to make good the loss. It has some user examples in source code which give an idea of how it functions, but the information on the product is sparse so it was

Re: [sqlite] DeviceSQL

2007-12-13 Thread James Steward
steveweick wrote: Do you need to read the code to verify reliability as your next few sentences seems to imply? For that to be true, the reader would have to be able to spot bugs through inspection. While that is certainly one way to spot bugs, I seriously doubt that any shop would rely on code

[sqlite] Problems Insert with Date and Time values

2007-12-13 Thread Giuliano
Hello, is it possible (how?) to insert into 2 different fields (date) the following values: 09:30:00(only a time value...) 14/07/07 (only year value, 14th of december 2007) sorry, I am not be able at all to do that. Many thanks in advance for helping, Giuliano

Re: [sqlite] DeviceSQL

2007-12-13 Thread John Stanton
Testing only finds bugs, it does not guarantee accuracy. Careful design however can establish accuracy, and to verify that methodology requires examination of the source code. James Steward wrote: steveweick wrote: Do you need to read the code to verify reliability as your next few