Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation

2008-05-15 Thread qinligeng
The sqlite3_analyzer-3_5_4 also crash when analyzing my DB: AppName: sqlite3_analyzer.exe AppVer: 0.0.0.0 ModName: sqlite3_analyzer.exe ModVer: 0.0.0.0 Offset: 00028c72 sqlite3 (3.5.9) crash when excute PRAGMA integrity_check: AppName: sqlite3.exe AppVer: 0.0.0.0 ModName: sqlite3.exe ModVer:

Re: [sqlite] SQLite version 3.5.9

2008-05-15 Thread ajm
On Wed, May 14, 2008 at 3:40 PM, Jay A. Kreibich [EMAIL PROTECTED] wrote: WORKAROUNDS: Or, brute force: Copy the file locally, do your stuff, copy it back. Looks like the brute force solution is the only answer here. (Translated automatically from the Spanish original) ... There is a

Re: [sqlite] SQLite remote management tools?

2008-05-15 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard Klein wrote: Are there any GUI-based tools that provide management of a remote SQLite database? SQLite is an in process database and only provides code that ultimately calls the operating system's open/read/write/lock/close methods. There

[sqlite] Is this Sorting order right?

2008-05-15 Thread Mahalakshmi.m
typedef struct {   unsigned short s8_ArtistName[256];   }STRUCT_SQLITE_MY_RECORD;  UINT32   u32_Return;  const UINT16 *u16_SearchResult;  STRUCT_SQLITE_MY_RECORD st_SQLITE_DB_Record; sqlite3* db;  sqlite3_stmt*

Re: [sqlite] import files with more than 2GB?

2008-05-15 Thread Michael Lackhoff
On 6 May 2008 at 16:10, Dan wrote: On May 6, 2008, at 3:38 PM, Michael Lackhoff wrote: On 5 May 2008 at 11:50, D. Richard Hipp wrote: The code to do an import is not part of the core SQLite, btw. It is part of the CLI. You can find the code by searching for import in the shell.c

Re: [sqlite] SQLite3 C API question

2008-05-15 Thread P Kishor
On 5/15/08, Jon Dixon [EMAIL PROTECTED] wrote: I am a Perl programmer, and I am trying to update the DBD::SQLite package to use version 3 rather than version 2 of SQLite (somehow it doesn't seem that anyone else has done this yet). eh. Doesn't see that you have really looked around. See

Re: [sqlite] Is this Sorting order right?

2008-05-15 Thread Igor Tandetnik
Mahalakshmi.m [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I will call this loop 2 times for inserting 2 records at run time. Which part of the exact code is difficult to understand? Can you post the code that I can copy, paste, compile, run and see the results for myself? You

Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation

2008-05-15 Thread Dennis Cote
[EMAIL PROTECTED] wrote: Maybe the database has been damaged. Possibly. The shcema of table CarImages is : CREATE TABLE CarImages( CarID char(32) NOT NULL, CarNumber char(20) NULL, OpTime datetime NOT NULL , TSCode char(6) NOT NULL, LaneNum int NOT NULL, PicBigPlate Long null,

Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation

2008-05-15 Thread Dennis Cote
[EMAIL PROTECTED] wrote: My DB file is too big, how can I provide it to your guys? You said a compressed copy of the database file is 18M. One possibility is to create a bug report ticket at http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew and attach the compressed database file to

[sqlite] Perf improvements in 3.5.9

2008-05-15 Thread Mark Spiegel
The release notes for 3.5.9 indicate that performance improvements have been made around the way integers are stored. Performance enhancement: Reengineer the internal routines used to interpret and render variable-length integers. Can someone in dev add some color to this statement? What

Re: [sqlite] sqlite3_finalize vs sqlite3_closed

2008-05-15 Thread Igor Tandetnik
Joanne Pham [EMAIL PROTECTED] wrote: Should Iuse sqlite3_finalize or sqlite3_closed after I am done with reading/write to the database. You should call sqlite3_finalize on all prepared statements, then sqlite3_close on the database handle. Igor Tandetnik

[sqlite] sqlite3_finalize vs sqlite3_closed

2008-05-15 Thread Joanne Pham
Hi All,  Should Iuse sqlite3_finalize or sqlite3_closed after I am done with reading/write to the database. Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Perf improvements in 3.5.9

2008-05-15 Thread Shane Harrelson
The format of the varints in the DB were not changed.For Varint32s, the macro support was cleaned up and changes made to use it consistently. The MACROs inline the single byte case, so code for this was disabled in the actual function. The actual functions were re-implemented to utilize

Re: [sqlite] SQLite remote management tools?

2008-05-15 Thread Richard Klein
Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard Klein wrote: Are there any GUI-based tools that provide management of a remote SQLite database? SQLite is an in process database and only provides code that ultimately calls the operating system's

Re: [sqlite] SQLite remote management tools?

2008-05-15 Thread Federico Granata
I was hoping there might be a client/server management tool out there. I would need the source code, since the server part would need to be ported to my embedded device. Maybe you haven't yet read this http://www.sqlite.org/serverless.html There isn't a sqlite server so you can't have a

Re: [sqlite] SQLite remote management tools?

2008-05-15 Thread Richard Klein
Federico Granata wrote: I was hoping there might be a client/server management tool out there. I would need the source code, since the server part would need to be ported to my embedded device. Maybe you haven't yet read this http://www.sqlite.org/serverless.html There isn't a sqlite server

[sqlite] Locking causing exponentially degraded peformance with multiple processes

2008-05-15 Thread Samuel Neff
We're running into a lot of very slow queries and db locks when running with multiple processes accessing the same database. As a test we created a small application that has only two threads and a small single table database. RunRead reads all data from the one table (100 records). RunWrite

[sqlite] Finding Missing Table Rows

2008-05-15 Thread Rich Shepard
I'm embarrassed to have to ask for help on this query, but I am not finding the solution in my local references (Celko's SQL for Smarties, 3rd ed, van der Lans' Introduction to SQL, 4th ed) or by searching for Google. I have two tables that should have the same number of rows, but one is 2

Re: [sqlite] Finding Missing Table Rows

2008-05-15 Thread Darren Duncan
Rich Shepard wrote: I have two tables that should have the same number of rows, but one is 2 rows short and I'm trying to identify which rows exists in the first table (Fuzzyset) that's missing from the second table (Rules). I thought that a right outer join might work with NOT EXISTS

Re: [sqlite] Finding Missing Table Rows

2008-05-15 Thread Gerry Snyder
Darren Duncan wrote: Clue stick coming up. There's a much simpler solution. You should be using relational difference instead, the MINUS keyword, whose syntax is the same as UNION but for the keyword. I think maybe you mean EXCEPT, not MINUS. Gerry

Re: [sqlite] Finding Missing Table Rows

2008-05-15 Thread Darren Duncan
Gerry Snyder wrote: Darren Duncan wrote: Clue stick coming up. There's a much simpler solution. You should be using relational difference instead, the MINUS keyword, whose syntax is the same as UNION but for the keyword. I think maybe you mean EXCEPT, not MINUS. Gerry Yes,