[sqlite] SQLite and GHS Integrity Issues

Christopher, Has anyone done a successful port of SQLite to the Integrity OS. Using their WLFS file system and nand flash, My company recently completed a commercial, production quality port and validation of SQLite on GHS Integrity for one of our customers. The database was stored on NAND

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009/6/17 hiral hiralsmaill...@gmail.com: Hi Simon,  I looked into it but couldn't find the exact reason for my bug.  If you have any idea please let me know. Sorry, other than the link, I can not help.  Also I would appreciate, if you can let me know what does this error mean in terms

Re: [sqlite] How to how many memory is used by sqlite

pierr wrote: pierr wrote: D. Richard Hipp wrote: On Jun 15, 2009, at 9:04 AM, pierr wrote: Hi all, I am using an memory type sqlite database in our embedded application. After the applicate run a while ,the system will run ourt of out of memory. So, is there a way

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

Hi Simon, Thank you for your quick reply. I am sorry for more general questions. As I mentioned I was getting corrupted db error with sqlite-3.5.9, but when I tried with sqlite-3.6.4 it is no more corrupting the db. -- so was it a bug with sqlite-3.5.9 ? and got fixed in sqlite-3.6.4 -- is it

[sqlite] SQLITE_CORRUPT error

I updated sqlite version from 3.6.14 to 15, now when I try to run a C++ code to fill the database I have SQLITE_CORRUPT error. This error happens in the accessPayload method (btree.c) in the condition if( rc==SQLITE_OK amt0 ){ return SQLITE_CORRUPT_BKPT; } where rc is SQLITE_OK but amt =

Re: [sqlite] Asynchronous I/O Module For SQLite

I'm actually memory limited, which is why I am looking at moving infrequently needed object to persistent store with sqlite3. I like the idea of using the asynchronous i/o module so that the writing can be done in a background thread, but still allow the main thread to retrieve data that has

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009/6/18 hiral hiralsmaill...@gmail.com: Hi Simon, Thank you for your quick reply. I am sorry for more general questions. As I mentioned I was getting corrupted db error with sqlite-3.5.9, but when I tried with sqlite-3.6.4 it is no more corrupting the db. -- so was it a bug with

[sqlite] SQLite Database schema has changed error

Hi, I am using SQLite 3.6.13, After issuing a vaccuum, I am inserting into the SQLite db, that time I am getting SQLite Database schema has changed error. According to this: http://www.mail-archive.com/sqlite-users@sqlite.org/msg04902.html, It should never occur in SQLite 3.0, but I am not

Re: [sqlite] SQLITE_CORRUPT error

On Jun 18, 2009, at 9:04 AM, galea...@korg.it wrote: I updated sqlite version from 3.6.14 to 15, now when I try to run a C++ code to fill the database I have SQLITE_CORRUPT error. New logic was added to version 3.6.15 to detect database corruption sooner. What happens when you run PRAGMA

Re: [sqlite] Asynchronous I/O Module For SQLite

On Jun 18, 2009, at 9:15 AM, Rizzuto, Raymond wrote: I'm actually memory limited, which is why I am looking at moving infrequently needed object to persistent store with sqlite3. I like the idea of using the asynchronous i/o module so that the writing can be done in a background

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

On 18/06/2009 10:40 PM, hiral wrote: Hi Simon, Thank you for your quick reply. I am sorry for more general questions. As I mentioned I was getting corrupted db error with sqlite-3.5.9, was getting error often or did get error ONCE?? but when I tried with sqlite-3.6.4 it is no more

Re: [sqlite] SQLite Database schema has changed error

On Jun 18, 2009, at 9:22 AM, manohar s wrote: Hi, I am using SQLite 3.6.13, After issuing a vaccuum, I am inserting into the SQLite db, that time I am getting SQLite Database schema has changed error. According to this:

Re: [sqlite] Asynchronous I/O Module For SQLite

I tried the pragma synchronous=off. It has no significant effect on db on an nfs mounted file system, but does improve access to a db on a local file system. I still would like to compare the pragma to the asynchronous i/o module, if the latter is still supported. -Original

