[sqlite] Converting 2.8.x database file into 3.x database file

2004-08-10 Thread sankara . narayanan
Hi, In the webpage (http://www.sqlite.org/version3.html), it is mentioned that for converting the 2.8.x database file into 3.0 database file, the command line shell is available both in 2.8 and 3.0. I find that the command as mentioned there works with 2.8 executable. But I tried it with the 3.

Re: [sqlite] precompiled SQL and transactions

2004-08-10 Thread Dennis Cote
Michael Roth wrote: > Exists the same error in the sqlite3_prepare call? Anybody validated > this? I just tested this with SQLite V3.0 and it does not display this quirk. I get the same performance using a statement that is prepared inside a transaction and one that is prepared outside a transacti

[sqlite] Deadlock when doing threaded updates and inserts

2004-08-10 Thread Dave Hayden
I'm running into a deadlock, as the subject says, when doing updates on a table in one thread while another thread is inserting into the same table. (Oh, and this is on 3.0.4, compiled with --enable-threadsafe) The update thread returns from its UPDATE command (within a transaction) with SQLITE

Re: [sqlite] Database locked

2004-08-10 Thread Mauricio Piacentini
> I am trying to import a csv file (ip-to-country to be especific) to a > table > on sqlite db...It has 5+ lines. Tried to use php and it takes like If you are using SQLite 2.8.x you can try importing the file with SQLite Database Browser (sqlitebrowser.sourceforge.net). Use the FILE->IMPORT->

Re: [sqlite] SQLite DB synchronization

2004-08-10 Thread John LeSueur
John Oliva wrote: Are any of you performing synchronization between multiple SQLite DBs? What tools or techniques are you using? Thanks, John Oliva That's something I'd be interested in as well. At the moment, we are using a system where each table to be synchronized has at least the follow

[sqlite] Database locked

2004-08-10 Thread Felipe Lopes
Hi there! I am trying to import a csv file (ip-to-country to be especific) to a table on sqlite db...It has 5+ lines. Tried to use php and it takes like 10 minutes loading and returns that the database is locked...When I take a look at the table, it has only 9000 entries... I would like t

[sqlite] SQLite DB synchronization

2004-08-10 Thread John Oliva
Are any of you performing synchronization between multiple SQLite DBs? What tools or techniques are you using? Thanks, John Oliva

Re: [sqlite] Compiling Linux SQLite with thread safe

2004-08-10 Thread Matthias Watermann
On Mon, 09 Aug 2004 14:42:32 -0500, Corwin Burgess wrote: > make-sqlite: line 26: mak: command not found > > mak# .. output of 'make' through 'tee' to produce a logfile > > looks ok until line 30 > > make-sqlite: line 30: tidy: command not found > > I believe this is fixed as I downloa

Re: [sqlite] [sqlite - lemon] gcc -Wall -W lemon

2004-08-10 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: lemon is an excellent parser generator. Is there a way to fix the gcc warnings? The parser code, created from the lemon parser generator, throws a few warnings between signed and unsigned integers. The template for the generated code is a file named "lempar.c". Find the

[sqlite] [sqlite - lemon] gcc -Wall -W lemon

2004-08-10 Thread sporkey
lemon is an excellent parser generator. Is there a way to fix the gcc warnings? The parser code, created from the lemon parser generator, throws a few warnings between signed and unsigned integers. Agreed. This is not debilitating. However, since the parser code is often added to a larger progr

[sqlite] SQLRelay .35 with v3 support

2004-08-10 Thread Hihn, Jason
Just a FYI: SQLRelay has integrated SQLite v3 support into the release. SQLRelay is a proxy for databases, and with SQLite, it can give network access via the SQLRelay APIs (C/C++, lots of others) Release Announcement: "SQL Relay version 0.35 is out... It's been a long time coming, but no

[sqlite] Email Group Support Please

2004-08-10 Thread EzTools Support
Hello. I seem to be in the database twice - I'm getting each email twice. Can the person in charge of the emailer please take care of this. Thank you -- try IeToolbox Passwords & Notes Keeper, Form Filler and much more www.ietoolbox.com

[sqlite] BLOBs and Encoding

2004-08-10 Thread EzTools Support
Hello all. Does 3.x support BLOBs without encoding (via API) or do we need to encode it and use SQL INSERT? Also, I can't find any 8859 macros - is it only UTF-8 now? TIA for the help

[sqlite] newbe questions for sqlite 2.8.15 used by tcl

2004-08-10 Thread Finzel Stefan
Hello! after a long time i came back to have a look at sqlite again. As a sql database running on Linux and Windows without additional installation required (just packaging the other tcl stuff and running out of the box) it is totally fullfilling my needs. I assume it is running at SunOS, HP-UX a