| Port details |
- py-sqlalchemy20 Python SQL toolkit and Object Relational Mapper 2.0.x
- 2.0.54 databases
=0 2.0.50Version of this port present on the latest quarterly branch. - Maintainer: sunpoet@FreeBSD.org
 - 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.
  ¦ ¦ ¦ ¦ 
- 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):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- py312-setuptools>=61.0 : devel/py-setuptools@py312
- py312-wheel>=0 : devel/py-wheel@py312
- py312-cython>=3.2.9 : lang/cython@py312
- python3.12 : lang/python312
- py312-build>=0 : devel/py-build@py312
- py312-installer>=0 : devel/py-installer@py312
- Test dependencies:
-
- py312-mock>=0 : devel/py-mock@py312
- py312-pytest>=2.5.2 : devel/py-pytest@py312
- py312-pytest-xdist>=0,1 : devel/py-pytest-xdist@py312
- python3.12 : lang/python312
- Runtime dependencies:
-
- py312-greenlet>=1 : devel/py-greenlet@py312
- py312-typing-extensions>=4.6.0 : devel/py-typing-extensions@py312
- py312-greenlet>=1 : devel/py-greenlet@py312
- py312-sqlite3>=0 : databases/py-sqlite3@py312
- python3.12 : lang/python312
- This port is required by:
- for Build
-
- finance/freqtrade
- games/py-pychess
- www/py-flask-dance
- for Run
-
- databases/py-PyHive
- databases/py-agate-sql
- databases/py-alembic
- databases/py-databases
- databases/py-django-pgware
- databases/py-duckdb_engine
- databases/py-flask-sqlalchemy
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:
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
2.0.54 20 Sep 2026 00:56:12
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.54
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.52 05 Sep 2026 11:48:35
    |
Yusuf Yaman (nxjoseph)  Author: Anton Saietskii |
databases/py-sqlalchemy{14,20}: Fix ASYNCIO description
PR: 296720
Reported by: Anton Saietskii <vsasjason@gmail.com> (author)
Approved by: osa, vvd (Mentors, implicit)
Approved by: portmgr (blanket)
MFH: 2026Q3 |
2.0.52 24 Aug 2026 05:16:29
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.52
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.51_1 12 Jul 2026 04:51:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Add ASYNCIO option
- Bump PORTREVISION for dependency change |
2.0.51 08 Jul 2026 13:31:06
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.51
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.50 26 Jun 2026 20:44:33
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.50
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.49 18 Apr 2026 21:51:36
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.49
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.46 03 Feb 2026 05:09:23
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.46
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.45 16 Dec 2025 21:15:47
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.45
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.44 18 Oct 2025 23:51:34
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.44
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.43 02 Sep 2025 18:00:47
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.43
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.41 25 May 2025 09:52:30
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.41
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.40 18 Apr 2025 05:37:20
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.40
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.39 19 Mar 2025 03:38:21
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.39
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.38 17 Feb 2025 08:12:12
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.38
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.37 03 Feb 2025 15:51:01
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.37
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.36 28 Jan 2025 17:04:49
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.36
- Update WWW
Changes: https://github.com/sqlalchemy/sqlalchemy/releases
https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.32 15 Aug 2024 10:55:33
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.32
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.31 03 Jul 2024 04:36:34
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.31
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.30 19 May 2024 17:15:30
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.30
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.29 31 Mar 2024 03:06:16
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.29
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.28 23 Mar 2024 14:31:10
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.28
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.27 21 Feb 2024 15:07:09
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.27
- Add PORTSCOUT
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.23 14 Nov 2023 17:15:51
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.23
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.22 16 Oct 2023 15:59:44
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.22
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.21 22 Sep 2023 03:17:53
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.21
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.20 21 Aug 2023 17:03:44
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.20
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.19 16 Aug 2023 18:25:21
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.19
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.18 18 Jul 2023 00:53:09
    |
Charlie Li (vishwin)  |
devel/py-setuptools: convert individual consumers to ${PY_SETUPTOOLS}
Currently a no-op, but in the future outputs the correct setuptools
port depending on whether USES_PYTHON=distutils is specified.
With hat: python
PR: 270510, 270358 |
2.0.18 09 Jul 2023 21:34:28
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.18
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.17 09 Jul 2023 10:18:43
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.17
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.15_1 30 Jun 2023 07:03:04
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Remove outdated PYTHON_REL check after lang/python37
removal |
2.0.15_1 27 Jun 2023 19:34:34
    |
Rene Ladan (rene)  |
all: remove explicit versions in USES=python for "3.x+"
The logic in USES=python will automatically convert this to 3.8+ by
itself.
Adjust two ports that only had Python 3.7 mentioned but build fine
on Python 3.8 too.
finance/quickfix: mark BROKEN with PYTHON
libtool: compile: c++ -DHAVE_CONFIG_H -I. -I../.. -I -I. -I.. -I../.. -I../C++
-DLIBICONV_PLUG -DPYTHON_MAJOR_VERSION=3 -Wno-unused-variable
-Wno-maybe-uninitialized -O2 -pipe -DLIBICONV_PLUG -fstack-protector-strong
-fno-strict-aliasing -DLIBICONV_PLUG -Wall -ansi
-Wno-unused-command-line-argument -Wpointer-arith -Wwrite-strings
-Wno-overloaded-virtual -Wno-deprecated-declarations -Wno-deprecated -std=c++0x
-MT _quickfix_la-QuickfixPython.lo -MD -MP -MF
.deps/_quickfix_la-QuickfixPython.Tpo -c QuickfixPython.cpp -fPIC -DPIC -o
.libs/_quickfix_la-QuickfixPython.o
warning: unknown warning option '-Wno-maybe-uninitialized'; did you mean
'-Wno-uninitialized'? [-Wunknown-warning-option]
QuickfixPython.cpp:175:11: fatal error: 'Python.h' file not found
^~~~~~~~~~
1 warning and 1 error generated.
Reviewed by: portmgr, vishwin, yuri
Differential Revision: <https://reviews.freebsd.org/D40568> |
2.0.15_1 05 Jun 2023 18:47:00
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Convert to USE_PYTHON=pep517
- Bump PORTREVISION for package change |
2.0.15 27 May 2023 23:43:51
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.15
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.13 27 May 2023 04:08:21
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.13
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.12_1 07 May 2023 16:03:44
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Convert back to USE_PYTHON=distutils temporarily
- Bump PORTREVISION for package change |
2.0.12 02 May 2023 19:58:27
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.12
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.11 02 May 2023 16:19:59
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.11
- Add missing USE_PYTHON=cython
- Convert to USE_PYTHON=pep517
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.10 27 Apr 2023 15:46:05
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.10
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.9 09 Apr 2023 20:40:08
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.9
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.8 09 Apr 2023 13:36:44
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.8
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.7 05 Apr 2023 17:30:13
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Update to 2.0.7
Changes: https://docs.sqlalchemy.org/en/20/changelog/changelog_20.html |
2.0.4 21 Mar 2023 19:19:49
    |
Po-Chuan Hsieh (sunpoet)  |
databases/py-sqlalchemy20: Add py-sqlalchemy20 2.0.4
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. |