Re: [sqlite] SQLite and Qt

tion 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 Ki

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 dea

Re: [sqlite] Questions regaring SQLite support on N97

.org > http://sqlite.org: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, o

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

defining 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 switch

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

we'll schedule it with 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 y

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

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

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 mail

Re: [sqlite] Performance

y may 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 Pa

Re: [sqlite] Performance

; ___ > sqlite-users mailing 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

Re: [sqlite] Optimization Question for SQLite Experts

vinced it > can 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.. > > Mark

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

any > serious problems. 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, sen

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

;>>>> 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 upda

Re: [sqlite] Using loadable extension with Qt

l sqlite3_enable_load_extension 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

[sqlite] Seeing a file handle issue with sqlite.

CLOEXEC fcntl 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) Fa

Re: [sqlite] unsupported file format

couple 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: >&

Re: [sqlite] unsupported file format

it has no > 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 Plai

Re: [sqlite] unsupported file format

x this. (The error is correct, 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 hav

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 obt

Re: [sqlite] Q about new SQLite API

case? > I trust your judgement on this ;) > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- Bill King, Software Engineer Tr

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_sto

[sqlite] blocking on insert

essing, etc even tho it's 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

Re: [sqlite] C precompiler to bytecode

e could even just 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...

when it's 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?

t; >> -- Darren Duncan > > 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 t

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 shoul

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?

Christian Smith wrote: On Wed, 7 Jun 2006, Jiri Hajek wrote: However, right after fixing this, I found another problem. It certainly can be my fault, but I don't see how could it be: If I don't use transactions, multiple threads seem to proceed well, but then right after I add BEGIN and COMM

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

Re: [sqlite] Problems with multiple threads?

> > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > 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 b

Re: [sqlite] Problems with multiple threads?

> can occur. If you ensure that every thread opens 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

Re: [sqlite] Problems with multiple threads?

; Jiri > > > I've seen these same issues myself too on linux/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

lculations. (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

w (which isn'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, A

Re: [sqlite] Low Level API for SQLite3

nts for 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

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, Aus

Re: [sqlite] SQL statements in progress error message

uot;)? ) > > -- > 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 statemen

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.

s utf-16LE. Any pointers on reducing this overhead 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, Australi