<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects, branch pr/132</title>
<subtitle>github.com: zzzeek/sqlalchemy.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/'/>
<entry>
<title>Changed pg8000 dialect to cope with native JSON</title>
<updated>2015-01-03T16:59:17+00:00</updated>
<author>
<name>Tony Locke</name>
<email>tlocke@tlocke.org.uk</email>
</author>
<published>2015-01-03T16:59:17+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=17e03a0ea86cd92816b4002a203b2b0b2c1a538a'/>
<id>17e03a0ea86cd92816b4002a203b2b0b2c1a538a</id>
<content type='text'>
For versions &gt; 1.10.1 pg8000 returns de-serialized JSON objects rather
than a string. SQL parameters are still strings though.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
For versions &gt; 1.10.1 pg8000 returns de-serialized JSON objects rather
than a string. SQL parameters are still strings though.
</pre>
</div>
</content>
</entry>
<entry>
<title>Make pg8000 version detection more robust</title>
<updated>2014-12-16T21:03:04+00:00</updated>
<author>
<name>Tony Locke</name>
<email>tlocke@tlocke.org.uk</email>
</author>
<published>2014-08-24T14:15:17+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=c93706fa3319663234e3ab886b65f055bf9ed5da'/>
<id>c93706fa3319663234e3ab886b65f055bf9ed5da</id>
<content type='text'>
pg8000 uses Versioneer, which means that development versions have
version strings that don't fit into the dotted triple number format.
Released versions will always fit the triple format though.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
pg8000 uses Versioneer, which means that development versions have
version strings that don't fit into the dotted triple number format.
Released versions will always fit the triple format though.
</pre>
</div>
</content>
</entry>
<entry>
<title>pg8000 client_encoding in create_engine()</title>
<updated>2014-12-16T20:55:55+00:00</updated>
<author>
<name>Tony Locke</name>
<email>tlocke@tlocke.org.uk</email>
</author>
<published>2014-08-24T15:33:29+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=8038cfa0771ff860f48967a6800477ce8a508d65'/>
<id>8038cfa0771ff860f48967a6800477ce8a508d65</id>
<content type='text'>
The pg8000 dialect now supports the setting of the PostgreSQL parameter
client_encoding from create_engine().
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The pg8000 dialect now supports the setting of the PostgreSQL parameter
client_encoding from create_engine().
</pre>
</div>
</content>
</entry>
<entry>
<title>- rework sqlite FK and unique constraint system to combine both PRAGMA</title>
<updated>2014-12-14T00:24:56+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-13T23:04:11+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=468db416dbf284f0e7dddde90ec9641dc89428c6'/>
<id>468db416dbf284f0e7dddde90ec9641dc89428c6</id>
<content type='text'>
and regexp parsing of SQL in order to form a complete picture of
constraints + their names.  fixes #3244 fixes #3261
- factor various PRAGMA work to be centralized into one call
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
and regexp parsing of SQL in order to form a complete picture of
constraints + their names.  fixes #3244 fixes #3261
- factor various PRAGMA work to be centralized into one call
</pre>
</div>
</content>
</entry>
<entry>
<title>- fix unique constraint parsing for sqlite -- may return '' for name, however</title>
<updated>2014-12-13T23:34:50+00:00</updated>
<author>
<name>Jon Nelson</name>
<email>jnelson@jamponi.net</email>
</author>
<published>2014-11-12T04:46:07+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=91af7337878612b2497269e600eef147a0f5bb30'/>
<id>91af7337878612b2497269e600eef147a0f5bb30</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- SQL Server 2012 now recommends VARCHAR(max), NVARCHAR(max),</title>
<updated>2014-12-06T18:43:39+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-06T18:30:51+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=c8817e608788799837a91b1d2616227594698d2b'/>
<id>c8817e608788799837a91b1d2616227594698d2b</id>
<content type='text'>
VARBINARY(max) for large text/binary types.  The MSSQL dialect will
now respect this based on version detection, as well as the new
``deprecate_large_types`` flag.
fixes #3039
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
VARBINARY(max) for large text/binary types.  The MSSQL dialect will
now respect this based on version detection, as well as the new
``deprecate_large_types`` flag.
fixes #3039
</pre>
</div>
</content>
</entry>
<entry>
<title>- The SQLite dialect, when using the :class:`.sqlite.DATE`,</title>
<updated>2014-12-05T19:46:43+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-05T19:46:43+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=0ce045bd853ec078943c14fc93b87897d2169882'/>
<id>0ce045bd853ec078943c14fc93b87897d2169882</id>
<content type='text'>
:class:`.sqlite.TIME`,
or :class:`.sqlite.DATETIME` types, and given a ``storage_format`` that
only renders numbers, will render the types in DDL as
``DATE_CHAR``, ``TIME_CHAR``, and ``DATETIME_CHAR``, so that despite the
lack of alpha characters in the values, the column will still
deliver the "text affinity".  Normally this is not needed, as the
textual values within the default storage formats already
imply text.
fixes #3257
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
:class:`.sqlite.TIME`,
or :class:`.sqlite.DATETIME` types, and given a ``storage_format`` that
only renders numbers, will render the types in DDL as
``DATE_CHAR``, ``TIME_CHAR``, and ``DATETIME_CHAR``, so that despite the
lack of alpha characters in the values, the column will still
deliver the "text affinity".  Normally this is not needed, as the
textual values within the default storage formats already
imply text.
fixes #3257
</pre>
</div>
</content>
</entry>
<entry>
<title>- New Oracle DDL features for tables, indexes: COMPRESS, BITMAP.</title>
<updated>2014-12-05T01:08:07+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-05T01:08:07+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=edef95379777a9c84ee7dbcbc9a3b58849aa8930'/>
<id>edef95379777a9c84ee7dbcbc9a3b58849aa8930</id>
<content type='text'>
Patch courtesy Gabor Gombas.
fixes #3127
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Patch courtesy Gabor Gombas.
fixes #3127
</pre>
</div>
</content>
</entry>
<entry>
<title>- Added support for CTEs under Oracle.  This includes some tweaks</title>
<updated>2014-12-05T00:35:00+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-05T00:35:00+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=e46c71b4198ee9811ea851dbe037f19a74af0b08'/>
<id>e46c71b4198ee9811ea851dbe037f19a74af0b08</id>
<content type='text'>
to the aliasing syntax, as well as a new CTE feature
:meth:`.CTE.suffix_with`, which is useful for adding in special
Oracle-specific directives to the CTE.
fixes #3220
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
to the aliasing syntax, as well as a new CTE feature
:meth:`.CTE.suffix_with`, which is useful for adding in special
Oracle-specific directives to the CTE.
fixes #3220
</pre>
</div>
</content>
</entry>
<entry>
<title>- Updated the "supports_unicode_statements" flag to True for MySQLdb</title>
<updated>2014-12-05T00:12:52+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-05T00:12:52+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=fda589487b2cb60e8d69f520e0120eeb7c875915'/>
<id>fda589487b2cb60e8d69f520e0120eeb7c875915</id>
<content type='text'>
and Pymysql under Python 2.   This refers to the SQL statements
themselves, not the parameters, and affects issues such as table
and column names using non-ASCII characters.   These drivers both
appear to support Python 2 Unicode objects without issue in modern
versions.
fixes #3121
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
and Pymysql under Python 2.   This refers to the SQL statements
themselves, not the parameters, and affects issues such as table
and column names using non-ASCII characters.   These drivers both
appear to support Python 2 Unicode objects without issue in modern
versions.
fixes #3121
</pre>
</div>
</content>
</entry>
</feed>