[sqlite] Questions from a new user

Hello everyone, I'm in the process of writing some C++ wrappers to SQLite in order to shoehorn it into some legacy code. I'm curious if there is any performance impact to having several prepared statements active at any given time. I was thinking about using a prepared statement

[sqlite] sqlite3_auto_extension

Hi, Having spent some time trying to have this function work with dll extensions, I've come to the [I hope 'wrong'] conclusion that it's unusable in such case. Indeed, the docs mentions statically linked extension. Can someone confirm it won't auto load extensions when they reside in

Re: [sqlite] SQLITE_CORRUPT error

I run PRAGMA integrity_check using version 3.6.14 at the end of the code and it executed a query with only one row ok, so where do I have to send the databbase? Thanks Citando D. Richard Hipp d...@hwaci.com: On Jun 18, 2009, at 9:04 AM, galea...@korg.it wrote: I updated sqlite version

Re: [sqlite] SQLITE_CORRUPT error

On Jun 18, 2009, at 11:01 AM, galea...@korg.it wrote: I run PRAGMA integrity_check using version 3.6.14 at the end of the code and it executed a query with only one row ok, so where do I have to send the databbase? d...@sqlite.org Thanks Citando D. Richard Hipp d...@hwaci.com: On Jun

Re: [sqlite] SQLITE_CORRUPT error

On Jun 18, 2009, at 9:04 AM, galea...@korg.it wrote: I updated sqlite version from 3.6.14 to 15, now when I try to run a C++ code to fill the database I have SQLITE_CORRUPT error. Works fine when I run it with your database. I cannot access any of the indices, though, since I lack the

Re: [sqlite] Questions from a new user

Shaun Seckman (Firaxis) wrote: Hello everyone, I'm in the process of writing some C++ wrappers to SQLite in order to shoehorn it into some legacy code. I'm curious if there is any performance impact to having several prepared statements active at any given time. That

Re: [sqlite] SQLITE_CORRUPT error

On Jun 18, 2009, at 9:04 AM, galea...@korg.it wrote: I updated sqlite version from 3.6.14 to 15, now when I try to run a C++ code to fill the database I have SQLITE_CORRUPT error. Even with your new database that uses NOCASE in place of KORGCOLLATE, I don't have any problems. What query,

Re: [sqlite] Asynchronous I/O Module For SQLite

On 18 Jun 2009, at 2:15pm, Rizzuto, Raymond wrote: I'm actually memory limited, which is why I am looking at moving infrequently needed object to persistent store with sqlite3. I like the idea of using the asynchronous i/o module so that the writing can be done in a background thread,

Re: [sqlite] SQLITE_CORRUPT error

This statement is giving me truoble: INSERT INTO PlayList_Song(id_song, id_playlist, song_number) VALUES (5235, 9, 256) Citando D. Richard Hipp d...@hwaci.com: On Jun 18, 2009, at 9:04 AM, galea...@korg.it wrote: I updated sqlite version from 3.6.14 to 15, now when I try to run a C++ code

Re: [sqlite] SQLITE_CORRUPT error

On Jun 18, 2009, at 12:36 PM, galea...@korg.it wrote: This statement is giving me truoble: INSERT INTO PlayList_Song(id_song, id_playlist, song_number) VALUES (5235, 9, 256) That INSERT statement works fine for me. Did you try recompiling with optimizations turned off? D. Richard Hipp

[sqlite] listing tables in a database

I'm looking for a way to programmatically get a list of all tables in an SQLite database -- effectively emulating the .tables command but using the C API calls. I've been through the documentation but couldn't find anything. I'm hoping someone on his list might be able to point me in the

Re: [sqlite] Asynchronous I/O Module For SQLite

Simon, I appreciate your input, but I don't think I have provided enough details on the constraints my application has to meet for you to evaluate whether asynch i/o is a good solution or not for me. I don't think it is practical for me to get into that level of detail, even if I wanted to.

Re: [sqlite] listing tables in a database

