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

/commits.php is going away

I'm proposing to take /commits.php away - it mainly duplicates the home page. Details in this GitHub issue.
Port details
py-apsw Another Python SQLite Wrapper
3.35.4_1 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.35.4_1Version 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: 2021-09-21 03:44:16
Commit Hash: c31d852
Also Listed In: python
License: ZLIB
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
There is no configure plist information 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 py38-apsw
NOTE: This is a Python port. Instead of py38-apsw listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py38-apsw
Package flavors (<flavor>: <package>)
  • py38: py38-apsw
distinfo:
Packages (timestamps in pop-ups are UTC):
py27-apsw
ABIlatestquarterly
FreeBSD:11:aarch643.24.03.32.2
FreeBSD:11:amd64--
FreeBSD:11:armv63.13.03.32.2
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips643.13.03.32.2
FreeBSD:12:aarch643.24.0-
FreeBSD:12:amd64--
FreeBSD:12:armv63.24.03.33.0
FreeBSD:12:armv73.24.03.33.0
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips643.24.03.32.2
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py36-apsw
ABIlatestquarterly
FreeBSD:11:aarch643.24.0-
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch643.24.0-
FreeBSD:12:amd64--
FreeBSD:12:armv63.24.0-
FreeBSD:12:armv73.24.0-
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips643.24.0-
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py37-apsw
ABIlatestquarterly
FreeBSD:11:aarch64-3.32.2
FreeBSD:11:amd64--
FreeBSD:11:armv6-3.32.2
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64-3.32.2
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6-3.33.0
FreeBSD:12:armv7-3.33.0
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64-3.32.2
FreeBSD:12:powerpc64-3.34.0
FreeBSD:13:aarch643.33.0-
FreeBSD:13:amd64--
FreeBSD:13:armv63.33.03.34.0
FreeBSD:13:armv73.33.03.34.0
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc643.33.0-
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv63.34.0-
FreeBSD:14:armv73.34.0-
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc643.34.0-
 
py38-apsw
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd643.35.4_13.35.4
FreeBSD:11:armv6--
FreeBSD:11:i3863.35.4_13.35.4
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64-3.35.4_1
FreeBSD:12:amd643.35.4_13.35.4_1
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i3863.35.4_13.35.4_1
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64-3.35.4_1
FreeBSD:13:amd643.35.4_13.35.4_1
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i3863.35.4_13.35.4_1
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64-3.35.4
FreeBSD:14:aarch643.35.4_1-
FreeBSD:14:amd643.35.4_1-
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i3863.35.4_1-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. sqlite3>=3.35,1 : databases/sqlite3
  2. py38-setuptools>0 : devel/py-setuptools@py38
  3. python3.8 : lang/python38
Runtime dependencies:
  1. py38-setuptools>0 : devel/py-setuptools@py38
  2. python3.8 : lang/python38
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. 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:
Options name:

USES:

FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://github.com/rogerbinns/apsw/releases/download/3.35.4-r1/
Collapse this list.
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2016-06-19
    Affects: users of databases/py-apsw
    Author: rm@FreeBSD.org
    Reason: 
      SQLite 3.12 completely changed the semantics of VFS.xGetLastError() in an
      incompatible way. This required a rewrite of the relevant C, Python and test
      code. If you implement or use this method then you have to rewrite your code
      too. Also note that running the test suite from an earlier version of APSW
      against this or future SQLite versions will result in consuming all memory,
      swap or address space (an underlying integer changed meaning).
    
    

Number of commits found: 43

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
21 Sep 2021 03:44:16
 files touched by this commit commit hash:c31d852e00d1f0ddf680659e3bed126c4dcb330a  3.35.4_1
sunpoet search for other commits by this committer
databases/py-apsw: Cosmetic change
20 Jul 2021 14:28:42
 files touched by this commit commit hash:da566bc8534e93a6c9c15e3db46c315d3cd96a62  3.35.4_1
madpilot search for other commits by this committer
databases/py-apsw: Add option to enable EXTENSION loading.

The new option adds support to load DB extensions at runtime.

The option is enabled by default because it is required by the
latest version of deskutils/calibre.

PR:		257111
Approved by:	sunpoet (maintainer)
02 May 2021 19:44:37
 files touched by this commit commit hash:e993c1653620e2bd5df81635e0f6a6259b7a90db  3.35.4
sunpoet search for other commits by this committer
databases/py-apsw: Update to 3.35.4

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  3.34.0
mat search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
30 Jan 2021 12:23:01
Original commit files touched by this commit Revision:563316  3.34.0
sunpoet search for other commits by this committer
Update to 3.34.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
28 Dec 2020 23:02:15
Original commit files touched by this commit Revision:559531  3.33.0
antoine search for other commits by this committer
Drop python 2.7 support from a few ports

