[sqlite] Merry Christmas

Merry Christmas to the whole mailing list and your families :) Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Update not completely commit(ing)

Quoth Joe Bennett , on 2010-12-24 18:28:18 -0600: > Have a question regarding a particular issue I am dealing with... I > have a database in which I create a pivot table to get a no dupe list > using a 'select distinct'. I then take that list into Python and then > iterate

Re: [sqlite] Update not completely commit(ing)

On 25 Dec 2010, at 12:28am, Joe Bennett wrote: > update_data = 'update matrix set %s = %f, %s = %f where %s = "%s"' % > (A_B + '_Lat', Lat_Site, A_B + '_Lon',Lon_Site, A_B, Site[0]) You've used double quotes. I'm guessing that the value is a string, in which case you mean single quotes. But

[sqlite] Update not completely commit(ing)

Hi all, Have a question regarding a particular issue I am dealing with... I have a database in which I create a pivot table to get a no dupe list using a 'select distinct'. I then take that list into Python and then iterate over it to look up data in another table to add in the latitude and

Re: [sqlite] delete from t1 where not in (null)

On Fri, Dec 24, 2010 at 5:19 PM, Andrew Z wrote: > My application accesses an SQLite database created by another > application, and I noticed on my system (SQLite 3.7.2, Fedora 14) if > the subquery returns no values, the delete clause does nothing. Is > this a bug in SQLite?

Re: [sqlite] delete from t1 where not in (null)

Hi, SQLite sounds pretty reasonnable to me: >select "select distinct favicon_id from moz_places"; >select distinct favicon_id from moz_places; Returns NULL >select "deleting: standard method..."; >delete from moz_favicons where id not in (select distinct favicon_id >from moz_places); -- here

[sqlite] delete from t1 where not in (null)

My application accesses an SQLite database created by another application, and I noticed on my system (SQLite 3.7.2, Fedora 14) if the subquery returns no values, the delete clause does nothing. Is this a bug in SQLite? The expected result below is that all rows from moz_favicons are deleted.

[sqlite] VFS and hot journals

Hi, I recently discovered that for vfs implemented writable formats that actually change the data of the sqlite base (encryption, compression), there should be a complex logic behind the restoration from the hot journal, at least some versions ago. For correct password handling initially I relied

Re: [sqlite] how to speed up this ?

> Select >H1.ID > from >HASH1 H1 > where >x1_y1 BETWEEN min11 AND max11 AND >x1_y2 BETWEEN min12 AND max12 AND >x1_y3 BETWEEN min13 AND max13 AND >x1_y4 BETWEEN min14 AND max14 AND >x1_y5 BETWEEN min15 AND max15; > > no it's not work at all !! without an rtree index

Re: [sqlite] how to speed up this ?

i do it.. but it's change nothing :( On 12/24/2010 3:47 PM, Simon Slavin wrote: > On 24 Dec 2010, at 8:17am, Vander Clock Stephane wrote: > >> I have a key like this >> >> 123-098-230-120-111 where (123), (098), (230), (120), (111) are what i >> call node >> Node are integer comprise between 0

Re: [sqlite] how to speed up this ?

On 24 Dec 2010, at 12:47pm, Simon Slavin wrote: > Precalculate five sets of minimum and maximum bounds: > > min11 = max((<#randomnumber> % 255)-10,0) > max11 = min((<#randomnumber> % 255)+10,255) > > Then you can just seize the ten values you need from the table and use them > to make up

Re: [sqlite] how to speed up this ?

On 24 Dec 2010, at 8:17am, Vander Clock Stephane wrote: > I have a key like this > > 123-098-230-120-111 where (123), (098), (230), (120), (111) are what i > call node > Node are integer comprise between 0 and 255 (bytes) You mean from 000 to 254. 255 breaks your system because you are using

Re: [sqlite] how to speed up this ?

can you gave me the name of a good SSD you advise me to buy ? i decide to make a try ! Thanks again stéphane On 12/24/2010 12:24 AM, John Drescher wrote: > On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane > wrote: >> that very very much expensive :( how much you

Re: [sqlite] how to speed up this ?

> Can you describe what you're trying to do with that command ? of course ! I have a key like this 123-098-230-120-111 where (123), (098), (230), (120), (111) are what i call node Node are integer comprise between 0 and 255 (bytes) and i need to found "similare" key. A similar key is a key