Popularity

7.2

Stable

Activity

7.2

Declining

Stars 3,205

Watchers 73

Forks 495

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.4 6.4 psycopg2 VS django-pgtrigger

Write Postgres triggers for your Django models
queries

2.8 0.0 L5 psycopg2 VS queries

PostgreSQL database access simplified

WorkOS - The modern identity platform for B2B SaaS

The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

Promo workos.com

txpostgres

2.0 2.7 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.