Re: [sqlite] SQLITE_CORRUPT - database disk image is malformed

On Apr 11, 2009, at 3:03 AM, Dave Toll wrote: > Hello list > > I am sometimes seeing the error SQLITE_CORRUPT with message > "database disk image is malformed", when I attempt CREATE TEMP > TRIGGER. My test spawns 5 threads, each of which modifies and > queries its own table in a common

Re: [sqlite] Joining 2 tables on 3 indexed columns?

Hi GüŸnther, > I need to join 2 tables A and B on 3 columns, ie. > > "select A.4, B5 where A1 = B1 and A2 = B2 and A3 = B3" > > the columns B1, B2, B3 are individually indexed, I also have an > index of > (B1,B2,B3). > The query is very slow, I don't understand why, can someone please > tell

[sqlite] Joining 2 tables on 3 indexed columns?

Hi, I need to join 2 tables A and B on 3 columns, ie. "select A.4, B5 where A1 = B1 and A2 = B2 and A3 = B3" the columns B1, B2, B3 are individually indexed, I also have an index of (B1,B2,B3). A has about 23000 rows and B about 17000. The query is very slow, I don't understand why, can

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

John Machin wrote: > On 16/03/2009 5:48 PM, Pierre Chatelier wrote: >>> A few hundred blocks of raw data? Blocksize approx 300K bytes? >>> Database >>> created and dropped by the same process? 500 blocks is approx 150M >>> bytes; why not keep it in a hash table in memory? If you keep it in a >>>

[sqlite] SQLITE_CORRUPT - database disk image is malformed

Hello list I am sometimes seeing the error SQLITE_CORRUPT with message "database disk image is malformed", when I attempt CREATE TEMP TRIGGER. My test spawns 5 threads, each of which modifies and queries its own table in a common database (each thread uses a separate connection from

Re: [sqlite] ANN - DBD::SQLite version 1.20

Alberto Simões wrote: > I was just wondering, is it a good idea to bundle SQLite in the Perl Module? > Wasn't it better to use the system version, if it is available? (well, > I think this isn't done as I have it on the system and DBD::SQlite > just compiled it...) This was discussed, and it was

Re: [sqlite] ANN - DBD::SQLite version 1.20

I was just wondering, is it a good idea to bundle SQLite in the Perl Module? Wasn't it better to use the system version, if it is available? (well, I think this isn't done as I have it on the system and DBD::SQlite just compiled it...) Cheers Alberto 2009/4/10 Alberto Simões

Re: [sqlite] "database table is locked" in sqlite_exec

Hello! On Friday 10 April 2009 16:23:43 D. Richard Hipp wrote: > On Apr 10, 2009, at 5:58 AM, Alexey Pechnikov wrote: > > Note: TCL interface binds all as text values > > False. The following TCL script is proof by counter-example: > > package require sqlite3 > sqlite3 db :memory: >

Re: [sqlite] question: how can I find which is the primary key columnfor a table inside the database?

"Gheorghita Suciu" wrote in message news:80bfa2aa0904090603o6a5b5b44uf0cda774631c0...@mail.gmail.com > I'm trying to find which column is the primary key column for a table > inside an sqlite database. PRAGMA table_info(tableName); Note that a primary key may be

Re: [sqlite] ANN - DBD::SQLite version 1.20

Hello. Thank you for this new update. Thanks for taking into consideration my request on collations. Yupy! On Thu, Apr 9, 2009 at 6:01 PM, Stefan Evert wrote: > Thanks a lot, Darren! > > This version also fixes the problems I've been having with segfaults > in the

Re: [sqlite] ANN - DBD::SQLite version 1.20

Thanks a lot, Darren! This version also fixes the problems I've been having with segfaults in the create_function test that I've been worried about. I've only tried version 1.22_02, but according to the change log, the bug was fixed before the public release of 1.20. Best, Stefan

[sqlite] question: how can I find which is the primary key column for a table inside the database?

Hello, I'm trying to find which column is the primary key column for a table inside an sqlite database. If anyone knows a way to achieve that, please reply. Thanks, Gicu ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] "database table is locked" in sqlite_exec

Hello! Note: TCL interface binds all as text values and we can't use typeof() function (typeof returns 'text' for all fields). So we may use manual cast() to field datatype instead. Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___

[sqlite] "database table is locked" in sqlite_exec

Hello! This function doesn't work: sqlite> select userkey_uninstall(); SQL error: database table is locked static void userkey_uninstallFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ sqlite3 *db; int rc; /* Result code */ const char

Re: [sqlite] "extension-functions.c" in windows mobile

I'm not familiar with MinGW and MSYS and with C/C++ in general. I don't know if a must do something special to build this dll for windows mobile application. Thibaut 2009/4/10 Jay A. Kreibich > On Thu, Apr 09, 2009 at 04:34:53PM +0200, Thibaut Gheysen scratched on the > wall: >

Re: [sqlite] "extension-functions.c" in windows mobile

On Thu, Apr 09, 2009 at 04:34:53PM +0200, Thibaut Gheysen scratched on the wall: > I have found the "extension-functions.c" in the > contrib page of the SQLite website but I'm not able to build it for windows > ce. Anybody can help me ? What specific problems are you having? I was able to

Re: [sqlite] "extension-functions.c" in windows mobile

Hi, Yes, it's a solution but I want to test the two approachs (in VB and in SQLite with an extension) to choice the faster. Before, I worked with VB6 and Access and the faster way is to use the calculation possibilities of Access. I want just try it with VB .Net and SQLite. But I'm not able to