[sqlite] Thread safe in 3.2.5

I recently updated my system with the 3.2.5 version from 3.0.8. I configure with --enable-threadsafe because I use mutliple threads to access a single database. It had been working fine (it's the apr_dbd driver for the apr.apache.org project), but after the upgrade I started seeing "error 21".

Re: [sqlite] FAQ clarification

Thanks I filed this as Ticket 1431 and requested they add your diagram to lockingv3.html Sam Christian Smith wrote: >On Fri, 16 Sep 2005, Amin Azez wrote: > > > >>FAQ 7 >> >>(7) Can multiple applications or multiple instances of the same >>application access a single database file at the same

RE: [sqlite] determining number of 'used' pages?

Excellent! This is exactly what I am looking for. Thanks > -Original Message- > From: Dennis Jenkins [mailto:[EMAIL PROTECTED] > Sent: 16 September 2005 12:58 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] determining number of 'used' pages? > > > Mark Allan wrote: > > >Hi, > >

Re: [sqlite] sqlite on embedded board

Thank you, I'll try it! Áron > I can't tell what you've been doing, but probably > what you need to do is something like > > 1. Do all your work in the memory db, without > touching the flash db. > > 2. Then, just before you detach, update the flash > db with > > insert [or

Re: [sqlite] sqlite on embedded board

I can't tell what you've been doing, but probably what you need to do is something like 1. Do all your work in the memory db, without touching the flash db. 2. Then, just before you detach, update the flash db with insert [or replace] into flash.db ... select ... from

Re: [sqlite] FAQ clarification

Christian Smith wrote: I went through the link you had sent. This page mentions 5 different types of locks which are provided by the pager module in SQLite. Could you please clarify these 2 doubts - 1. My application uses our own Mutex variables to allow single reader/writer operation -

Re: [sqlite] Checkins 2694 and 2697 (order of columns in primary key)?

On Fri, 2005-09-16 at 07:34 -0400, Ned Batchelder wrote: > I saw checkin 2694 ("The table_info pragma now gives the order of columns in > the primary key"), and rejoiced. I currently have to parse the sql from > sqlite_master to dig up this information myself.Then came checkin 2697 > ("Undo

Re: [sqlite] How to load a SQLite schema from file using SQLite C-API

>I have SQLite schema in an ascii file. I would like to be able to load >this schema via SQLite C-API. How do I do this? You can look at the source code for the SQLite shell and see how it implements the .read command, but it may be simpler just to invoke the SQLite shell using system() or

[sqlite] Checkins 2694 and 2697 (order of columns in primary key)?

I saw checkin 2694 ("The table_info pragma now gives the order of columns in the primary key"), and rejoiced. I currently have to parse the sql from sqlite_master to dig up this information myself.Then came checkin 2697 ("Undo check-in [2694]"). What happened? --Ned.

Re: [sqlite] determining number of 'used' pages?

Mark Allan wrote: Hi, I am using SQLite on an embedded software product. The SQLite database file is saved and read from a NOR flash chip. We have found that the writing of data to this Flash chip can be quite slow. Therefore we need to minimise the writes that are made by SQLite. We have

[sqlite] Database corruption problem

Anybody who is using SQLite database files that exceed 1GiB should take note of ticket #1432. http://www.sqlite.org/cvstrac/tktview?tn=1432 The problem has been fixed in CVS. Following some additional testing, I will be releasing version 3.2.6. This will hopefully occur before Monday morning.

Re: [sqlite] FAQ clarification

Hi Ritesh, Please direct responses to the SQLite list, as others may be able to provide input as well. I'm a SQLite user as you are, not a one man SQLite support team:) Inline. On Fri, 16 Sep 2005, Ritesh Kapoor wrote: >Hi Christian, > >I went through the link you had sent. This page mentions

[sqlite] determining number of 'used' pages?

Hi, I am using SQLite on an embedded software product. The SQLite database file is saved and read from a NOR flash chip. We have found that the writing of data to this Flash chip can be quite slow. Therefore we need to minimise the writes that are made by SQLite. We have disabled the

Re: [sqlite] weird problem with windows 2000

On Thu, 15 Sep 2005, dan greene wrote: >I wrote a little program to test SQLITE3, essentially, a program to add 200 >records to a table called notes with one column, subject. >The loop I used to enter the rows is shown below: > >// time the additions >t1=clock(); >// add some rows

Re: [sqlite] FAQ clarification

On Fri, 16 Sep 2005, Amin Azez wrote: >FAQ 7 > >(7) Can multiple applications or multiple instances of the same >application access a single database file at the same time? > >Multiple processes can have the same database open at the same time. >Multiple processes can be doing a SELECT at the

[sqlite] FAQ clarification

FAQ 7 (7) Can multiple applications or multiple instances of the same application access a single database file at the same time? Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making