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
py-schemachange Database Change Management tool for Snowflake
4.3.3 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 4.0.1Version of this port present on the latest quarterly branch.
Maintainer: patmaddox@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2023-10-22 11:30:08
Last Update: 2026-07-18 04:15:41
Commit Hash: 0b8cb47
Also Listed In: python
License: APACHE20
WWW:
https://github.com/Snowflake-Labs/schemachange
Description:
schemachange is a simple python based tool to manage all of your Snowflake objects. It follows an Imperative-style approach to Database Change Management (DCM) and was inspired by the Flyway database migration tool. When combined with a version control system and a CI/CD tool, database changes can be approved and deployed through a pipeline using modern software delivery practices. As such schemachange plays a critical role in enabling Database (or Data) DevOps.
Homepage    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}schemachange>0:databases/py-schemachange@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-schemachange/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-schemachange
  • pkg install py312-schemachange
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-schemachange listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py312-schemachange
Package flavors (<flavor>: <package>)
  • py312: py312-schemachange
distinfo:
TIMESTAMP = 1783676392 SHA256 (schemachange-4.3.3.tar.gz) = e61982bd01ecd686e3302ac82ebb5e4171fc940770cba374bd36826c198a3716 SIZE (schemachange-4.3.3.tar.gz) = 96428

Packages (timestamps in pop-ups are UTC):
py39-schemachange
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest--------
FreeBSD:14:quarterly------3.6.0-
FreeBSD:15:latest--n/a-n/an/a3.6.0-
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 
py311-schemachange
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.0.14.0.1-3.7.04.0.1n/an/an/a
FreeBSD:13:quarterly4.0.14.0.1-3.7.04.0.1n/an/an/a
FreeBSD:14:latest---3.7.0----
FreeBSD:14:quarterly---3.7.0----
FreeBSD:15:latest--n/a3.7.0n/an/a--
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 
py312-schemachange
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest4.3.34.3.3--4.3.3---
FreeBSD:14:quarterly4.0.14.0.1--4.0.1---
FreeBSD:15:latest4.3.34.3.3n/a-n/an/a--
FreeBSD:15:quarterly4.0.14.0.1n/a-n/an/a--
FreeBSD:16:latest4.3.34.3.3n/a-n/an/a--
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py312-Jinja2>=3.0<4 : devel/py-Jinja2@py312
  2. py312-pyyaml>=6.0<7 : devel/py-pyyaml@py312
  3. py312-snowflake-connector-python>=3.0<5 : databases/py-snowflake-connector-python@py312
  4. py312-structlog>=24.1.0<26 : devel/py-structlog@py312
  5. py312-hatchling>=0 : devel/py-hatchling@py312
  6. python3.12 : lang/python312
  7. py312-build>=0 : devel/py-build@py312
  8. py312-installer>=0 : devel/py-installer@py312
Test dependencies:
  1. py312-Jinja2>=3.0<4 : devel/py-Jinja2@py312
  2. py312-pyyaml>=6.0<7 : devel/py-pyyaml@py312
  3. py312-snowflake-connector-python>=3.0<5 : databases/py-snowflake-connector-python@py312
  4. py312-structlog>=24.1.0<26 : devel/py-structlog@py312
  5. py312-pytest>0 : devel/py-pytest@py312
  6. python3.12 : lang/python312
Runtime dependencies:
  1. py312-Jinja2>=3.0<4 : devel/py-Jinja2@py312
  2. py312-pyyaml>=6.0<7 : devel/py-pyyaml@py312
  3. py312-snowflake-connector-python>=3.0<5 : databases/py-snowflake-connector-python@py312
  4. py312-structlog>=24.1.0<26 : devel/py-structlog@py312
  5. python3.12 : lang/python312
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_py-schemachange
USES:
python:3.10+
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/schemachange/
  2. https://pypi.org/packages/source/s/schemachange/
Collapse this list.

Number of commits found: 8

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.3.3
18 Jul 2026 04:15:41
commit hash: 0b8cb479d17b74f8c6440187e2af2463109edebccommit hash: 0b8cb479d17b74f8c6440187e2af2463109edebccommit hash: 0b8cb479d17b74f8c6440187e2af2463109edebccommit hash: 0b8cb479d17b74f8c6440187e2af2463109edebc files touched by this commit
Pat Maddox (patmaddox) search for other commits by this committer
databases/py-schemachange: Update to 4.3.3

Switch the build backend from setuptools to hatchling, matching
upstream's move to pyproject.toml with the hatchling build system.

Changelog:
https://github.com/Snowflake-Labs/schemachange/blob/v4.3.3/CHANGELOG.md

Approved by: dch (mentor)
Closes: https://github.com/freebsd/freebsd-ports/pull/563
4.0.1
18 Oct 2025 19:28:28
commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949commit hash: 70cebc21bc2a40723b0b4d959ef0ff576eeff949 files touched by this commit
Vladimir Druzenko (vvd) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: Update 3.7.0 => 4.0.1

Changelogs:
https://github.com/Snowflake-Labs/schemachange/releases/tag/v4.0.0
https://github.com/Snowflake-Labs/schemachange/releases/tag/v4.0.1

PR:	290338
3.7.0
10 Dec 2024 09:02:55
commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22commit hash: 204b1078e41c17c5b1de8f01d2b220adc86fbf22 files touched by this commit
Robert Clausecker (fuz) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: Update to 3.7.0

Changelog: https://github.com/Snowflake-Labs/schemachange/releases/tag/v3.7.0

PR:		283121
3.6.1_1
15 Sep 2024 20:11:52
commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49commit hash: 7024f0f3480d0875f968d91a9b7fb9515f26ef49 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-schemachange: Add NO_ARCH

Approved by:	portmgr (blanket)
3.6.1_1
08 Sep 2024 18:40:26
commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044commit hash: 4ec13356ca0e992f7a253f0ea6f26faf5c329044 files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/py-schemachange: Fix RUN_DEPENDS usage

Approved by:	portmgr (blanket)
With hat:	python
3.6.1_1
07 Jul 2024 08:05:33
commit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286ecommit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286ecommit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286ecommit hash: 1a80ec7c2281900b82b228ee3a7b070c8ca4286e files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
devel/py-pyyaml: Move devel/py-yaml to devel/py-pyyaml

- Bump PORTREVISION of dependent ports for dependency change
3.6.1
06 May 2024 19:11:25
commit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763daccommit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763daccommit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763daccommit hash: a0a0e233cb7d8b88c5b839c7cabb61eab2763dac files touched by this commit
Robert Clausecker (fuz) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: Update to 3.6.1

Changelog: https://github.com/Snowflake-Labs/schemachange/releases/tag/v3.6.1

PR:		276457
3.6.0
22 Oct 2023 11:28:46
commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884commit hash: a65ea84c048e834e46c0011ff25caeed1c1ad884 files touched by this commit
Kurt Jaeger (pi) search for other commits by this committer
Author: Pat Maddox
databases/py-schemachange: new port

schemachange is a simple python based tool to manage all of your Snowflake
objects. It follows an Imperative-style approach to Database Change Management
(DCM) and was inspired by the Flyway database migration tool. When combined with
a version control system and a CI/CD tool, database changes can be approved and
deployed through a pipeline using modern software delivery practices. As such
schemachange plays a critical role in enabling Database (or Data) DevOps.

PR:		274585
Author:		Pat Maddox <pat@patmaddox.com>

Number of commits found: 8