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
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
.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
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
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
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
>
_
> 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
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
; ___
> 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
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
[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?
>>
>
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
;>>>> 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
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
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
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:
>&
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
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
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
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
case?
>
I trust your judgement on this ;)
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
>
--
Bill King, Software Engineer
Tr
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
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
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
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
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
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
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
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
[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
>
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
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..
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
>
> --
> 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
> 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
; 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
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.
>>>
>&
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
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
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
?
> 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
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
[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
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
44 matches
Mail list logo