Re: [sqlite] Problems with multiple threads?

Joe Wilson wrote: > --- Bill KING <[EMAIL PROTECTED]> wrote: > >> Outside of, and I use Qt's QReadWriteLock. ->lockForRead()/lockForWrite() >> http://doc.trolltech.com/4.1/qreadwritelock.html >> > > Thanks. > > Many follow-up questions... :-)

Re: [sqlite] Problems with multiple threads?

Joe Wilson wrote: > Hi Bill, > > When you say "handle read/write locking [your]self" do > you mean outside of SQLite in your code or by altering > SQLite's source code? > > What algorithm do you employ? > > --- Bill KING <[EMAIL PROTECTED]

Re: [sqlite] Problems with multiple threads?

> > > Could this be cause by one thread opening a transaction, then a second on a second connection trying to open a transaction on it, and failing to open the transaction file (as it already exists?). Could this be solved by per connection transaction journals, or maybe by blocking? One probl

Re: [sqlite] Problems with multiple threads?

the database itself and no > thread ever modifies the schema, you should not see either of those problems. > > Cheers, > > Derrell > > I personally did do all this, this doesn't solve the issue. As I mentioned earlier, I followed all the rules, the only solution to avoid the i

Re: [sqlite] Problems with multiple threads?

ux/3.3.5, my solution was using our own internal classes to marshal read/write locking ourselves. Cleared everything right up. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

Re: [sqlite] Strange behavior with sum

Kareem Badr wrote: > Bill KING wrote: >> Kareem Badr wrote: >> >>> I should mention that free_space and size are defined as varchars, for >>> some reason. Not sure if that has anything to do with the issues I'm >>> seeing. >>&

Re: [sqlite] Strange behavior with sum

tions. (when using a numeric field, it's always better to set the field NOT NULL, and default it to 0). -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

Re: [sqlite] Advice on compiling 3.5.5 for Mac OS X?

On May 21, 2006, at 5:05 PM, Kon Lovett wrote: I second this. I am not even sure /usr/lib/libreadline.dylib is readline. It is a symbolic link to libedit.dylib for me. So I use my own build of readline as well. It is the BSD version of readline which lacks the history API and a couple of

[sqlite] maximum number of databases

is the maximum number of databases managed a single server? Sincerely, Bill Fitzpatrick [EMAIL PROTECTED]

Re: [sqlite] Low Level API for SQLite3

sn't much). The sql parser generates vdbe bytecodes (see the explain command), which it then executes to execute the query as such. You could take a squiz in that direction. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113

Re: [sqlite] Low Level API for SQLite3

or the > presence of viruses. The company accepts no liability for any damage caused, > directly or indirectly, by any virus transmitted in this email > > > * notices some of the questions over the last few days and asks

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

; Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > Unless your app (and the stuff you want to profile) is multi-threaded. Ugh. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australi

Re: [sqlite] SQL statements in progress error message

IT")? ) > > -- > Nick > > I found out yesterday, that if you have an open count(*) statement, and fail to finalise it before doing an insert/update commit, then you get this error code. This may help a little? (only seemed to be on count(*) statements, other normal select statements, d

Re: [sqlite] Optimisation tips for UTF-16 usage.

[EMAIL PROTECTED] wrote: > Bill KING <[EMAIL PROTECTED]> wrote: > > > The current parser in SQLite is UTF-8 only. So when you use > sqlite3_prepare16() the first thing it does is translate you > input SQL into UTF-8 then pass it off to sqlite3_prepare(). > There is

[sqlite] Optimisation tips for UTF-16 usage.

erhead as much as possible will be muchly appreciated. (UTF-8 is really not an option, as we are working for and with UTF-16 charsets). -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61

RE: [sqlite] How to unsubscribe from this maillist ?

I had an issue with my computer where I started getting files filling my temporary directory without reason that began with "sqlite_" and wanted to ask the forum if anyone new why this was. In order to do so I had to join the forum, knowing no other avenue to find out. I got my answer -

RE: [sqlite] Question

Thank you very much. I will check this out and let you know or attach the file(s). Bill -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 12:03 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Question Bill Giannotti wrote: >I have ne

[sqlite] Question

k from a repair shop. But it started again, and so there must be something I am using to invoke this, probably from the web. I am running Win XP SP2, have AOL and AOL Security Center with McAfee Can anyone give me any clue on how this started and how to make it stop? Thanks! Bill

[sqlite] Please unsubscribe me

I have tried uncuccessfully to unsubscribe several times PLEASE REMOVE ME FROM THIS LIST - Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez le ici !

[sqlite] SQLite on Tiger.

So, now the cat is out of the bag, so to speak. Tiger ships with SQLite 3.1.3 + a couple of tweaks. Specifically, the SQLite3 on Tiger supports locking on network filesystems, including AFP and Samba. Tiger uses SQLite3 in a number of roles. It is a backing store to Core Data -- the new

[sqlite] Desperate newbie: .def problem??

]); exit(1); } rc = sqlite3_open(argv[1], ); if( rc ){ fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); sqlite3_close(db); exit(1); } rc = sqlite3_exec(db, argv[2], callback, 0, ); if( rc!=SQLITE_OK ){ fprintf(stderr, "SQL error: %s\n", zErrMsg); } sqlit

<    1   2