BSD Portsdatabases/py-sqlalchemy20 2.0.54 FreeBSD
Python SQL toolkit and Object Relational Mapper 2.0.x
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
261e702ef5- License
- MIT
- Categories
- databases, python
- Package size
- 7071.1 KiB, 70033.5 KiB installed
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.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/py-sqlalchemy20 | 2.0.54 |
| DragonFly | databases/py-sqlalchemy20 | 2.0.39 |
| MidnightBSD | databases/py-sqlalchemy20 | 2.0.31_1 |
Install
Binary package:
pkg install py312-sqlalchemy20From the ports tree:
cd /usr/ports/databases/py-sqlalchemy20/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= py312-sqlalchemy20>0:databases/py-sqlalchemy20Packages
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.0.54 | 2.0.54 | - | 2.0.41 | 2.0.54 |
| FreeBSD:14:quarterly | 2.0.54 | 2.0.54 | n/a | 2.0.41 | 2.0.54 |
| FreeBSD:15:latest | 2.0.54 | 2.0.54 | n/a | 2.0.41 | 2.0.41 |
| FreeBSD:15:quarterly | 2.0.54 | 2.0.54 | n/a | n/a | n/a |
| FreeBSD:16:latest | 2.0.54 | 2.0.54 | 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.0: devel/py-setuptools${PYTHON_PKGNAMEPREFIX}wheel>=0: devel/py-wheel
Runtime 2
${PYTHON_PKGNAMEPREFIX}greenlet>=1: devel/py-greenlet${PYTHON_PKGNAMEPREFIX}typing-extensions>=4.6.0: devel/py-typing-extensions
Test 3
${PYTHON_PKGNAMEPREFIX}mock>=0: devel/py-mock${PYTHON_PKGNAMEPREFIX}pytest>=2.5.2: devel/py-pytest${PYTHON_PKGNAMEPREFIX}pytest-xdist>=0,1: devel/py-pytest-xdist
The full lists below include those, and their dependencies in turn.
Build dependencies 17
Run dependencies 17
Required by 88
- biology/biostar-tools
- 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
- databases/py-geoalchemy2
- databases/py-marshmallow-sqlalchemy
- databases/py-ormar
- databases/py-sqlalchemy-utils
- databases/py-sqlmodel
- databases/py-squall-sql
- databases/py-tableschema
- deskutils/py-qmd
- devel/py-buildbot
- devel/py-dataflows-tabulator
- devel/py-datapackage
- devel/py-oslo.db
- devel/py-pytest-alembic
- devel/py-tabulator
- finance/freqtrade
- games/py-pychess
- graphics/py-olmocr
- mail/mailman3
- misc/colibri
- misc/comfyui
- misc/py-compressed-tensors
- misc/py-kokoro
- misc/py-langchain-classic
- misc/py-langchain-community
- misc/py-llama-index-core
- misc/py-llama-index-embeddings-huggingface
- misc/py-llama-index-llms-ibm
- misc/py-llama-index-llms-openai
- misc/py-llama-index-llms-openai-like
- misc/py-mem0ai
- misc/py-optimum
- misc/py-optuna
- misc/py-peft
- misc/py-sentence-transformers
- misc/py-transformers
- misc/py-vllm
- misc/py-xgrammar
- misc/snakemake
- net-im/gajim
- net/irrd
- science/py-psims
- science/py-pyteomics
- security/py-nettacker
- textproc/py-csvkit
- textproc/py-docling
- textproc/py-docling-agent
- textproc/py-docling-analysis-framework
- textproc/py-docling-core
- textproc/py-docling-cvat-tools
- textproc/py-docling-demo
- textproc/py-docling-enhanced
- textproc/py-docling-enhanced-onnx
- textproc/py-docling-eval
- textproc/py-docling-glm-ocr
- textproc/py-docling-google-ocr
- textproc/py-docling-graph
- textproc/py-docling-haystack
- textproc/py-docling-hierarchical-pdf
- textproc/py-docling-ibm-models
- textproc/py-docling-jobkit
- textproc/py-docling-langchain
- textproc/py-docling-litellm-picture-description
- textproc/py-docling-mcp
- textproc/py-docling-ocr
- textproc/py-docling-ocr-mistral
- textproc/py-docling-ocr-onnxtr
- textproc/py-docling-parse
- textproc/py-docling-sdg
- textproc/py-docling-serve
- textproc/py-docling-slim
- textproc/py-extended-docling
- textproc/py-langchain-docling
- www/bunkerweb
- www/flexget
- www/moin2
- www/py-calibreweb
- www/py-flask-dance
- www/py-flask-migrate
- www/py-mailman-hyperkitty
- www/py-yubal-api
Configuration
Options name: databases_sqlalchemy
| Option | Default | Description |
|---|---|---|
| ASYNCIO | on | Use asyncio drivers |
| DOCS | off | Build and/or install documentation |
| EXAMPLES | off | Build and/or install examples |
| MSSQL | off | Microsoft SQL Server support |
| MYSQL | off | MySQL database support |
| PGSQL | off | PostgreSQL database support |
| SQLITE | on | SQLite database support |
- USES
- cpe python
- Service scripts
- none
- Conflicts with
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy[0-9][0-9]
Files
pkg-plist 538
- share/doc/py312-sqlalchemy20/_images/sqla_arch_small.png
- share/doc/py312-sqlalchemy20/_images/sqla_engine_arch.png
- share/doc/py312-sqlalchemy20/_modules/examples/adjacency_list/adjacency_list.html
- share/doc/py312-sqlalchemy20/_modules/examples/association/basic_association.html
- share/doc/py312-sqlalchemy20/_modules/examples/association/dict_of_sets_with_default.html
- share/doc/py312-sqlalchemy20/_modules/examples/association/proxied_association.html
- share/doc/py312-sqlalchemy20/_modules/examples/asyncio/async_orm.html
- share/doc/py312-sqlalchemy20/_modules/examples/asyncio/async_orm_writeonly.html
- share/doc/py312-sqlalchemy20/_modules/examples/asyncio/basic.html
- share/doc/py312-sqlalchemy20/_modules/examples/asyncio/gather_orm_statements.html
- share/doc/py312-sqlalchemy20/_modules/examples/asyncio/greenlet_orm.html
- share/doc/py312-sqlalchemy20/_modules/examples/custom_attributes/active_column_defaults.html
- share/doc/py312-sqlalchemy20/_modules/examples/custom_attributes/custom_management.html
- share/doc/py312-sqlalchemy20/_modules/examples/custom_attributes/listen_for_events.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/advanced.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/caching_query.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/environment.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/fixture_data.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/helloworld.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/local_session_caching.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/model.html
- share/doc/py312-sqlalchemy20/_modules/examples/dogpile_caching/relationship_caching.html
- share/doc/py312-sqlalchemy20/_modules/examples/dynamic_dict/dynamic_dict.html
- share/doc/py312-sqlalchemy20/_modules/examples/extending_query/filter_public.html
- share/doc/py312-sqlalchemy20/_modules/examples/extending_query/temporal_range.html
- share/doc/py312-sqlalchemy20/_modules/examples/generic_associations/discriminator_on_association.html
- share/doc/py312-sqlalchemy20/_modules/examples/generic_associations/generic_fk.html
- share/doc/py312-sqlalchemy20/_modules/examples/generic_associations/table_per_association.html
- share/doc/py312-sqlalchemy20/_modules/examples/generic_associations/table_per_related.html
- share/doc/py312-sqlalchemy20/_modules/examples/graphs/directed_graph.html
- share/doc/py312-sqlalchemy20/_modules/examples/inheritance/concrete.html
- share/doc/py312-sqlalchemy20/_modules/examples/inheritance/joined.html
- share/doc/py312-sqlalchemy20/_modules/examples/inheritance/single.html
- share/doc/py312-sqlalchemy20/_modules/examples/materialized_paths/materialized_paths.html
- share/doc/py312-sqlalchemy20/_modules/examples/nested_sets/nested_sets.html
- share/doc/py312-sqlalchemy20/_modules/examples/performance/__main__.html
- share/doc/py312-sqlalchemy20/_modules/examples/performance/bulk_inserts.html
- share/doc/py312-sqlalchemy20/_modules/examples/performance/bulk_updates.html
- share/doc/py312-sqlalchemy20/_modules/examples/performance/large_resultsets.html
- share/doc/py312-sqlalchemy20/_modules/examples/performance/short_selects.html
- share/doc/py312-sqlalchemy20/_modules/examples/performance/single_inserts.html
- share/doc/py312-sqlalchemy20/_modules/examples/sharding/asyncio.html
- share/doc/py312-sqlalchemy20/_modules/examples/sharding/separate_databases.html
- share/doc/py312-sqlalchemy20/_modules/examples/sharding/separate_schema_translates.html
- share/doc/py312-sqlalchemy20/_modules/examples/sharding/separate_tables.html
- share/doc/py312-sqlalchemy20/_modules/examples/space_invaders/space_invaders.html
- share/doc/py312-sqlalchemy20/_modules/examples/versioned_history/history_meta.html
- share/doc/py312-sqlalchemy20/_modules/examples/versioned_history/test_versioning.html
- share/doc/py312-sqlalchemy20/_modules/examples/versioned_rows/versioned_map.html
- share/doc/py312-sqlalchemy20/_modules/examples/versioned_rows/versioned_rows.html
- share/doc/py312-sqlalchemy20/_modules/examples/versioned_rows/versioned_rows_w_versionid.html
- share/doc/py312-sqlalchemy20/_modules/examples/versioned_rows/versioned_update_old_row.html
- share/doc/py312-sqlalchemy20/_modules/examples/vertical/dictlike-polymorphic.html
- share/doc/py312-sqlalchemy20/_modules/examples/vertical/dictlike.html
- share/doc/py312-sqlalchemy20/_modules/index.html
- share/doc/py312-sqlalchemy20/_static/_sphinx_javascript_frameworks_compat.js
- share/doc/py312-sqlalchemy20/_static/annotated.png
- share/doc/py312-sqlalchemy20/_static/base-stemmer.js
- share/doc/py312-sqlalchemy20/_static/basic.css
- share/doc/py312-sqlalchemy20/_static/changelog.css
- share/doc/py312-sqlalchemy20/_static/clipboard.min.js
- share/doc/py312-sqlalchemy20/_static/copybutton.css
- share/doc/py312-sqlalchemy20/_static/copybutton.js
- share/doc/py312-sqlalchemy20/_static/copybutton_funcs.js
- share/doc/py312-sqlalchemy20/_static/deepalchemy.png
- share/doc/py312-sqlalchemy20/_static/deepalchemy_original.png
- share/doc/py312-sqlalchemy20/_static/docs.css
- share/doc/py312-sqlalchemy20/_static/doctools.js
- share/doc/py312-sqlalchemy20/_static/documentation_options.js
- share/doc/py312-sqlalchemy20/_static/dragons.png
- share/doc/py312-sqlalchemy20/_static/dragons_original.png
- share/doc/py312-sqlalchemy20/_static/english-stemmer.js
- share/doc/py312-sqlalchemy20/_static/file.png
- share/doc/py312-sqlalchemy20/_static/init.js
- share/doc/py312-sqlalchemy20/_static/jquery.js
- share/doc/py312-sqlalchemy20/_static/language_data.js
- share/doc/py312-sqlalchemy20/_static/minus.png
- share/doc/py312-sqlalchemy20/_static/nonannotated.png
- share/doc/py312-sqlalchemy20/_static/plus.png
- share/doc/py312-sqlalchemy20/_static/pygments.css
- share/doc/py312-sqlalchemy20/_static/searchtools.js
- share/doc/py312-sqlalchemy20/_static/sphinx_highlight.js
- share/doc/py312-sqlalchemy20/_static/sphinx_paramlinks.css
- share/doc/py312-sqlalchemy20/build/Makefile
- share/doc/py312-sqlalchemy20/build/changelog/README.txt
- share/doc/py312-sqlalchemy20/build/changelog/changelog_01.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_02.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_03.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_04.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_05.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_06.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_07.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_08.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_09.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_10.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_11.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_12.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_13.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_14.rst
- share/doc/py312-sqlalchemy20/build/changelog/changelog_20.rst
The first 100 are listed.
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| sqlalchemy-2.0.54.tar.gz | 9.969559e+06 | baa8521e8ee9f24e75dfc7aaabc08020e551ef0d48d7c3e3536f5cddf277586b |
Master sites 1
- PYPI
Commit history 5
| Date | Commit | Credits | Log message |
|---|---|---|---|
261e702ef5 |
Po-Chuan Hsieh | 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 |
|
5293821ced |
Anton Saietskii | databases/py-sqlalchemy{14,20}: Fix ASYNCIO description PR: 296720
Reported by: Anton Saietskii <[email protected]> (author)
Approved by: osa, vvd (Mentors, implicit)
Approved by: portmgr (blanket)
MFH: 2026Q3 |
|
754500acad |
Po-Chuan Hsieh | 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 |
|
5495daecac |
Po-Chuan Hsieh | databases/py-sqlalchemy20: Add ASYNCIO option - Bump PORTREVISION for dependency change |
|
bfde97e540 |
Po-Chuan Hsieh | 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 |