SELECT name, sql FROM sqlite_master WHERE type='table' On Thu, Jun 18, 2009 at 12:47 PM, Gary Johnson gary.john...@covad.netwrote: I'm looking for a way to programmatically get a list of all tables in an SQLite database -- effectively emulating the .tables command but using the C API calls.

Re: [sqlite] sqlite3_auto_extension

On Thu, Jun 18, 2009 at 04:53:13PM +0200, Jean-Christophe Deschamps wrote: Having spent some time trying to have this function work with dll extensions, I've come to the [I hope 'wrong'] conclusion that it's unusable in such case. Indeed, the docs mentions statically linked extension. Can

Re: [sqlite] Questions from a new user

On Jun 18, 2009, at 9:50 PM, Shaun Seckman (Firaxis) wrote: Hello everyone, I'm in the process of writing some C++ wrappers to SQLite in order to shoehorn it into some legacy code. I'm curious if there is any performance impact to having several prepared statements active

Re: [sqlite] Asynchronous I/O Module For SQLite

On Jun 18, 2009, at 11:45 PM, Rizzuto, Raymond wrote: Simon, I appreciate your input, but I don't think I have provided enough details on the constraints my application has to meet for you to evaluate whether asynch i/o is a good solution or not for me. I don't think it is practical

[sqlite] Duplicating an sqlite3_stmt

Is there any way to duplicate a sqlite3_stmt instance? I like being able to prepare and cache multiple statements but since the results are also tied into the statement structure, I'd like to be able to duplicate the statement to be used in another query. My only reasoning for doing this is to

Re: [sqlite] Duplicating an sqlite3_stmt

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shaun Seckman (Firaxis) wrote: Is there any way to duplicate a sqlite3_stmt instance? Call sqlite3_sql to get the original SQL text and then call prepare on that. http://sqlite.org/c3ref/sql.html My only reasoning for doing this is to bypass

Re: [sqlite] Asynchronous I/O Module For SQLite

Thanks for the answers. I did give compiling with 3.5.9 a try, but it looks like the changes in vfs are too great: sqlite3async.c: In function `asyncOpen': sqlite3async.c:1019: warning: initialization from incompatible pointer type sqlite3async.c: In function `asyncAccess': sqlite3async.c:1182:

Re: [sqlite] [noob] merge statement equivalent?

James Gregurich wrote: on that update statement, is the SQL optimizer smart enough to not rerun that select statement for each column in the update's set clause? Is it going to run a single select statement to get value1, value2, etc. or is it going to run one for each column in the

[sqlite] Reading Blob to file in C#

Hello, I've asked this question on Ssystem.Data.SQlite Forum, and after 2 days not even 1 Reply ! How can I read a blob column in C#? I have tried 4 different ways, so far no success. Does anyone have any sample code? or at least any documentation on this ???

Re: [sqlite] Reading Blob to file in C#

On Thu, Jun 18, 2009 at 9:39 PM, Seysanafsh...@gmail.com wrote: How can I read a blob column in C#? I just checked my code and this is what I use minus various infrastructure bits: public T GetValueT( String query ) { using (IDbCommand cmd = connection.CreateCommand()) {

Re: [sqlite] Database inserts gradually slowing down

Jay A. Kreibich wrote: On Wed, Jun 17, 2009 at 11:52:45AM +1000, John Machin scratched on the wall: On 17/06/2009 6:17 AM, Hoover, Jeffrey wrote: One other note, if you have a primary key whose value is continually increasing your pk index can become imbalanced and therefore

Re: [sqlite] Database inserts gradually slowing down

Jens Páll Hafsteinsson wrote: Here's the code I'm using to run the test (it includes the schema). I've been running this code for the last few days and am a bit baffled about my recent results, since I'm not seeing the gradual slowing anymore. This happened after I changed to use version

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

Hi Simon / John, Thank you for replies. You are able to repeatably corrupt the db under SQLite 3.5.9? It would be worthwhile publishing a script that can do that. was getting error often or did get error ONCE?? I am running application which uses the db over the NFS. If I move the db over

[sqlite] Reading Blob to file in C#

YOU ARE a LIFE SAVER man! it worked! Thank you so very much! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users