notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
py-pyodbc ODBC connections for python
4.0.30 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port 4.0.30Version of this port present on the latest quarterly branch.
Maintainer: search for ports maintained by this maintainer
Port Added: 2017-07-18 23:40:28
Last Update: 2020-02-25 02:28:50
SVN Revision: 527059
Also Listed In: python
License: MIT
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • py37-pyodbc>0:databases/py-pyodbc
To install the port: cd /usr/ports/databases/py-pyodbc/ && make install clean
To add the package: pkg install py37-pyodbc
PKGNAME: py37-pyodbc
Package flavors (<flavor>: <package>)
  • py37: py37-pyodbc
  • py27: py27-pyodbc

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. unixODBC>=2.2.14 : databases/unixODBC
  2. py37-setuptools>0 : devel/py-setuptools@py37
  3. python3.7 : lang/python37
Runtime dependencies:
  1. py37-setuptools>0 : devel/py-setuptools@py37
  2. python3.7 : lang/python37
Library dependencies:
  1. : databases/unixODBC
There are no ports dependent upon this port

Configuration Options


Master Sites:
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2017-11-30
    Affects: */py*
      Ports using Python via USES=python are now flavored.  All the py3-* ports
      have been removed and folded into their py-* master ports.
      People using Poudriere 3.2+ and binary packages do not have to do anything.
      For other people, to build the Python 3.6 version of, for example,
      databases/py-gdbm, you need to run:
        # make FLAVOR=py36 install
Port Moves
  • port moved here from databases/py-odbc on 2017-07-18
    REASON: Rename to comply with PyPI scheme

Number of commits found: 4

Commit History - (may be incomplete: see SVNWeb link above for full details)
25 Feb 2020 02:28:50
Original commit files touched by this commit  4.0.30
rigoletto search for other commits by this committer
databases/py-pyodbc: Update to 4.0.30

PR:		244284
Submitted by:	Robert Kruus <> (maintainer)
Approved by:	tcberner (mentor, implicit)
27 Oct 2018 06:00:24
Original commit files touched by this commit  4.0.24
wen search for other commits by this committer
- Update to 4.0.24

PR:		232567
Submitted by:
17 Nov 2017 08:15:04
Original commit files touched by this commit  4.0.21
wen search for other commits by this committer
- Update to 4.0.21

PR:		223711
Submitted by:
18 Jul 2017 23:40:21
Original commit files touched by this commit  4.0.17
dbaio search for other commits by this committer
databases/py-odbc: Update to 4.0.17, Rename to databases/py-pyodbc

Rename to comply with PyPI scheme

While here:
 - Switch to USES=localbase and remove a patch that does the same

PR:		220305
Submitted by: (maintainer)
Approved by:	garga (mentor)
Differential Revision:

Number of commits found: 4

User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
How big is it?
The latest upgrade!

Enter Keywords:

Latest Vulnerabilities
apache24Apr 02
cactiApr 02
chromiumApr 02
haproxyApr 02
haproxy18Apr 02
haproxy19Apr 02
haproxy21Apr 02
rubygem-json*Apr 02
gnutlsMar 31
postgresql10-serverMar 29
postgresql11-serverMar 29
postgresql12-serverMar 29
postgresql96-serverMar 29
gitlab-ceMar 26
jenkinsMar 25

12 vulnerabilities affecting 110 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-04-02 20:42:28

Deleted ports
Sanity Test Failures

NEW Graphs (Javascript)

Calculated hourly:
Port count 39062
Broken 587
Deprecated 1065
Ignore 858
Forbidden 5
Restricted 151
Vulnerable 22
Expired 2
Set to expire 1033
Interactive 0
new 24 hours 7
new 48 hours18
new 7 days55
new fortnight118
new month184

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.