[python-sqlite] Re: pysqlite 2.8.0 released

Gerhard Häring gh at ghaering.de
Wed Aug 19 23:03:00 CEST 2015


Yes, I forgot to "setup.py sdist upload". It's fixed now. Sorry for the
trouble.

I'm of course looking forward to hear if SQLAlchemy still works ok with
this release.

On Wed, Aug 19, 2015 at 10:10 PM, <zzzeek at gmail.com> wrote:

> Hi Gerhard -
>
> is the download missing?  On Pypi I see 2.8.0 is registered but no
> download file:
>
> https://pypi.python.org/pypi/pysqlite/2.8.0
>
> pip fails:
>
> $ ./bin/pip install pysqlite==2.8.0 --upgrade --force
> Collecting pysqlite==2.8.0
>   Could not find a version that satisfies the requirement pysqlite==2.8.0
> (from versions: 2.5.6, 2.6.0, 2.6.3, 2.7.0)
>   Some externally hosted files were ignored as access to them may be
> unreliable (use --allow-external to allow).
>   No distributions matching the version for pysqlite==2.8.0
>
>
>
> On Tuesday, August 18, 2015 at 8:17:46 PM UTC-4, Gerhard Häring wrote:
>>
>> NEW FEATURES
>>
>> - No new features, but tons of bugfixes. These mean that things now work
>> that
>>   didn't before:
>> - Transactional DDL now works
>> - You can use SAVEPOINTs now
>>
>>
>> BUILD PROCESS
>>
>> - Python 2.7.x is now required. If trying to use it with Python 3, print a
>>   useful error message.  Integrated all fixes from the sqlite3 module in
>> Python
>>   2.7.10.
>>
>>
>> MAJOR IMPROVEMENTS
>>
>> - Completety got rid of statement parsing. We now use SQLite functions to
>>   determine if a statement modifies the database or not. If a statement
>>   modifies the database, then we implicitly start a transaction. For
>> backwards
>>   compatibility reasons, we do NOT implicitly start a transaction if we
>>   encounter a DDL statement.
>>
>>   You can, however, now have transactional DDL if you want to:
>>
>>     cur = con.cursor()
>>     cur.execute("begin")
>>     cur.execute("create table foo(bar)")
>>     con.rollback()
>>
>>   This also means that people can now finally use SAVEPOINTS.
>>
>> - Use sqlite3_get_autocommit() to determine if we are within a transaction
>>   instead of trying to be smart.
>>
>> - Switch to v2 statement API. This simplified the code and will increase
>>   stability.
>>
>> MINOR IMPROVEMENTS
>>
>> - You can use unicode strings as index for Row objects.
>>
>>
>> BUGFIXES
>>
>> - Fixed a regression: statements should not be reset after a commit.
>>
>>
>> GENERAL CLEANUP AND DEPRECATIONS
>>
>> - Since december 2005, row_factory is a feature of the Connection class
>> instead
>>   of the Cursor class. It was kept in the Cursor class for backwards
>>   compatibility. Now it was time to finally remove it from the Cursor
>> class.
>> - DEPRECATE converters and adapters.
>> - DEPRECATE text_factory.
>> - Remove compatibility workarounds for old Python versions.
>> - Remove workarounds for old SQLite versions.
>> - Remove apsw related code.
>>
>> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "python-sqlite" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to python-sqlite+unsubscribe at googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20150819/51b5b4c8/attachment.html>


More information about the Python-list mailing list