With hat:	portmgr
24 Dec 2020 13:46:02
Original commit files touched by this commit Revision:559094  3.33.0
kai search for other commits by this committer
Relax hardcoded paths to fix build with Python 3.8.7

Since r558913 Python 3.8 incorporates BPO-42604 [1] which changed the
shared libs naming scheme.  This means "EXT_SUFFIX" is now derived from
SOABI and yields with Python 3.8 to ".cpython-38.so" instead of ".so".

The affected ports strip the libaries in the "post-install" target via
hardcoded path(s) and the build fails at the end because the new extension
is not expected at this place.

Remedy the issue by adding wildcards to these paths.  This should also
prepare the ports for future Python releases, which will use the new shared
libs naming scheme.

[1] https://bugs.python.org/issue42604

PR:		252057
Reported by:	John Kennedy
Reviewed by:	fluffy, koobs
Approved by:	koobs (python)
19 Dec 2020 20:09:02
Original commit files touched by this commit Revision:558519  3.33.0
sunpoet search for other commits by this committer
Use upstream asset instead of source tarball

- Bump PORTREVISION for package change
05 Sep 2020 10:09:21
Original commit files touched by this commit Revision:547617  3.33.0
sunpoet search for other commits by this committer
Update to 3.33.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
15 Jun 2020 18:46:34
Original commit files touched by this commit Revision:538972  3.32.2
sunpoet search for other commits by this committer
Update to 3.32.2

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
24 Apr 2020 18:03:03
Original commit files touched by this commit Revision:532825  3.31.1
sunpoet search for other commits by this committer
Update BUILD_DEPENDS: chase PORTEPOCH bump in r524241
22 Apr 2020 21:26:23
Original commit files touched by this commit Revision:532526  3.31.1
sunpoet search for other commits by this committer
Update to 3.31.1

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
13 Nov 2019 23:34:11
Original commit files touched by this commit Revision:517441  3.30.1
sunpoet search for other commits by this committer
Update to 3.30.1

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
01 Oct 2019 19:15:43
Original commit files touched by this commit Revision:513510  3.29.0
sunpoet search for other commits by this committer
Update to 3.29.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
11 Jun 2019 20:19:32
Original commit files touched by this commit Revision:503978  3.28.0
sunpoet search for other commits by this committer
Update to 3.28.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
07 Mar 2019 17:31:54
Original commit files touched by this commit Revision:494968  3.27.2
sunpoet search for other commits by this committer
Update to 3.27.2

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
09 Jan 2019 14:51:50
Original commit files touched by this commit Revision:489786  3.26.0
sunpoet search for other commits by this committer
Update to 3.26.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
05 Nov 2018 21:44:31
Original commit files touched by this commit Revision:484235  3.25.2
sunpoet search for other commits by this committer
Update to 3.25.2

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
29 Jul 2018 19:15:10
Original commit files touched by this commit Revision:475729  3.24.0
sunpoet search for other commits by this committer
Update to 3.24.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
15 May 2018 23:59:17
Original commit files touched by this commit Revision:470073  3.23.1
sunpoet search for other commits by this committer
Update to 3.23.1

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
15 Mar 2018 17:45:37
Original commit files touched by this commit Revision:464605  3.22.0
sunpoet search for other commits by this committer
Update to 3.22.0

- Add BUILD_DEPENDS: check SQLite version

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
30 Nov 2017 15:50:34
Original commit files touched by this commit Revision:455210  3.21.0  Sanity Test Failure
mat search for other commits by this committer
Convert Python ports to FLAVORS.

  Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
13 Nov 2017 19:35:45
Original commit files touched by this commit Revision:454135  3.21.0
sunpoet search for other commits by this committer
Update to 3.21.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
28 Aug 2017 19:18:01
Original commit files touched by this commit Revision:448875  3.20.1
sunpoet search for other commits by this committer
Update to 3.20.1

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
26 Jun 2017 19:35:38
Original commit files touched by this commit Revision:444383  3.19.3
sunpoet search for other commits by this committer
Update to 3.19.3

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
29 Apr 2017 07:50:50
Original commit files touched by this commit Revision:439738  3.18.0
sunpoet search for other commits by this committer
Update to 3.18.0

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
26 Apr 2017 18:45:55
Original commit files touched by this commit Revision:439476  3.17.0
sunpoet search for other commits by this committer
Take maintainership
14 Apr 2017 18:36:54
Original commit files touched by this commit Revision:438533  3.17.0
swills search for other commits by this committer
Allow overriding of USES
08 Apr 2017 10:33:39
Original commit files touched by this commit Revision:437999  3.17.0
sunpoet search for other commits by this committer
Update to 3.17.0

