databases/py-pymssql 2.4.5 FreeBSD

DB-API interface to Microsoft SQL Server for Python

System: FreeBSD
Repository: FreeBSD ports
Maintainer: [email protected]
Port added: 2026-10-26
Last update: 2026-10-26
Commit: c1021d90fd
License: LGPL21+
Categories: databases, python

Description

pymssql is a simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server. It includes the low-level _mssql module and the DB-API compliant pymssql module.

In the other systems

The newest version among them is 2.4.5, as upstream numbers it.

System

Port

Version

Vulnerabilities

Status

Maintainer

Last update

FreeBSD

databases/py-pymssql

2.4.5 newest

none known

[email protected]

2026-10-26

DragonFly

databases/py-pymssql

2.1.5_1 behind since 2026-10-26

none known

[email protected]

Version history 1

2.4.5 2026-10-26 c1021d90fd

Upstream's version as each commit to the port's Makefile set it, or as this site first saw it in the system's packages; the tree's own revisions are not versions here.

Install

Binary package:

pkg install py312-pymssql

From the ports tree:

cd /usr/ports/databases/py-pymssql/ && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	py312-pymssql>0:databases/py-pymssql

Packages

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.1.4

2.1.5_1

2.4.5

FreeBSD:14:quarterly

n/a

2.1.5_1

FreeBSD:15:latest

2.4.5

n/a

2.1.5_1

FreeBSD:15:quarterly

n/a

FreeBSD:16:latest

2.4.5

n/a

FreeBSD:16:quarterly

n/a

Dependency graph

Ports that need it on the left, what it needs to run on the right; at most 8 of each. "Dependencies" below lists them all.

graph LR
  me["databases/py-pymssql"]
  me --> d0["databases/freetds"]
  me --> d1["databases/unixODBC"]
  me --> d2["devel/gettext-runtime"]
  me --> d3["devel/libffi"]
  me --> d4["devel/readline"]
  me --> d5["lang/python312"]
  me --> d6["math/mpdecimal"]
  me --> d7["print/indexinfo"]
  me -.-> dmore(["3 more"])
  classDef this fill:#ab2b28,color:#ffffff,stroke:#ab2b28
  class me this

Dependencies

As this port's Makefile names them.

Build 4

${PYTHON_PKGNAMEPREFIX}packaging>=24.2 : devel/py-packaging
${PYTHON_PKGNAMEPREFIX}setuptools>=63 : devel/py-setuptools
${PYTHON_PKGNAMEPREFIX}setuptools-scm>=8.0 : devel/py-setuptools-scm
${PYTHON_PKGNAMEPREFIX}wheel>=0.36.2 : devel/py-wheel

Library 1

libsybdb.so : databases/freetds

The full lists below include those, and their dependencies in turn.

Build dependencies 22

Run dependencies 11

No port depends on this one.

Configuration

No options to configure.

USES: python
Service scripts: none

Files

distinfo 1

File

Size

SHA256

pymssql-2.4.5.tar.gz

212797

ada0e747bab96b6b7ee0d21ca019db6e099cda0593080f59089e182a0a14b42a

Master sites 1

PYPI

Commit history 3

Date Commit Credits Log message

2026-10-26

c1021d90fd

C. Weimann

databases/py-pymssql: Resurrect, update to 2.4.5, add maintainer

The port expired on 2026-09-15 because it depended on the expired lang/cython0. It now builds with Cython 3 (USE_PYTHON=cython) via pep517 from the PyPI sdist and links databases/freetds dynamically. Direct krb5 and OpenSSL linking is disabled. tomli and standard-distutils are pruned from the pyproject build-system requires as they are not needed. Co-authored-by: Michael Osipov <[email protected]> PR: 299747

2026-09-15

3bbe716eb0

Rene Ladan

databases/py-pymssql: Remove expired port

2026-09-15 databases/py-pymssql: Depends on expired lang/cython0

2026-07-02 88271a10b5 Rene Ladan all: schedule for removal on 2026-09-15 for lang/cython0