Popularity

7.1

Growing

Activity

5.3

Declining

Stars 2,901

Watchers 74

Forks 475

Last Commit 18 days ago

Description

Psycopg is the most popular PostgreSQL database adapter for the Python programming language. Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent "INSERT"s or "UPDATE"s.

Psycopg 2 is mostly implemented in C as a libpq wrapper, resulting in being both efficient and secure. It features client-side and server-side cursors, asynchronous communication and notifications, "COPY TO/COPY FROM" support. Many Python types are supported out-of-the-box and adapted to matching PostgreSQL data types; adaptation can be extended and customized thanks to a flexible objects adaptation system.

Psycopg 2 is both Unicode and Python 3 friendly.

Code Quality Rank: L3

Programming language: C

License: GNU General Public License v3.0 or later

Tags: Database Drivers PostgreSQL

psycopg2 alternatives and similar packages

Based on the "PostgreSQL" category.
Alternatively, view psycopg2 alternatives based on common mentions on social networks and blogs.

django-pgtrigger

3.0 8.6 psycopg2 VS django-pgtrigger

Write Postgres triggers for your Django models
queries

2.7 1.4 L5 psycopg2 VS queries

PostgreSQL database access simplified

Write Clean Python Code. Always.

Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

Promo www.sonarsource.com

txpostgres

2.0 0.0 L4 psycopg2 VS txpostgres

Twisted wrapper for asynchronous PostgreSQL connections
Python PG Extras

1.2 0.0 psycopg2 VS Python PG Extras

Python PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.