- Allow concurrent installation (USE_PYTHON=concurrent)
- Do not silence installation and test messages
- Cosmetic change
- Update pkg-descr

Changes:	https://github.com/rogerbinns/apsw/releases
		https://rogerbinns.github.io/apsw/changes.html
03 Oct 2016 23:31:46
Original commit files touched by this commit Revision:423230  3.14.1
amdmi3 search for other commits by this committer
- Update to 3.14.1
- Add tests support
19 Jun 2016 12:20:09
Original commit files touched by this commit Revision:417115  3.13.0
rm search for other commits by this committer
databases/py-apsw: update to 3.13.0-r1

* Update PORTVERSION, adjust distinfo
* Add LICENSE_FILE entry
* Fix WWW in pkg-descr
* Add UPDATING entry, per potential backwards incompatibility listed for
  3.12.2-r1 we're jumping over.

While I'm here, remove unneded PYDISTUTILS_EGGINFO knob.

PR:		210376
Submitted by:	 Vladimir Krstulja <vlad-fbsd@acheronmedia.com>
15 Mar 2016 02:28:50
Original commit files touched by this commit Revision:411131  3.11.1
vanilla search for other commits by this committer
Update to 3.11.1.
06 Jan 2016 06:16:23
Original commit files touched by this commit Revision:405332  3.9.2
miwi search for other commits by this committer
- Update to 3.9.2
- Update WWW

PR:		205892
Submitted by:	ports fury
25 Dec 2015 23:19:20
Original commit files touched by this commit Revision:404486  3.8.0.2_2
amdmi3 search for other commits by this committer
- Add LICENSE
- Switch to USES=localbase
25 Dec 2015 23:19:02
Original commit files touched by this commit Revision:404485  3.8.0.2_2
amdmi3 search for other commits by this committer
- Reset maintainer by his own request

PR:		205570
08 Sep 2015 15:07:31
Original commit files touched by this commit Revision:396388  3.8.0.2_2
amdmi3 search for other commits by this committer
- Fix PYDISTUTILS_EGGINFO

Approved by:	portmgr blanket
14 May 2015 10:15:09
Original commit files touched by this commit Revision:386312  3.8.0.2_1
mat search for other commits by this committer
MASTER_SITES cleanup.

- Replace ${MASTER_SITE_FOO} with FOO.
- Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9%
  of the time.)
- Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and
  no hint of what it should be was present.
- Fix some logic.
- And generally, make things more simple and easy to understand.

While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and
SAMBA macros.

Also, replace some EXTRACT_SUFX occurences with USES=tar:*.

Checked by:	make fetch-urlall-list
With hat:	portmgr
Sponsored by:	Absolight
19 Oct 2014 08:50:18
Original commit files touched by this commit Revision:371173  3.8.0.2_1
mva search for other commits by this committer
- Convert ports from databases/ and deskutils/ to new USES=python

Approved by:	portmgr (implicit)
27 Jun 2014 17:21:07
Original commit files touched by this commit Revision:359586  3.8.0.2_1
miwi search for other commits by this committer
- Chase database/sqlite3 slib bump

Approved by:	portmgr (myself)
15 Apr 2014 14:39:06
Original commit files touched by this commit Revision:351335  3.8.0.2
swills search for other commits by this committer
- Stage
- Pet portlint

PR:		ports/188602
Submitted by:	Bartek Rutkowski <ports@robakdesign.com>
Approved by:	Rusty Nejdl <rnejdl@ringofsaturn.com> (maintainer)
07 Mar 2014 16:49:10
Refresh Original commit files touched by this commit Revision:347405  Sanity Test Failure
bapt search for other commits by this committer
Convert d* to USES=zip
20 Sep 2013 16:13:49
Original commit files touched by this commit Revision:327717  3.8.0.2
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
12 Sep 2013 11:44:06
Original commit files touched by this commit Revision:327055  3.8.0.2
madpilot search for other commits by this committer
APSW is a Python wrapper for the SQLite embedded relational database
engine. In contrast to other wrappers such as pysqlite it focuses
on being a minimal layer over SQLite attempting just to translate
the complete SQLite API into Python. The documentation has a section
on the differences between APSW and pysqlite. APSW supports CPython
2.3 onwards and CPython 3.1 onwards.

PR:		ports/181938
Submitted by:	Rusty Nejdl <rnejdl@ringofsaturn.com>

Number of commits found: 43