http://blog.gmane.org/gmane.comp.python.db.pysqlite.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2358 <pre> Roger, The invitation arrived and I responded appropriately. Thanks, Rich </pre> Rich Shepard 2009-10-18T18:55:31 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2357 <pre> They have just been approved. We can close this list to new posts now. For those doing mail filtering the new group has a subject prefix of [python-sqlite]. I have notified the Gmane admins of the changes but they haven't followed up on them yet. Roger </pre> Roger Binns 2009-10-18T17:13:34 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2356 <pre> You should receive an email asking you to join the group requiring you to take some action to join. (The interface does allow for just directly adding people but that is what spammers do!) Consequently you can just go ahead and add yourself without waiting for the invitation. You haven't missed anything yet except the announcement of APSW 3.6.19 which now includes an awesome shell :-) Roger </pre> Roger Binns 2009-10-18T17:02:24 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2355 <pre> Gerhard, When the Google admins approve the invitations are we automatically subscribed to the new group/mail list? Thanks, Rich </pre> Rich Shepard 2009-10-18T15:07:15 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2354 <pre> I just invited all 149 list subscribers. This looked suspicious to Google so the invitation is now waiting for approval by Google admins. Once that is done you will receive the invitation email. Or you can just subscribe manually of course. </pre> Gerhard Häring 2009-10-18T09:04:11 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2353 <pre>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Gerhard Häring wrote: Those of you whose German is not very good may prefer this link :-) http://groups.google.com/group/python-sqlite Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkra01UACgkQmOOfHg372QTpJACfVbUWRsfYK3VOgfyXy0h5Z0dR 5GQAnR64Scx5hhNHZu0gwUuKw22A4fff =ZjlM -----END PGP SIGNATURE----- </pre> Roger Binns 2009-10-18T08:35:34 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2352 <pre>Hello, I was guilty of a misconfiguration of the mail server this list is hosted on. The effect was that the only subscriber that received mails from the list for a month or so were members subscribed to the domain ghaering.de. I. e. only me. So I decided to outsource the administration problems to Google. This mailing list will move over to Google Groups (Roger Binns already set a group up there): http://groups.google.de/group/python-sqlite I'll invite all subscribers of this list in a few minutes. I will move the pysqlite hosting to Google Code during the next days, too. </pre> Gerhard Häring 2009-10-18T08:33:15 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2351 <pre>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dinesh B Vadhia wrote: Why don't you try it with your data and your queries? Also see http://www.sqlite.org/pragma.html which lets you alter the default SQLite cache sizes. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqgaXwACgkQmOOfHg372QRcdQCgnSW16piQWw3wzVemmQZiPyun XDoAoKKFgLekSXg9Hm072h9zEqEH2JNt =nBQX -----END PGP SIGNATURE----- </pre> Roger Binns 2009-09-04T01:12:35 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2350 <pre>_______________________________________________ list-pysqlite mailing list list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ&lt; at &gt;public.gmane.org http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite</pre> Dinesh B Vadhia 2009-09-03T21:50:20 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2349 <pre>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Austin Bingham wrote: It is indeed the "correct" behaviour. It is SQLite that does this. I actually use this as part of the test suite since it was the only way I could think of deliberately causing an error on a read only blob. This is alluded to in http://apsw.googlecode.com/svn/publish/blob.html#apsw.blob.close I have since updated the documentation to mention this specific example and blame SQLite :-) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqdJwgACgkQmOOfHg372QRAxACgvTATM5VxqF3Jptt0cUHIN7O4 FgMAn1u0oNh8BINEGi6gEnRcJEo0AjLy =1iTy -----END PGP SIGNATURE----- </pre> Roger Binns 2009-09-01T13:52:09 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2348 <pre>I've found that Blob.close() throws a ReadOnlyError if I've previously attempted to perform a write on that blob. I was surprised by this, but I wanted to see if this is expected behavior. Here's code that demonstrates the issue: import apsw sql = ''' CREATE TABLE IF NOT EXISTS data (id INTEGER PRIMARY KEY NOT NULL, data BLOB NOT NULL)''' conn = apsw.Connection('test.db') cur = conn.cursor() cur.execute(sql) cur.execute('INSERT INTO data VALUES(?,?)', (None, apsw.zeroblob(1000))) rowid = conn.last_insert_rowid() blob = conn.blobopen('main', 'data', 'data', rowid, False) # Attempt a write try: blob.write('x' * 10) except apsw.ReadOnlyError: # expected pass # This throws ReadOnlyError unexpectedly blob.close() This is with version 3.6.16 on python 2.6.1. Austin </pre> Austin Bingham 2009-09-01T13:09:59 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2347 <pre> Try executing the test from somewhere else. The test suite tries to create a database file in the working directory. And your choice of working directory was an unfortunate one, it seems ;-) </pre> Gerhard Häring 2009-08-13T09:22:16 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2346 <pre>Hi list, The install-source.txt file said to email this list if I encountered errors running pysqlite2.test.test(), but didn't encounter any errors during compilation or installation. So that's what I am doing. Here's the error I encountered (it says there are nine of them....but they sure seem related): ################################ [GCC 4.0.1 (Apple Inc. build 5465)] on darwin Type "help", "copyright", "credits" or "license" for more information. &gt;&gt;&gt; from pysqlite2 import test &gt;&gt;&gt; test.test() .....................................................................................................................................................................EEEEEEEEE ................................. ====================================================================== ERROR: CheckDMLdoesAutoCommitBefore (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckDeleteStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckInsertStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckLocking (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckRaiseTimeout (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckReplaceStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckRollbackCursorConsistency (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckToggleAutoCommit (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckUpdateStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ---------------------------------------------------------------------- Ran 207 tests in 0.083s FAILED (errors=9) ##################################### Thanks so much! David </pre> David Garfield 2009-08-12T14:34:08 http://permalink.gmane.org/gmane.comp.python.db.pysqlite.user/2345 <pre>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 APSW 3.6.17-r1 is now available. The home page is at http://code.google.com/p/apsw/ which includes full documentation, source and binary distributions for Windows (Python 2.3 onwards including 3.0 &amp; 3.1). APSW is a wrapper around SQLite that provides all SQLite API functionality in Python. It is not DBAPI compliant as it provides SQLite semantics. pysqlite provides DBAPI semantics. You can see the two approaches contrasted at http://apsw.googlecode.com/svn/publish/pysqlite.html Changelist is below and a clickable version at http://apsw.googlecode.com/svn/publish/changes.html APSW has migrated from Subversion to Mercurial for source code control. Hosting remains at Google Code Updated a test due to VFS xUnlock errors now being ignored sometimes by SQLite (SQLite ticket 3946). The downloads page in the help didn’t mention the Windows Python 3.1 installer. Running the test suite is now integrated into setup.py so you can do the building and testing all in one go. Sample command line: $ python setup.py install test The test suite will now check the functionality of the FTS3, RTree and ICU extensions if they were included. (The Windows binary distribution includes FTS3 and RTree by default.) Fixed issue 55 where FTS3 was unintentionally omitted from the Windows binary distribution. Various documentation updates. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqBD9AACgkQmOOfHg372QSXtACggQZbyhdeYPqH7VF9CseQ+Lcm En0An0t8i3wN4y8hZTUSlhT28Qq28Jop =ZjOk -----END PGP SIGNATURE----- _______________________________________________ list-pysqlite mailing list list-pysqlite&lt; at &gt;lists.itsystementwicklung.de http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite</pre> Roger Binns 2009-08-11T06:29:40 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.python.db.pysqlite.user