Re: [sqlite] New SQLite 3.x C++ Wrapper

> I have updated my SQLite 3.x C++ wrapper (at > http://dev.int64.org/sqlite.html). What do you think of the idea of handling SQLITE_SCHEMA internally instead of throwing an exception? __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check

RE: [sqlite] Query on multiple tables

Hi Marc-André, That's a much better way of doing this. Thanks! Martin P.S. Tes salutations sont rendues! -Original Message- From: Marc-Andre Gosselin [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 19:47 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Query on multiple

RE: [sqlite] How to Lock other threads out of DB until specifical ly UNlocking the DB?

Why not use a mutex around your database code in your program? -Original Message- From: de f [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 9:58 AM To: sqlite-users@sqlite.org Subject: [sqlite] How to Lock other threads out of DB until specifically UNlocking the DB? I need to

[sqlite] How to Lock other threads out of DB until specifically UNlocking the DB?

I need to Lock the entire DB from one process (locking other processes out), and Mainitain that lock until I specifically UNlock the DB. The automatic locking of Transactions in sqlite does not give me direct control and is of no use to me (those locks go away automatically, leaving me no control

Re: [sqlite] transient SQLITE_CORRUPT

From everything I've read, I would have thought this was the case. But in practice I have been seeing transient SQLITE_CORRUPT errors. I tried "pragma integrity_check" and it said ok. I'm running my app on an embedded linux machine. The db is in ramdisk and I'm using TEMP_STORE=3, so

Re: [sqlite] How to Lock other threads out of DB until specifically UNlocking the DB?

On Jun 17, 2005, at 9:57 AM, de f wrote: The automatic locking of Transactions in sqlite does not give me direct control and is of no use to me (those locks go away automatically, leaving me no control over them.) Are you sure? Have you investigated BEGIN EXCLUSIVE?

Re: [sqlite] How to Lock other threads out of DB until specifically UNlocking the DB?

On Jun 17, 2005, at 10:52 AM, [EMAIL PROTECTED] wrote: Yes, a BEGIN EXCLUSIVE does lock it, but then as soon as I do some other SQL, it automatically UN LOCKS the db unfortunately. I need to keep it locked until I unlock it. I'm not sure I believe you :) I would assume the database would

Re: [sqlite] How to Lock other threads out of DB until specifically UNlocking the DB?

Ok, you're right, BEGIN EXCLUSIVE does lock the file and keep it locked until COMMIT or ROLLBACK. However, I need transactions for other purposes, as my process is running it will need to BEGIN and COMMIT/ROLLBACK transactions all the while holding the lock on the file. Will Leshner <[EMAIL

Re: [sqlite] How to Lock other threads out of DB until specifically UNlocking the DB?

On Jun 17, 2005, at 11:18 AM, [EMAIL PROTECTED] wrote: However, I need transactions for other purposes, as my process is running it will need to BEGIN and COMMIT/ROLLBACK transactions all the while holding the lock on the file. Ah. You were hoping the transactions would be nested? That is

Re: [sqlite] How to Lock other threads out of DB until specifically UNlocking the DB?

True, so it would be great if there were a way to Lock the File aside from using Transactions to do so. Perhaps some windows API, or any other way? Will Leshner <[EMAIL PROTECTED]> wrote on 06/17/2005 02:21:58 PM: > > On Jun 17, 2005, at 11:18 AM, [EMAIL PROTECTED] wrote: > > > However, I need

[sqlite] Write performance

SQLite write (insert) performance doesn't seem very good to me so I'm trying to find ways to improve it in my application. I had this idea so I figured I'd run it past you folks who likely better know how the db works under the hood. My thought is that perhaps the write performance

Re: [sqlite] Write performance

On 6/17/05, Sean Heber <[EMAIL PROTECTED]> wrote: > SQLite write (insert) performance doesn't seem very good to me so I'm > trying to find ways to improve it in my application. I had this idea > so I figured I'd run it past you folks who likely better know how the > db works under the hood. did

Re: [sqlite] Write performance

are you using a transaction? if not, go read the wiki. On 6/17/05, Sean Heber <[EMAIL PROTECTED]> wrote: > SQLite write (insert) performance doesn't seem very good to me so I'm > trying to find ways to improve it in my application. I had this idea > so I figured I'd run it past you folks who

Re: [sqlite] Write performance

On Fri, 2005-06-17 at 14:02 -0500, Sean Heber wrote: > I've been inserting data into a table with a non-integer primary > key. The data does not come in in an ordered fashion. My thought is > that perhaps performance suffers because it needs to rewrite huge > chunks of the data file in

Re: [sqlite] Write performance

SQLite write (insert) performance doesn't seem very good to me so I'm trying to find ways to improve it in my application. I had this idea so I figured I'd run it past you folks who likely better know how the db works under the hood. did you wrap your inserts in a transaction? I don't think

Re: [sqlite] Write performance

I've been inserting data into a table with a non-integer primary key. The data does not come in in an ordered fashion. My thought is that perhaps performance suffers because it needs to rewrite huge chunks of the data file in order to slot the new data into its correct position within the file

[sqlite] errors compiling with MS VC++ 6.0

Hi, I am building sqlite 3.2.2 on windows with MS VC++ 6.0. I am doing this because I believe I need the .lib file to use the .dll with my code. Based on this message: http://www.mail-archive.com/sqlite-users@sqlite.org/msg04528.html I created an emply DLL project and added the

Re: [sqlite] errors compiling with MS VC++ 6.0

When I then try to build the project, I get internal compiler errors. Here are the first few lines of 35 errors it has: I have built v3.08 and v2.x using VC++ 6 and 7.x You do get a lot of casting warnings (which you can turn off/ignore), but I never got a compiler error. I would suspect

Re: [sqlite] errors compiling with MS VC++ 6.0

On Fri, 2005-06-17 at 16:54 -0700, Randall Fox wrote: > I would suspect it is something to do with your setup.. In fact I have > only once seen an INTERNAL COMPILER ERROR when using VC++, and it was my > fault. > I don't use VC++. But I have gotten a few "internal errors" on the compiler I

[sqlite] license to hack: pager in shmem

folks, for better or for worse, i'm going to use sqlite3 as a local cache for some of my preciousss objects (permanent persistence target is mysql). this is in a php app, so the obvious problem is having multiple sqlite page caches (one per apache process). therefore, unless well informed people

Re: [sqlite] license to hack: pager in shmem

On Fri, 2005-06-17 at 20:16 -0400, Paul G wrote: > i'd like to hack sqlite3 to use shared memory for the page cache. > A more useful hack, perhaps, would be to change the pager to use memmap() (when available) instead of read() and write(). This allows multiple instances of SQLite to use the

Re: [sqlite] license to hack: pager in shmem

richard, comments inline: - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Friday, June 17, 2005 8:54 PM Subject: Re: [sqlite] license to hack: pager in shmem > On Fri, 2005-06-17 at 20:16 -0400, Paul G wrote: > > i'd like to hack

Re: [sqlite] license to hack: pager in shmem

On Fri, 2005-06-17 at 21:21 -0400, Paul G wrote: > i might put in some work on this, although it's a bit more work than i'd > hoped (shm would have been faster afair). will this patch, assuming it looks > decent and works (for a reasonable threshold of 'works'), be accepted into > trunk? it's a

Re: [sqlite] license to hack: pager in shmem

- Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Friday, June 17, 2005 9:42 PM Subject: Re: [sqlite] license to hack: pager in shmem > On Fri, 2005-06-17 at 21:21 -0400, Paul G wrote: > > i might put in some work on this, although