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.
After the ports freeze to fix some stuff, the freeze is over. I have some work to do before FreshPorts can start processing commits again before it can start processing again. I've created an issue for that.
Port details on branch 2026Q3
py-sqlalchemy20 Python SQL toolkit and Object Relational Mapper 2.0.x
2.0.52 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.50Version 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-08-24 05:16:29
Commit Hash: 754500a
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 = 1787268060 SHA256 (sqlalchemy-2.0.52.tar.gz) = 5e2d46356ac2ccb7d268ab6c2319ac6a2b42f1b8d5fd8bd3d46855cd82abee97 SIZE (sqlalchemy-2.0.52.tar.gz) = 9945637

Packages (timestamps in pop-ups are UTC):
py39-sqlalchemy20
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly--2.0.15_1--n/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
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.0.492.0.49-2.0.432.0.49n/an/an/a
FreeBSD:13:quarterly2.0.462.0.46-2.0.412.0.46n/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
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest2.0.51_12.0.52--2.0.52---
FreeBSD:14:quarterly2.0.512.0.51--2.0.51---
FreeBSD:15:latest2.0.51_12.0.52n/a-n/an/a--
FreeBSD:15:quarterly2.0.512.0.51n/a-n/an/a--
FreeBSD:16:latest2.0.51_12.0.52n/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.4 : 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-duckdb_engine
  6. databases/py-flask-sqlalchemy
  7. databases/py-geoalchemy2
Expand this list (32 items / 25 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/py-marshmallow-sqlalchemy
  3. databases/py-sqlalchemy-utils
  4. databases/py-sqlmodel
  5. databases/py-squall-sql
  6. devel/py-buildbot
  7. devel/py-dataflows-tabulator
  8. devel/py-oslo.db
  9. devel/py-pytest-alembic
  10. devel/py-tabulator
  11. finance/freqtrade
  12. games/py-pychess
  13. mail/mailman3
  14. misc/comfyui
  15. misc/py-langchain-classic
  16. misc/py-langchain-community
  17. misc/py-llama-index-core
  18. misc/py-mem0ai
  19. misc/py-optuna
  20. net-im/gajim
  21. textproc/py-csvkit
  22. www/bunkerweb
  23. www/flexget
  24. www/moin2
  25. www/py-calibreweb
  26. www/py-cinemagoer
  27. Collapse this list.

Configuration Options:
===> The following configuration options are available for py312-sqlalchemy20-2.0.52: ASYNCIO=on 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 2026Q3 for this port