[sqlite] Sqlite 14 (cant open database)

2007-04-24 Thread Lloyd
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

Re: [sqlite] test fixture tcl errors on Windows

2007-04-24 Thread Joe Wilson
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 +++

Re: [sqlite] test fixture tcl errors on Windows

2007-04-24 Thread Joe Wilson
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

2007-04-24 Thread Dennis Jenkins
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

[sqlite] Borland C++Builder linking issue

2007-04-24 Thread Scott Hill
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

2007-04-24 Thread Dennis Cote
[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

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

2007-04-24 Thread rhurst2
[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

Re: [sqlite] test fixture tcl errors on Windows

2007-04-24 Thread drh
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

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

2007-04-24 Thread Stephen Oberholtzer
(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] Can the memory usage of SQLite be adjusted?

2007-04-24 Thread drh
<[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

[sqlite] test fixture tcl errors on Windows

2007-04-24 Thread Dennis Cote
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?

2007-04-24 Thread rhurst2
[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 > >

[sqlite] Re: INSERT OR REPLACE without new rowid

2007-04-24 Thread Igor Tandetnik
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] Copy records from one DB to another

2007-04-24 Thread Dennis Cote
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 .table1 SELECT * FROM .table1 Yuriy,

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

2007-04-24 Thread drh
"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 .table1

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

2007-04-24 Thread drh
<[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

[sqlite] Copy records from one DB to another

2007-04-24 Thread Yuriy Martsynovskyy
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 .table1 SELECT * FROM .table1

Re: [sqlite] Increasing ATTACH_MAX

2007-04-24 Thread drh
"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

Re: [sqlite] Increasing ATTACH_MAX

2007-04-24 Thread Andrew Finkenstadt
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

[sqlite] INSERT OR REPLACE without new rowid

2007-04-24 Thread Trey Mack
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

2007-04-24 Thread drh
"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 >

[sqlite] changes() function discrepancy

2007-04-24 Thread Justin Fletcher
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);

[sqlite] Increasing ATTACH_MAX

2007-04-24 Thread Andrew Finkenstadt
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,

Re: [sqlite] An explanation?

2007-04-24 Thread Marco Bambini
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

Re: [sqlite] Fortran 95 Language Bindings

2007-04-24 Thread Arjen Markus
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