Re: [sqlite] Proper way to change temp directory

Cool beans, perhaps this should be added to the docs! On Sun, Nov 20, 2011 at 1:36 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 11/20/2011 04:00 PM, Yang Zhang wrote: >> >> Out of curiosity, what's the proper way to change the temp directory >> (say, to avoid &q

[sqlite] Proper way to change temp directory

e? Thanks. -- Yang Zhang http://yz.mit.edu/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is this a bug? Can't tell from docs....

behavior.  Anyway, if this is intentional (as I'm guessing), I wouldn't have been able to tell from the docs - perhaps this would warrant special mention? Just thought I'd bring this to your attention. -- Yang Zhang http://yz.mit.edu/ ___ sqlite-users mailing

Re: [sqlite] Transaction isolation

Roger Binns wrote: > Yang Zhang wrote: >> Actually, this is only because Python 3 str is Python 2 unicode. Python >> 2 (which I'm currently using, and which I believe most of the world is >> using) str is a physical string of bytes, not a logical/decoded >> ch

Re: [sqlite] Transaction isolation

Igor Tandetnik wrote: > Yang Zhang <yanghates...@gmail.com> wrote: >> Pavel Ivanov wrote: >>> BTW, ACID that you mentioned has nothing to do with snapshot >>> isolation that you want to achieve. AFAIK only Oracle supports this >>> kind of statement isolat

Re: [sqlite] Transaction isolation

on. http://en.wikipedia.org/wiki/Snapshot_isolation And I certainly hope I did not convey that ACID implies snapshot isolation. -- Yang Zhang http://www.mit.edu/~y_z/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Transaction isolation

Roger Binns wrote: > Yang Zhang wrote: >> I copied and pasted this code straight from my actual application, which >> uses blobs instead of integers, which I need to convert into strings >> (since Python interfaces with blobs using the `buffer` type, not `str`). > &g

Re: [sqlite] Transaction isolation

Yang Zhang wrote: > John Elrick wrote: >> Yang Zhang wrote: >>> Roger Binns wrote: >>> >>>> Yang Zhang wrote: >>>> >>>>> for i in (str(row[0]) for row in conn.cursor().execute('SELECT key >>>>> FROM shelf OR

Re: [sqlite] Transaction isolation

John Elrick wrote: > Yang Zhang wrote: >> Roger Binns wrote: >> >>> Yang Zhang wrote: >>> >>>> for i in (str(row[0]) for row in conn.cursor().execute('SELECT key FROM >>>> shelf ORDER BY ROWID')): >>>>

Re: [sqlite] Transaction isolation

Roger Binns wrote: > Yang Zhang wrote: >> for i in (str(row[0]) for row in conn.cursor().execute('SELECT key FROM >> shelf ORDER BY ROWID')): > > You are converting the key which is an integer into a string for no > apparent reason. I copied and pasted this code

[sqlite] Transaction isolation

(transaction-level) isolation. Thanks in advance for any answers! -- Yang Zhang http://www.mit.edu/~y_z/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users