Psycopg2 icon

Psycopg2 For Linux

4.5/5 2
LGPL    

An Open Source and cross-platform PostgreSQL database adapter for the Python language. #Database adapter  #PostgreSQL database  #Python DB API  #PostgreSQL  #Database  #Adapter  

Softpedia Review

specifications

changelog

Free Download

Review by:
4.0/5

Psycopg2 (also known as python-psycopg2 on most Linux kernel-based operating systems) is a very small, stable and fast software written in C and designed from the offset to provide a PostgreSQL adapter for the Python programming language.

Key features include COPY support, server-side cursors, support for two-phase commit, support for large objects, asynchronous non-blocking I/O, which is also integrated with the coroutine-based libraries, including Eventlet, gevent, and uGreen, as well as support for sending and receiving asynchronous notifications.

Psycopg2 can be used as an adaptation of several Python objects to database type, including flexible JSON support, tuples to records, dictionaries to hstore, and lists to array.

It is an extendible software, allowing users to easily add support for new adapters which can be used to convert Python objects to SQL typecasters and syntax, as well as to convert PostgreSQL types into Python objects.

Psycopg2 is a Python module which has been engineered to fully implement the Python DB API (Application Programming Interface) 2.0 specifications, as well as to allow access to many of PostgreSQL’s features.

Psycopg2 is a complete rewrite of the original Psycopg module. It was created with the intention of providing new-style classes for database connections, as well as cursor objects and many other goodies.

At the moment of writing this review, we have discovered that the Psycopg2 software supports Python versions from 2.5 to 3.4, as well as PostgreSQL versions from 7.4 to 9.4. The application is thread-safe, which means that threads can share the same connection or use different connections.

Psycopg2 is a cross-platform software, supported on the GNU/Linux, Microsoft Windows and Mac OS X operating systems. It has been successfully tested on computers supporting either of the 64 or 32-bit CPU architectures.

What's new in Psycopg2 2.5.4:

  • Added jsonb support for PostgreSQL 9.4 (ticket #226).
  • Fixed segfault if COPY statements are passed to execute() instead of using the proper methods (ticket #219).
  • Force conversion of pool arguments to integer to avoid potentially unbounded pools (ticket #220).
  • Cursors WITH HOLD don't begin a new transaction upon move/fetch/close (ticket #228).
Read the full changelog
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

Psycopg2 2.5.4

add to watchlist add to download basket send us an update REPORT
  runs on:
Linux
  filename:
psycopg2-2.5.2.tar.gz
  main category:
Database
  developer:
  visit homepage