Re: [sqlite] SQLite and Qt

should work fine to exec "PRAGMA foreign_keys = ON" > Sam > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Bill King, S

Re: [sqlite] Proposed: drop support for LinuxThreads

users > Some old embedded platforms have libc compiled with nptl to "save space", seriously tho, it's pretty much down to a matter of recompiling libc with the appropriate thread library support. Consider this a vote for removal/clarity/standardisation, as it's not a huge deal to turn

Re: [sqlite] Questions regaring SQLite support on N97

rg:8080/cgi-bin/mailman/listinfo/sqlite-users > Things are getting better, qt and qtcreator for s60's making things noticeably easier, and there's a QtSql wrapper for the sqlite server engine access in the works, or native sqlite is included in qt/s

Re: [sqlite] SQLite, network share, and Qt

ing SQLITE_ENABLE_LOCKING_STYLE when > you build the library. Maybe your command line tool was built with > this option but the Qt driver was not. > > > As far as I know, the Qt (compiled/included by default) library isn't compiled with these switches on. --

Re: [sqlite] SQLite, network share, and Qt

th the approx 120 other bugs against the SQL section and try to replicate. Nothing has changed significantly that would impact this in qt for a very long time now, (as well as the fact that we're performing a whole lot of autotests on a very regular basis). Have you tried opening up a debugger

Re: [sqlite] UTF-16 API a second class citizen?

ou'll see significant overhead from conversions back >> and forth between >> utf8 and utf16 inside the sqlite code. >> >>> Igor Tandetnik >>> > > ___ > sqlite-users mailing list > sqlite-users@sqlit

Re: [sqlite] UTF-16 API a second class citizen?

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- Bill King, Software Engineer Qt Software, Nokia Pty Ltd Brisbane Office ___ sqlite-users mailing list s

Re: [sqlite] Performance

be another avenue to consider, but definately, reducing the number of writes to the filesystem in the first place is also something that will help those filesystems do their job even better to help extend the lifetime of the hardware. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Bran

Re: [sqlite] Performance

ling list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > One thing I can highly recommend on embedded systems, especially flash based ones, is turn pragma synchronous to off. Having sqlite write every record modification to the flash, is a st

Re: [sqlite] Optimization Question for SQLite Experts

be massively optimised. > > There are so many options, each of which would require quote alot of > effort to prototype and test, I wondered what wisdom any hardened > SQlite folk could offer. What is the best approach to attack this > problem ? > > Thanks for any experience you can share..

Re: [sqlite] Next Version of SQLite

[EMAIL PROTECTED] wrote: > Bill KING <[EMAIL PROTECTED]> wrote: > >> A colleague brought up a very good point. At least for the first few >> revisions, is the old engine/code still going to be available until the >> new engine code base settles down? >> >

Re: [sqlite] Next Version of SQLite

blems. You should not underestimate the level of detail to > which we test SQLite and the thoroughness of the test suite. Not much > is likely to slip through the cracks. > > > D. Richard Hipp > [EMAIL PROTECTED] > > > > > - > > To unsubscribe, send email to [EMAIL PR

Re: [sqlite] QT4 ubuntu sqlite driver problem ? (was Re: [sqlite] Weird error)

gt;>>> SQL logic error or missing database >>>>> Unable to fetch row >>>>> Err number 1. >>>>> >> > > I have found the solution in the qt4 doc : > - > The driver is locked for updates w

Re: [sqlite] Using loadable extension with Qt

on function? I understand that > I can > build my extension into sqlite similar to fts1 and fts2, but I need to > load > it dynamically so this is not an option. > > Many thanks in advance for any suggestio

[sqlite] Seeing a file handle issue with sqlite.

on the open filehandle, but I'd like to get confirmation from elsewhere/highlight it to DRH/the list to make them aware of it. -- 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

Re: [sqlite] unsupported file format

le of different windows boxes and > linux boxes, all sharing the same sqlite3 database file, but with > different versions of sqlite3? How does one "convert" between > versions? > > Thanks, > Mike > > On 1/16/07, Bill KING <[EMAIL PROTECTED]> wrote: >> M

Re: [sqlite] unsupported file format

problem interacting with it. I'm not sure why I'm suddenly seeing > this. > > Thanks, > Mike Err, s/qt/ROR/ -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113

Re: [sqlite] unsupported file format

rect, the qt version's older and incompatible with your system version). -- 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] sqlite performance, locking & threading

Roger Binns wrote: Im sorry for being so harsh, and i know im not winning any friends here, So far noone has agreed with you :-) This would be incorrect. The correct statement is "so far no one has vocally agreed with you". If people didn't agree, this whole once a month people

Re: [sqlite] sqlite performance, locking & threading

Emerson Clarke wrote: The indexing process works like this. 1.) Open a document and parse its contents. 2.) Look up records in the first database based on the contents of the document, updating records where appropriate and inserting new ones. 3.) Transforming the document based on what was

Re: [sqlite] blocking on insert

Thankyou, spot on the mark :) Now we've got it blazing fast, time to move backwards towards a reasonable mix of safety and speed. [EMAIL PROTECTED] wrote: > Bill KING <[EMAIL PROTECTED]> wrote: > >> Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memor

[sqlite] blocking on insert

threaded off into a low priority thread). Thanks in advance, Bill -- 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] C precompiler to bytecode

st pre-compile once per run, and attach to a database handle afterwards... -- 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

[sqlite] Moving journal storage to another location...

done/committed, have that written to the sd media? Thanks in advance, Bill. -- 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] Major projects using SQLite

Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. Trolltech's qtopia mobile phone platform is using sqlite for pim, contacts, and document metainfo. http://www.trolltech.com/products/qtopia

Re: [sqlite] Compressing the DBs?

> We came across this with our filesystem metainfo system, what we ended up doing was creating a sub-table called "location". with this location it can be used either via join in the sql statement, or via a cached internal structure to recreate the path of a file. (Easy enough with a map<> or a hash<> style bucket class). No major overhead costs, but a definate savings in space. (Each directory becomes an entry in the location table, so a file is then stored as a location key value + filename). -- 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] SQLite performance for 10 Million Records

Manzoor Ilahi Tamimy wrote: Hello All, We are Using SQLite for one of our project. The Database Size is more than 500 MB. It contain one table and about 10 million Records. We are facing Problem in the select with single Join. The join is between a big table and a small table. The small

Re: [sqlite] Problems with multiple threads?

Jay Sprenkle wrote: > On 6/7/06, Bill KING <[EMAIL PROTECTED]> wrote: >> I understand why I'm getting the deadlock now, lazy locking, (it's >> against the logical grain of transaction/locking, but that's a whole >> other argument) . Maybe this should be

Re: [sqlite] Problems with multiple threads?

[EMAIL PROTECTED] wrote: > Bill King <[EMAIL PROTECTED]> wrote: > >> Christian Smith wrote: >> >>> If one transaction already has a read lock, and another transaction >>> has a reserved lock (trying to get a write lock), neither thread can >

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