notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Volunteers wanted to help translate FreshPorts
Port details on branch 2026Q4
py-sqlalchemy20 Python SQL toolkit and Object Relational Mapper 2.0.x
2.0.54 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.0.54Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2023-03-21 19:24:14
Last Update: 2026-09-20 00:56:12
Commit Hash: 261e702
Also Listed In: python
License: MIT
WWW:
https://www.sqlalchemy.org/
https://docs.sqlalchemy.org/en/20/
https://github.com/sqlalchemy/sqlalchemy
Description:
The Python SQL Toolkit and Object Relational Mapper SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.
HomepageHomepageHomepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}sqlalchemy20>0:databases/py-sqlalchemy20@${PY_FLAVOR}
Conflicts:
CONFLICTS_INSTALL:
  • py312-sqlalchemy[0-9][0-9]
To install the port:
cd /usr/ports/databases/py-sqlalchemy20/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-sqlalchemy20
  • pkg install py312-sqlalchemy20
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py312-sqlalchemy20 listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py312-sqlalchemy20
Package flavors (<flavor>: <package>)
  • py312: py312-sqlalchemy20
distinfo:
TIMESTAMP = 1789834558 SHA256 (sqlalchemy-2.0.54.tar.gz) = baa8521e8ee9f24e75dfc7aaabc08020e551ef0d48d7c3e3536f5cddf277586b SIZE (sqlalchemy-2.0.54.tar.gz) = 9969559

Packages (timestamps in pop-ups are UTC):
py39-sqlalchemy20
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64leriscv64
FreeBSD:13:latest--n/an/an/an/an/an/an/a
FreeBSD:13:quarterly--n/an/an/an/an/an/an/a
FreeBSD:14:latest-----2.0.15_1-2.0.15_1-
FreeBSD:14:quarterly-----2.0.232.0.232.0.23-
FreeBSD:15:latest--n/a-n/an/a2.0.232.0.27-
FreeBSD:15:quarterly--n/a-n/an/a---
FreeBSD:16:latest--n/a-n/an/a---
 
py311-sqlalchemy20
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64leriscv64
FreeBSD:13:latest2.0.492.0.49n/an/an/an/an/an/an/a
FreeBSD:13:quarterly2.0.462.0.46n/an/an/an/an/an/an/a
FreeBSD:14:latest---2.0.41-----
FreeBSD:14:quarterly---2.0.41-----
FreeBSD:15:latest--n/a2.0.41n/an/a---
FreeBSD:15:quarterly--n/a-n/an/a---
FreeBSD:16:latest--n/a-n/an/a---
 
py312-sqlalchemy20
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64leriscv64
FreeBSD:13:latest--n/an/an/an/an/an/an/a
FreeBSD:13:quarterly--n/an/an/an/an/an/an/a
FreeBSD:14:latest2.0.542.0.54--2.0.54----
FreeBSD:14:quarterly2.0.512.0.51--2.0.54----
FreeBSD:15:latest2.0.542.0.54n/a-n/an/a---
FreeBSD:15:quarterly2.0.542.0.51n/a-n/an/a---
FreeBSD:16:latest2.0.542.0.54n/a-n/an/a---
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py312-setuptools>=61.0 : devel/py-setuptools@py312
  2. py312-wheel>=0 : devel/py-wheel@py312
  3. py312-cython>=3.2.9 : lang/cython@py312
  4. python3.12 : lang/python312
  5. py312-build>=0 : devel/py-build@py312
  6. py312-installer>=0 : devel/py-installer@py312
Test dependencies:
  1. py312-mock>=0 : devel/py-mock@py312
  2. py312-pytest>=2.5.2 : devel/py-pytest@py312
  3. py312-pytest-xdist>=0,1 : devel/py-pytest-xdist@py312
  4. python3.12 : lang/python312
Runtime dependencies:
  1. py312-greenlet>=1 : devel/py-greenlet@py312
  2. py312-typing-extensions>=4.6.0 : devel/py-typing-extensions@py312
  3. py312-greenlet>=1 : devel/py-greenlet@py312
  4. py312-sqlite3>=0 : databases/py-sqlite3@py312
  5. python3.12 : lang/python312
This port is required by:
for Build
  1. finance/freqtrade
  2. games/py-pychess
  3. www/py-flask-dance
for Run
  1. databases/py-PyHive
  2. databases/py-agate-sql
  3. databases/py-alembic
  4. databases/py-databases
  5. databases/py-django-pgware
  6. databases/py-duckdb_engine
  7. databases/py-flask-sqlalchemy
Expand this list (35 items / 28 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/py-geoalchemy2
  3. databases/py-marshmallow-sqlalchemy
  4. databases/py-sqlalchemy-utils
  5. databases/py-sqlmodel
  6. databases/py-squall-sql
  7. devel/py-buildbot
  8. devel/py-dataflows-tabulator
  9. devel/py-oslo.db
  10. devel/py-pytest-alembic
  11. devel/py-tabulator
  12. finance/freqtrade
  13. games/py-pychess
  14. mail/mailman3
  15. misc/comfyui
  16. misc/py-langchain-classic
  17. misc/py-langchain-community
  18. misc/py-llama-index-core
  19. misc/py-mem0ai
  20. misc/py-optuna
  21. net-im/gajim
  22. science/py-psims
  23. science/py-pyteomics
  24. security/py-nettacker
  25. textproc/py-csvkit
  26. www/bunkerweb
  27. www/flexget
  28. www/moin2
  29. www/py-calibreweb
  30. Collapse this list.

Configuration Options:
===> The following configuration options are available for py312-sqlalchemy20-2.0.54: ASYNCIO=on: Use asyncio drivers DOCS=on: Build and/or install documentation EXAMPLES=on: Build and/or install examples ====> Options available for the multi BACKEND: you have to choose at least one of them MSSQL=off: Microsoft SQL Server support MYSQL=off: MySQL database support PGSQL=off: PostgreSQL database support SQLITE=on: SQLite database support ===> Use 'make config' to modify these settings
Options name:
databases_py-sqlalchemy20
USES:
cpe python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/s/sqlalchemy/
  2. https://pypi.org/packages/source/s/sqlalchemy/
Collapse this list.

There are no commits on branch 2026Q4 for this port