databases/py-psycopg2 2.9.13 FreeBSD
High performance Python adapter for PostgreSQL
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
6b5f4ad659- License
- LGPL3
- Categories
- databases, python
- Package size
- 159.9 KiB, 722.1 KiB installed
Description
psycopg2 is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being small, fast and stable. It supports the full Python DBAPI-2.0 and is thread safe.
psycopg2 is different from the other database adapter because it was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a conspicuous number of concurrent INSERTs or UPDATEs. Every open Python connection keeps a pool of real (UNIX or TCP/IP) connections to the database. Every time a new cursor is created, a new connection does not need to be opened; instead one of the unused connections from the pool is used. That makes psycopg very fast in typical client-server applications that create a servicing thread every time a client request arrives.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/py-psycopg2 | 2.9.13 |
| OpenBSD | databases/py-psycopg2 | 2.9.13p0 |
| NetBSD | databases/py-psycopg2 | 2.9.13 |
| DragonFly | databases/py-psycopg2 | 2.9.10 |
| MidnightBSD | databases/py-psycopg2 | 2.8.6_1 |
Install
Binary package:
pkg install py312-psycopg2From the ports tree:
cd /usr/ports/databases/py-psycopg2/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= py312-psycopg2>0:databases/py-psycopg2Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 2.9.13 | 2.9.13 | 2.9.5 | 2.9.10 | 2.9.13 |
| FreeBSD:14:quarterly | 2.9.13 | 2.9.13 | n/a | 2.9.10 | 2.9.13 |
| FreeBSD:15:latest | 2.9.13 | 2.9.13 | n/a | 2.9.10 | 2.9.10 |
| FreeBSD:15:quarterly | 2.9.13 | 2.9.13 | n/a | n/a | n/a |
| FreeBSD:16:latest | 2.9.13 | 2.9.13 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Build 2
${PYTHON_PKGNAMEPREFIX}setuptools>=61: devel/py-setuptools${PYTHON_PKGNAMEPREFIX}wheel>=0: devel/py-wheel
The full lists below include those, and their dependencies in turn.
Build dependencies 17
Run dependencies 10
Required by 31
- audio/py-supysonic
- databases/nagios-check_postgres_replication
- databases/pg_activity
- databases/pg_partman
- databases/pgbarman
- databases/powa-web
- databases/py-aiopg
- databases/py-pgdbconn
- databases/py-pgmigrate
- databases/py-powa-collector
- databases/py-pum
- databases/py-queries
- deskutils/py-paperless-ngx
- devel/py-azure-monitor-opentelemetry
- devel/py-odoo-addon-openupgrade-framework16
- devel/py-odoo-addon-openupgrade-framework17
- devel/py-odoo-addon-openupgrade-framework18
- devel/py-odoo-addon-openupgrade-scripts16
- devel/py-odoo-addon-openupgrade-scripts17
- devel/py-odoo-addon-openupgrade-scripts18
- devel/py-opentelemetry-instrumentation-psycopg2
- finance/odoo
- finance/odoo16
- finance/odoo17
- finance/odoo18
- graphics/qgis
- graphics/qgis-ltr
- net-im/py-matrix-synapse
- net-mgmt/peering-manager
- net/irrd
- www/py-django-netfields
Configuration
No options to configure.
- USES
- pgsql python
- Service scripts
- none
Files
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| psycopg2-2.9.13.tar.gz | 378068 | d36784fc2dae69523ba4b79c7d1d1b4d6e83e87836874f111262f4db940b16a6 |
Master sites 1
- PYPI