[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

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

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

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

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

On Thu, Jun 18, 2009 at 9:39 PM, Seysan 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 GetValue( String query ) { using (IDbCommand cmd = connection.CreateCommand()) {

[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] [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 , > , etc. or is it going to run one for each column in the > update

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] 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

[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] 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

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 >

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 >

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 wrote: > 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

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.

[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] 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

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" : > > 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

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

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] 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.

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] 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"

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" : > > On Jun 18, 2009, at 9:04 AM, galea...@korg.it wrote: > >> I updated

[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

[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

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

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] 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

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_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

[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-3.5.9: getting sqlite_autoindex error

2009/6/18 hiral : > 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

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

[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 && amt>0 ){ return SQLITE_CORRUPT_BKPT; } where rc is SQLITE_OK but

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

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

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

2009/6/17 hiral : > 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 >

[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