PostgreSQL + Python | Psycopg. Psycopg Psycopg is the most popular PostgreSQL adapter for the Python programming language. At its core it fully implements the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL. Psycopg is released under the terms of the GNU Lesser General Public License, allowing use from both free and proprietary software. Latest articles Psycopg 2.6.1 released Posted by Daniele Varrazzo on June 16, 2015 Tagged as news, release Psycopg 2.6 and 2.5.5 released Posted by Daniele Varrazzo on February 9, 2015 Psycopg 2.5.4 released Posted by Daniele Varrazzo on August 30, 2014 Tagged as news, release Cancelling PostgreSQL statements from Python Posted by Daniele Varrazzo on July 20, 2014 Tagged as recipe Psycopg 2.5.3 Released Posted by Daniele Varrazzo on May 13, 2014 Tagged as news, release Donate Quick links Tweets JSON adapter, PG 9.2 range support, context manager, error diagnostics, better composite types... only in Psycopg 2.5!
SQLAlchemy - The Database Toolkit for Python. GeoAlchemy 2 Documentation — GeoAlchemy2 0.2 documentation. Using SQLAlchemy with Spatial Databases. GeoAlchemy 2 provides extensions to SQLAlchemy for working with spatial databases. GeoAlchemy 2 focuses on PostGIS. PostGIS 1.5 and PostGIS 2 are supported. Note GeoAlchemy 2 doesn’t currently support other dialects than PostgreSQL/PostGIS. GeoAlchemy 2 aims to be simpler than its predecessor, GeoAlchemy. Requirements GeoAlchemy 2 requires SQLAlchemy 0.8. What’s New in GeoAlchemy 2 GeoAlchemy 2 supports PostGIS’ geometry type, as well as the geography and raster types.The first series had its own namespace for spatial functions. See the Migrate to GeoAlchemy 2 page for details on how to migrate a GeoAlchemy application to GeoAlchemy 2.
Tutorials GeoAlchemy 2 works with both SQLAlchemy’s Object Relational Mapping (ORM) and SQL Expression Language.