Re: [sqlite] Can multi-column index optimize my operation?

On Thu, 2009-08-13 at 23:39 -0400, Igor Tandetnik wrote: > Kermit Mei wrote: > > The mostly useful SQL sentence is (MyDevId is known by user): > > > > SELECT * FROM KeyItem WHERE HomeDevId=MyDevId order by pageNum; > > > > Now, the items of this table may be more than 100,000 lines. If I use > >

Re: [sqlite] Can multi-column index optimize my operation?

Kermit Mei wrote: > The mostly useful SQL sentence is (MyDevId is known by user): > > SELECT * FROM KeyItem WHERE HomeDevId=MyDevId order by pageNum; > > Now, the items of this table may be more than 100,000 lines. If I use > the following Index, can it improve the previous query's speed? > >

[sqlite] Can multi-column index optimize my operation?

Hello, I have I table like this: CREATE TABLE KeyItem (icon_y int, icon_x int, id INTEGER PRIMARY KEY, pos_x int, pos_y int, size_x int, size_y int, type int, text varchar(15), icon varchar(50), background varchar(50), HomeDevId int, pageNum int); The mostly useful SQL sentence is (MyDevId is

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

2009/8/13 Simon Slavin : > > On 13 Aug 2009, at 12:47pm, Otto Grunewald wrote: > >> on the website at the following address: >> >> http://www.sqlite.org/c3ref/exec.html >> >> The second paragraph states the following: >> >> The error message passed back through the 5th

Re: [sqlite] SQLite version 3.6.17

On Thu, 13 Aug 2009, Mike Frysinger wrote: > On Thursday 13 August 2009 12:25:39 Hugh Sasse wrote: > > Well, I've found out why the tests aren't included in the amalgamated > > version. I think it is because it has taken over 5 hours to run the full > > test suite on the Solaris9 box I have,

Re: [sqlite] SQLJet - pure Java implementation of SQLite

Our approach in the 1980s was to make the compiler. Interestingly you mention a Databus to C product wich did not flourish (as one would expect for a translator).. We produced a complete Databus compiler to a target code like Java. This product sold well and is still viable thanks to the

Re: [sqlite] SQLJet - pure Java implementation of SQLite

I think you are talking "Open Source" world now. In the late 80's, early 90's things like Open Source Databas/Datashare compilers weren't even in anyone's dreams. What you saw was what you got. With no open source compilers to monkey with you just did what you had to, pretty or not. Somebody

Re: [sqlite] SQLJet - pure Java implementation of SQLite

In this situation it has been our approach to never try to translate source in one language into another. It is a pointlesss activity when you think about it. Much better to have the C or whatever compiler have a different code generator, for example Java target code. You are not rev locked

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

On 13 Aug 2009, at 12:47pm, Otto Grunewald wrote: > on the website at the following address: > > http://www.sqlite.org/c3ref/exec.html > > The second paragraph states the following: > > The error message passed back through the 5th parameter is held in > memory obtained from sqlite3_malloc(). To

Re: [sqlite] SQLite version 3.6.17

Well, I've found out why the tests aren't included in the amalgamated version. I think it is because it has taken over 5 hours to run the full test suite on the Solaris9 box I have, and they are not finished yet. I've not noticed any failures yet though; hopefully I can give a report tomorrow.

Re: [sqlite] [Delphi] Reading list of tables?

That's all you are suppose to get when querying the Master table for table names. You ask how to get a list of tables. That is what you got. What you are asking for now is more complex. Try: Select Name, SQL from "SQLite_master"; for even more fun try: Select * from "SQLite_master" Fred

[sqlite] Sqlite in multithread application fails the update query.

I have tested an archive under a multithread (32) application. Every thread appends a new record in a unique table. After the thread updates only own records. On exit the thread verifies that all own records are be updated but somethimes some records are not be updated correctly. The insert

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

Otto Grunewald wrote: > When an error message is returned by sqlite3_exec the documentation > states that you have to call sqlite3_free (sqlite3_free(void*)). > > My question is the following: > > Where do I get the void pointer from? You do sqlite3_free(errmsg), of course. Igor Tandetnik

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

Hello, It is on the website at the following address: http://www.sqlite.org/c3ref/exec.html The second paragraph states the following: The error message passed back through the 5th parameter is held in memory obtained from sqlite3_malloc(). To avoid a memory leak, the calling application

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

On Aug 13, 2009, at 7:27 AM, Otto Grunewald wrote: > > When an error message is returned by sqlite3_exec the documentation > states that you have to call sqlite3_free (sqlite3_free(void*)). > That sounds like a bug in the documentation. Where are you seeing this, exactly. I can't find it

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

Hello, I apologize for posting the message on the development mailing list. Yes, it was a mistake in transcribing the code : the line actually looks like this: sqlite3_open("/var/ptudata/ptu.db", _handle); I think I found the problem though. If you have a look at the while loop it was coded

[sqlite] 'database locked' error

Hello, I would like to pass cookies back and forth between a search script I have written that runs on the local system, and javascript pages displaying the forms and results in Firefox. I'll forego all the gory details here, it is working pretty well, but being able to pass cookies back and

Re: [sqlite] Error 14 - SQLITE_CANTOPEN

On Aug 13, 2009, at 5:30 AM, Otto Grunewald wrote: > Hello, > The following is what my code looks like : > sqlite3 *db_handle; > char* errmsg; > char cStr(255); > > sqlite3_open(_handle); > sqlite3_open() takes two parameters. Did you make a mistake in transcribing your code? D. Richard

Re: [sqlite] SQLite version 3.6.17

On Thu, 13 Aug 2009, Dan Kennedy wrote: > On Aug 13, 2009, at 4:58 PM, Hugh Sasse wrote: > > > Thanks. I think even if they don't change this, and they clearly > > have reasons for how things are, then clarity about maintenance > > would be useful. > > It works at present. It is tested

Re: [sqlite] SQLite version 3.6.17

On Aug 13, 2009, at 4:58 PM, Hugh Sasse wrote: > On Thu, 13 Aug 2009, Mike Frysinger wrote: > >> On Thursday 13 August 2009 05:04:26 Hugh Sasse wrote: >>> On Wed, 12 Aug 2009, Mike Frysinger wrote: On Monday 10 August 2009 11:51:40 Hugh Sasse wrote: > Make check doesn't do anything. My

Re: [sqlite] SQLite version 3.6.17

On Thu, 13 Aug 2009, Mike Frysinger wrote: > On Thursday 13 August 2009 05:04:26 Hugh Sasse wrote: > > On Wed, 12 Aug 2009, Mike Frysinger wrote: > > > On Monday 10 August 2009 11:51:40 Hugh Sasse wrote: > > > > Make check doesn't do anything. My reading of Makefile{,.in,.am} > > > > suggests

[sqlite] Error 14 - SQLITE_CANTOPEN

Hello, The following is what my code looks like : sqlite3 *db_handle; char* errmsg; char cStr(255); sqlite3_open(_handle); while (sqlite3_exec(db_handle, cStr, NULL, 0, ) != SQLITE_OK) { printf("sqlite3_exec: %s - retry cnt: %i\n", sqlite3_errmsg(db_handle), ++cnt);

[sqlite] Proprietary versus Open source ETL tools

Hi, As of today, we are still enjoying our Informatica tool but in a few months we will need to change. Basically we do not use our software at its full capacity and don't feel we need it anymore. So we are trying to find a less expensive solution that would have the same features (or

Re: [sqlite] SQLite version 3.6.17

On Wed, 12 Aug 2009, Mike Frysinger wrote: > On Monday 10 August 2009 11:51:40 Hugh Sasse wrote: > > On Mon, 10 Aug 2009, D. Richard Hipp wrote: > > > SQLite version 3.6.17 is now available on the SQLite website: > > [...] > > > This is the first release of SQLite after 100% branch test

Re: [sqlite] SQLJet - pure Java implementation of SQLite

En/na Simon Slavin ha escrit: > We no longer have the heritage of ubiquitous high-level languages. > Fortran, Pascal, Structured Basic, and everything like that have > gone. I don't know about the situation of fortran right now and I don't really care about basic, but pascal is alive and

Re: [sqlite] [Delphi] Reading list of tables?

On Tue, 11 Aug 2009 11:35:16 +0100, Simon Slavin wrote: >SELECT sql FROM sqlite_master WHERE type='table' Thanks Simon. To get only the name of the tables instead of the SQL command that was used to create them: SELECT tbl_name FROM sqlite_master WHERE