Re: [sqlite] Fortran 95 Language Bindings

Liam Healy wrote: Arjen, Thank you for attentive maintenance and development on this valuable interface. Thanks, Gary's and your interest in a Fortran wrapper were enough to revive my activities in this area. With the documentation (almost) completed, I guess it is time to add the link to

Re: [sqlite] An explanation?

Thanks a lot for the explanation Dennis, I really appreciate. --- Marco On Apr 24, 2007, at 12:35 AM, Dennis Cote wrote: Marco Bambini wrote: Database is uniformly distributed, I created it ad hoc just for my test (sqlite 3.3.12): Marco, Another way to think of this is that if your

[sqlite] Increasing ATTACH_MAX

I'm exploring what it would take to support more than 10 attached databases within one SQLite connection object. It appears that the change will be rather simple: ATTACH_MAX can be made as high as 30 without further issues, given the writeMask and cookieMask field's bit width being 32 bits,

[sqlite] changes() function discrepancy

Hiya, I'm examining the test suite and I'm trying to reproduce the results for test laststmtchanges-1.1 (and friends). This test creates and populates a small database as follows : create table t0 (x); insert into t0 values (1); insert into t0 values (1);

Re: [sqlite] Increasing ATTACH_MAX

Andrew Finkenstadt [EMAIL PROTECTED] wrote: I'm exploring what it would take to support more than 10 attached databases within one SQLite connection object. It appears that the change will be rather simple: ATTACH_MAX can be made as high as 30 without further issues, given the writeMask

[sqlite] INSERT OR REPLACE without new rowid

Hello all, I'd like to perform an update to a row if it exists (uniquely identified by 3 text columns), otherwise insert a new row with the right data. INSERT OR REPLACE looks good, but it generates a new primary key each time there is a conflict. If the row exists, I need to keep the

Re: [sqlite] Increasing ATTACH_MAX

On 4/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Andrew Finkenstadt [EMAIL PROTECTED] wrote: I'm exploring what it would take to support more than 10 attached databases within one SQLite connection object. It appears that the change will be rather simple: ATTACH_MAX can be made as

Re: [sqlite] Increasing ATTACH_MAX

Andrew Finkenstadt [EMAIL PROTECTED] wrote: I did not research how prepared statements have their vdbe opcodes serialized or stored, and whether those opcodes depend on the size of the Parse structure, whose size would be changing by bumping the writeMask or cookieMask fields from u32 to

[sqlite] Copy records from one DB to another

What is the best way to copy records between tables located in different DB files? Both DBs have completely the same structure. I need to add records from table in DB1 to table in DB2. Logically something like this: INSERT INTO db1.table1 SELECT * FROM db2.table1

Re: [sqlite] Can the memory usage of SQLite be adjusted?

[EMAIL PROTECTED] wrote: I completed my analysis of the SQLite database memory usage and I was surprised to find that SQLite consumes so much memory. I ran my test case (creates 31 tables) and found that SQLite consumed 545,231 bytes of malloced memory before it started giving it back.

Re: [sqlite] Copy records from one DB to another

Yuriy Martsynovskyy [EMAIL PROTECTED] wrote: What is the best way to copy records between tables located in different DB files? Both DBs have completely the same structure. I need to add records from table in DB1 to table in DB2. Logically something like this: INSERT INTO db1.table1 SELECT

Re: [sqlite] Copy records from one DB to another

Yuriy Martsynovskyy wrote: What is the best way to copy records between tables located in different DB files? Both DBs have completely the same structure. I need to add records from table in DB1 to table in DB2. Logically something like this: INSERT INTO db1.table1 SELECT * FROM db2.table1

[sqlite] Re: INSERT OR REPLACE without new rowid

Trey Mack [EMAIL PROTECTED] wrote: I'd like to perform an update to a row if it exists (uniquely identified by 3 text columns), otherwise insert a new row with the right data. INSERT OR REPLACE looks good, but it generates a new primary key each time there is a conflict. If the row exists, I

Re: [sqlite] Can the memory usage of SQLite be adjusted?

[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I completed my analysis of the SQLite database memory usage and I was surprised to find that SQLite consumes so much memory. I ran my test case (creates 31 tables) and found that SQLite consumed 545,231 bytes of malloced memory

[sqlite] test fixture tcl errors on Windows

I'm getting a strange failure of the test suite on Windows (XP all updates). The exclusive2 test is getting a permission denied error when deleting a file. I can manually delete the file and the tclsh can execute the same file delete command if I enter it manually. $ ./testfixture.exe

Re: [sqlite] Can the memory usage of SQLite be adjusted?

[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I completed my analysis of the SQLite database memory usage and I was surprised to find that SQLite consumes so much memory. I ran my test case (creates 31 tables) and found that SQLite consumed 545,231

[sqlite] [patch] Improve performance of UPDATE/DELETE against views

(I sent an e-mail to the list, and got a nice response, although it didn't really say where I should send enhancement patches. So I'm sending this one here, in the hopes that at least one person will comment on it.) Currently, the implementation of 'update' and 'delete' for views is such that

Re: [sqlite] test fixture tcl errors on Windows

Dennis Cote [EMAIL PROTECTED] wrote: I'm getting a strange failure of the test suite on Windows (XP all updates). exclusive2-2.8... Ok c:\SQLite\SQLiteV3\build\testfixture.exe: error deleting test.db: permission denied while executing file delete -force test.db

Re: [sqlite] Can the memory usage of SQLite be adjusted?

[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I completed my analysis of the SQLite database memory usage and I was surprised to find that SQLite consumes so much memory. I ran my test case (creates 31 tables)

Re: [sqlite] test fixture tcl errors on Windows

[EMAIL PROTECTED] wrote: My guess is that your virus scanning software is opening the test.db file as sson as SQLite closes it, in order to check it for new viruses. The test script tries to delete the file right after closing it, but it can't because the virus scanner has it open. I don't

[sqlite] Borland C++Builder linking issue

Hello, First time on this list. I am trying to get sqlite into an app using Borlands C++Builder. I have included the sqlite3.h file and the code compiles. However, when it tries to link I get an unresolved external for sqlite3_open, etc. Does anyone have any experience using C++Builder?

Re: [sqlite] test fixture tcl errors on Windows

Dennis Cote wrote: I don't know enough TCL to know if there is a subtle bug here or not. I suspect that perhaps the file isn't really being closed until the script exits.Does this seem possible? Dennis Cote Get filemon from www.sysinternals.com. Set a filter to monitor all files in the

Re: [sqlite] test fixture tcl errors on Windows

The test script itself has the test.db open, and as result Windows cannot delete an open file. It worked on UNIX because you can delete anything at any time whether it is open, running, locked or whatever. If you apply this patch, exclusive2.test will run to completion on cygwin without error.

Re: [sqlite] test fixture tcl errors on Windows

a better patch... Index: test/exclusive2.test === RCS file: /sqlite/sqlite/test/exclusive2.test,v retrieving revision 1.4 diff -u -3 -p -r1.4 exclusive2.test --- test/exclusive2.test16 Apr 2007 15:02:20 - 1.4 +++

[sqlite] Sqlite 14 (cant open database)

Hi, I am working on Redhat EL4, with sqlite3. In my application (written in C++ and wxWidgets, and I use wxSqlite3 wrapper) there a module which will be called repeatedly which in turn opens and closes the database each time the module is called. When the application runs (process the input) for