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.
Port details on branch 2024Q3
py-apsw Another Python SQLite Wrapper
3.53.1.0 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 3.50.4.0Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2013-09-12 11:44:16
Last Update: 2026-05-26 04:55:57
Commit Hash: 37cb05b
Also Listed In: python
License: ZLIB
WWW:
https://rogerbinns.github.io/apsw/
https://github.com/rogerbinns/apsw
Description:
APSW provides an SQLite 3 wrapper that provides the thinnest layer over the SQLite database library possible. Everything you can do from the SQLite C API, you can do from Python. Although APSW looks vaguely similar to the PEP 249 (DBAPI), it is not compliant with that API because instead it works the way SQLite 3 does.
HomepageHomepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

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}apsw>0:databases/py-apsw@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-apsw/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-apsw
  • pkg install py311-apsw
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 py311-apsw listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-apsw
Package flavors (<flavor>: <package>)
  • py311: py311-apsw
distinfo:
TIMESTAMP = 1779455657 SHA256 (apsw-3.53.1.0.tar.gz) = 4f8978ae8c7c405d0133a6ea590f3342f839143bdf39e46029cb36e2fa418692 SIZE (apsw-3.53.1.0.tar.gz) = 1242069

Packages (timestamps in pop-ups are UTC):
py37-apsw
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--3.33.0--n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/an/a--
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 

py39-apsw
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly--3.42.0.0--n/an/an/a
FreeBSD:14:latest--3.38.5--3.42.0.0-3.42.0.0
FreeBSD:14:quarterly-----3.44.0.03.44.0.03.44.0.0
FreeBSD:15:latest--n/a-n/an/a3.44.0.03.45.1.0
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 

py311-apsw
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.4.03.50.4.0-3.50.4.03.50.4.0n/an/an/a
FreeBSD:13:quarterly3.50.4.03.50.4.0-3.46.1.03.50.4.0n/an/an/a
FreeBSD:14:latest---3.50.3.0----
FreeBSD:14:quarterly3.50.4.03.50.4.0-3.46.1.03.50.4.0---
FreeBSD:15:latest--n/a3.50.3.0n/an/a--
FreeBSD:15:quarterly3.50.4.03.50.4.0n/a-n/an/a--
FreeBSD:16:latest3.53.1.0-n/a-n/an/a--
 

py312-apsw
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest3.53.1.03.53.1.0--3.53.1.0---
FreeBSD:14:quarterly--------
FreeBSD:15:latest3.53.1.03.53.1.0n/a-n/an/a--
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest-3.53.1.0n/a-n/an/a--
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-setuptools>=0 : devel/py-setuptools@py311
  2. py311-wheel>=0 : devel/py-wheel@py311
  3. sqlite3>=3.53,1 : databases/sqlite3
  4. python3.11 : lang/python311
  5. py311-build>=0 : devel/py-build@py311
  6. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. python3.11 : lang/python311
Library dependencies:
  1. libsqlite3.so : databases/sqlite3
This port is required by:
for Build
  1. deskutils/calibre

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. net/s3ql*
  2. Collapse this list of deleted ports.
for Run
  1. databases/py-apswutils
  2. deskutils/calibre

Deleted ports which required this port:

Expand this list of 2 deleted ports
  1. net/s3ql*
  2. net-p2p/tribler*
  3. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options:
No options to configure
Options name:
databases_py-apsw
USES:
localbase python sqlite
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/a/apsw/
  2. https://pypi.org/packages/source/a/apsw/
Collapse this list.

There are no commits on branch 2024Q3 for this port