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-sqlite3 Standard Python binding to the SQLite3 library (Python 2.7)
2.7.14_7 databases on this many watch lists=31 search for ports that depend on this port Find issues related to this port Report an issue related to this port 2.7.14Version of this port present on the latest quarterly branch.
Maintainer: python@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2006-06-23 03:54:22
Last Update: 2017-11-30 15:50:34
SVN Revision: 455210

People watching this port, also watch: freetype2, sqlite3, expat, pcre, libxml2

Also Listed In: python
License: PSFL
Description:
SVNWeb

There is no configure plist information for this port.

Dependency lines:
  • py27-sqlite3>0:databases/py-sqlite3
To install the port: cd /usr/ports/databases/py-sqlite3/ && make install clean
To add the package: pkg install py27-sqlite3
PKGNAME: py27-sqlite3
Flavors: there is no flavor information for this port.
distinfo:
Packages:
py27-sqlite3
ABIlatestquarterly
FreeBSD:11:aarch642.7.15_72.7.18_7
FreeBSD:11:amd642.7.18_72.7.18_7
FreeBSD:11:i3862.7.18_72.7.18_7
FreeBSD:12:aarch642.7.15_72.7.18_7
FreeBSD:12:amd642.7.18_72.7.18_7
FreeBSD:12:i3862.7.18_72.7.18_7
FreeBSD:13:aarch642.7.17_7-
FreeBSD:13:amd642.7.18_7-
FreeBSD:13:i3862.7.18_7-
 
py34-sqlite3
ABIlatestquarterly
FreeBSD:11:aarch643.4.9_7-
FreeBSD:11:amd64--
FreeBSD:11:i386--
FreeBSD:12:aarch643.4.9_7-
FreeBSD:12:amd64--
FreeBSD:12:i386--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:i386--
 
py35-sqlite3
ABIlatestquarterly
FreeBSD:11:aarch643.5.6_73.5.9_7
FreeBSD:11:amd643.5.9_73.5.9_7
FreeBSD:11:i3863.5.9_73.5.9_7
FreeBSD:12:aarch643.5.6_73.5.9_7
FreeBSD:12:amd643.5.9_73.5.9_7
FreeBSD:12:i3863.5.9_73.5.9_7
FreeBSD:13:aarch643.5.9_7-
FreeBSD:13:amd643.5.9_7-
FreeBSD:13:i3863.5.9_7-
 
py36-sqlite3
ABIlatestquarterly
FreeBSD:11:aarch643.6.6_73.6.9_7
FreeBSD:11:amd643.6.9_73.6.9_7
FreeBSD:11:i3863.6.9_73.6.9_7
FreeBSD:12:aarch643.6.6_73.6.9_7
FreeBSD:12:amd643.6.9_73.6.9_7
FreeBSD:12:i3863.6.9_73.6.9_7
FreeBSD:13:aarch643.6.9_7-
FreeBSD:13:amd643.6.9_7-
FreeBSD:13:i3863.6.9_7-
 
py37-sqlite3
ABIlatestquarterly
FreeBSD:11:aarch643.7.0_73.7.7_7
FreeBSD:11:amd643.7.7_73.7.7_7
FreeBSD:11:i3863.7.7_73.7.7_7
FreeBSD:12:aarch643.7.0_73.7.7_7
FreeBSD:12:amd643.7.7_73.7.7_7
FreeBSD:12:i3863.7.7_73.7.7_7
FreeBSD:13:aarch643.7.7_7-
FreeBSD:13:amd643.7.7_7-
FreeBSD:13:i3863.7.7_7-
 
py38-sqlite3
ABIlatestquarterly
FreeBSD:11:aarch64-3.8.2_7
FreeBSD:11:amd643.8.3_73.8.3_7
FreeBSD:11:i3863.8.3_73.8.3_7
FreeBSD:12:aarch64-3.8.2_7
FreeBSD:12:amd643.8.3_73.8.3_7
FreeBSD:12:i3863.8.3_73.8.3_7
FreeBSD:13:aarch643.8.2_7-
FreeBSD:13:amd643.8.3_7-
FreeBSD:13:i3863.8.3_7-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py27-setuptools>0 : devel/py-setuptools@py27
  2. python2.7 : lang/python27
Runtime dependencies:
  1. py27-setuptools>0 : devel/py-setuptools@py27
  2. python2.7 : lang/python27
Library dependencies:
  1. libsqlite3.so : databases/sqlite3
This port is required by:
for Build
  1. audio/lollypop
  2. databases/py-peewee
  3. databases/py-sqlite3dbm
  4. deskutils/calibre
  5. deskutils/py-paperless
  6. deskutils/zim
  7. dns/bundy
Expand this list (37 items / 30 hidden)
  1. games/unknown-horizons
  2. games/wxlauncher
  3. graphics/qgis
  4. graphics/qgis-ltr
  5. mail/offlineimap
  6. multimedia/photofilmstrip
  7. science/py-ruffus
  8. security/bro
  9. security/zeek
  10. sysutils/py-bitrot
  11. sysutils/uefi-edk2-bhyve
  12. sysutils/uefi-edk2-bhyve-csm
  13. sysutils/uefi-edk2-bhyve-devel
  14. sysutils/uefi-edk2-qemu
  15. textproc/ibus-table
  16. textproc/ibus-typing-booster
  17. textproc/translate-toolkit
  18. www/cliqz
  19. www/firefox
  20. Collapse this list.

Deleted ports which required this port:

Expand this list of 11 deleted ports
  1. deskutils/conduit*
  2. deskutils/hamster-applet*
  3. dns/bind10*
  4. games/gcompris*
  5. games/py-anki*
  6. security/hotssh*
  7. www/libxul*
  8. www/palemoon*
  9. www/seamonkey*
  10. www/waterfox*
  11. x11/hotwire-shell*
  12. Collapse this list of deleted ports.
for Run
  1. audio/beets
  2. audio/lollypop
  3. cad/fritzing
  4. databases/grass7
  5. databases/py-aiosqlite
  6. databases/py-htsql
  7. databases/py-minidb
Expand this list (152 items / 145 hidden)
  1. databases/py-sqlalchemy10
  2. databases/py-sqlalchemy11
  3. databases/py-sqlalchemy12
  4. databases/py-sqlalchemy13
  5. databases/py-sqlite3dbm
  6. databases/py-swift
  7. deskutils/calibre
  8. deskutils/griffith
  9. deskutils/py-khal
  10. deskutils/py-paperless
  11. deskutils/py-vdirsyncer
  12. deskutils/zim
  13. devel/b2
  14. devel/eric6
  15. devel/git-cvs
  16. devel/ikos
  17. devel/ipython
  18. devel/ipython5
  19. devel/py-b2sdk
  20. devel/py-buildbot
  21. devel/py-nbformat
  22. devel/py-pre-commit
  23. devel/rbtools
  24. dns/bundy
  25. dns/dnsrecon
  26. emulators/fs-uae-launcher
  27. games/anki
  28. games/py-mnemosyne
  29. games/unknown-horizons
  30. graphics/qgis
  31. graphics/qgis-ltr
  32. graphics/rapid-photo-downloader
  33. mail/offlineimap
  34. math/py-pandas
  35. multimedia/gpodder
  36. multimedia/kodi
  37. multimedia/kodi-devel
  38. multimedia/mythtv
  39. multimedia/pitivi
  40. multimedia/tautulli
  41. net/google-cloud-sdk
  42. net-im/gajim
  43. net-im/py-matrix-synapse
  44. net-mgmt/seafile-client
  45. net-mgmt/seafile-server
  46. net-p2p/couchpotato
  47. news/sabnzbdplus
  48. science/gramps
  49. science/py-ruffus
  50. security/bro
  51. security/maltrail
  52. security/nyx
  53. security/pwman3
  54. security/py-dfvfs
  55. security/py-fail2ban
  56. security/py-plaso
  57. security/py-pyaxo
  58. security/py-volatility
  59. security/sqlmap
  60. security/theonionbox
  61. security/wapiti
  62. security/zeek
  63. security/zeronet
  64. sysutils/py-bitrot
  65. sysutils/py-queuelib
  66. sysutils/tuptime
  67. textproc/ibus-table
  68. textproc/ibus-typing-booster
  69. textproc/py-nltk
  70. textproc/translate-toolkit
  71. www/buku
  72. www/calendarserver
  73. www/go-appengine-sdk
  74. www/google-appengine
  75. www/py-django-cms
  76. www/py-django111
  77. www/py-django22
  78. www/py-django30
  79. www/py-scrapy
  80. www/roundup
  81. www/trac
  82. www/trac-devel
  83. Collapse this list.

Deleted ports which required this port:

Expand this list of 63 deleted ports
  1. astro/gmapcatcher*
  2. audio/pytone*
  3. cad/brickutils*
  4. databases/mysql-workbench52*
  5. databases/py-sqlalchemy*
  6. databases/py-sqlalchemy-devel*
  7. databases/py-sqlalchemy06*
  8. databases/py-sqlalchemy07*
  9. databases/py-sqlalchemy08*
  10. databases/py-sqlalchemy09*
  11. databases/py-sqlkit*
  12. deskutils/anamnesis*
  13. deskutils/conduit*
  14. deskutils/gourmet*
  15. deskutils/hamster-applet*
  16. devel/buildbot*
  17. devel/bzr-git*
  18. devel/eric4*
  19. dns/bind10*
  20. editors/leo*
  21. editors/zim*
  22. games/gcompris*
  23. games/py-anki*
  24. graphics/comix*
  25. japanese/trac*
  26. misc/diary-hercules*
  27. multimedia/miro*
  28. multimedia/plexhometheater*
  29. multimedia/plexpy*
  30. multimedia/pyjama*
  31. multimedia/xbmc*
  32. multimedia/xbmc-pvr*
  33. net/neubot*
  34. net/py-matrix-synapse*
  35. net-im/gajim-devel*
  36. net-mgmt/seafile*
  37. net-p2p/bitmessage*
  38. net-p2p/tribler*
  39. news/xpn*
  40. security/hotssh*
  41. security/umit*
  42. security/w3af*
  43. security/zenmap*
  44. sysutils/yum*
  45. textproc/pootle*
  46. www/linkchecker*
  47. www/py-GinGin*
  48. www/py-buku*
  49. www/py-django-devel*
  50. www/py-django110*
  51. www/py-django13*
  52. www/py-django14*
  53. www/py-django15*
  54. www/py-django16*
  55. www/py-django17*
  56. www/py-django18*
  57. www/py-django19*
  58. www/py-django20*
  59. www/py-django21*
  60. www/pycarddav*
  61. x11/hotwire-shell*
  62. x11-fm/sunflower*
  63. x11-fonts/font-manager*
  64. 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

USES:

Master Sites:
  1. http://www.python.org/ftp/python/2.7.14/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2017-11-30
    Affects: */py*
    Author: mat@FreeBSD.org
    Reason: 
      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
    
    

Number of commits found: 31

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
30 Nov 2017 15:50:34
Original commit files touched by this commit  2.7.14_7
Revision:455210  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)
03 Jul 2016 00:17:30
Original commit files touched by this commit  2.7.12_7
Revision:417946
wen search for other commits by this committer
- Update to devel/py-setuptools to 23.1.0 [1][2]

PR:		210636 [1]
		210685 [2]
Submitted by:	vlad-fbsd@acheronmedia.com [1]
		wen@ [2]
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D6994
19 May 2016 10:57:35
Original commit files touched by this commit  2.7.11_7
Revision:415501
amdmi3 search for other commits by this committer
- Fix trailing whitespace in Makefiles

Approved by:	portmgr blanket
01 Apr 2016 14:00:57
Original commit files touched by this commit  2.7.11_7
Revision:412346
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
19 Nov 2015 01:28:38
Original commit files touched by this commit  2.7.10_7
Revision:401909
lwhsu search for other commits by this committer
Add version specified ports of separated standard Python modules for
non-default Python versions:

- Add pyXY-{sqlite3,gdbm,tkinter} ports for generating binary packages
- Improve/add pkg-message to point users to install respective packages of
  separated Python standard modules
- Add COMMENT to explicitly show the Python version that package should be
  used with
- Simplify version-related PYTHON_* for lang/python35

Reviewed by:	koobs
Differential Revision:	https://reviews.freebsd.org/D4170
26 May 2015 16:47:03
Original commit files touched by this commit  2.7.9_6
Revision:387491
antoine search for other commits by this committer
Switch PYTHON_REL from a 3 digits number to a 4 digits number to handle
python 2.7.10

Differential Revision:	https://reviews.freebsd.org/D2639
Reviewed by:	sunpoet, mva
14 May 2015 10:15:09
Original commit files touched by this commit  2.7.9_6
Revision:386312
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
11 Feb 2015 13:18:23
Original commit files touched by this commit  2.7.9_6
Revision:378837
koobs search for other commits by this committer
databases/py-sqlite3: Strip shared library

- Strip shared extension
- Sort DIST* entries
- Sort USE_PYTHON values
- Add LICENSE_FILE

Approved by: python (with hat)
28 Sep 2014 16:37:34
Original commit files touched by this commit  2.7.8_5
Revision:369466
mva search for other commits by this committer
- Convert to USES=python

With hat:	python@
09 Aug 2014 15:44:28
Original commit files touched by this commit  2.7.8_5
Revision:364450
mva search for other commits by this committer
Convert the Python framework bits to USES=python.

Please use USES=python instead of USE_PYTHON.

  USE_PYTHON=yes becomes USES=python
  USE_PYTHON=2.7+ becomes USES=python:2.7+
  USE_PYTHON_BUILD=3.3 becomes USES=python:3.3,build
  ...

A new PYTHON_FEATURES variable was added, which enables certain features for a
port and replaces some knobs at the same time;

  PYTHON_FEATURES=distutils replaces USE_PYDISTUTILS
  PYTHON_FEATURES=autoplist replaces PYDISTUTILS_AUTOPLIST
  PYTHON_FEATURES=py3kplist replaces PYTHON_PY3K_PLIST_HACK
(Only the first 15 lines of the commit message are shown above View all of this commit message)
02 Aug 2014 06:57:41
Original commit files touched by this commit  2.7.8_5
Revision:363791
mva search for other commits by this committer
- Catch up with the recent lang/pythonXX changes

With hat:	python@
27 Jun 2014 17:21:07
Original commit files touched by this commit  2.7.6_4
Revision:359586
miwi search for other commits by this committer
- Chase database/sqlite3 slib bump

Approved by:	portmgr (myself)
11 Apr 2014 08:25:12
Original commit files touched by this commit  2.7.6_3
Revision:350902
sunpoet search for other commits by this committer
- Add LICENSE
- Pet portlint: use PYTHON_DISTNAME instead of PYTHON_DISTFILE
- Use USES=tar:xz
15 Dec 2013 16:22:17
Original commit files touched by this commit  2.7.6_3
Revision:336553
wg search for other commits by this committer
Use setuptools for all Python ports.

Setuptools is the preferred method to manage Python distributions after
many changes to the packaging ecosystem over the past couple of years.

Only ports using USE_PYDISTUTILS= yes are affected by this commit, ports using
USE_PYDISTUTILS= easy_install remains the same however this usage is now
deprecated and should be converted to USE_PYDISTUTILS= yes.

Some Python distributions do not work with setuptools out of the box because
they extend the install command from distutils and not setuptools, and
so they need to be patched accordingly.

pip (which leverages setuptools) works around the issue by using eggs, however
we want to get rid of those as well, as support for "flat" installation is
(Only the first 15 lines of the commit message are shown above View all of this commit message)
11 Dec 2013 18:08:53
Original commit files touched by this commit  2.7.6_3
Revision:336187
bapt search for other commits by this committer
In preparation for making libtool generate libraries with a sane name, fix all
LIB_DEPENDS in databases
01 Nov 2013 11:24:14
Original commit files touched by this commit  2.7.5_3
Revision:332358
koobs search for other commits by this committer
databases/py-sqlite3: Remove BROKEN on ARM

- Remove BROKEN for ARM architecture [1]

[1] http://lists.freebsd.org/pipermail/freebsd-python/2013-October/005960.html

PR:		ports/183549
Reported by:	Xu Waycell <xw901103@gmail.com>
20 Sep 2013 16:13:49
Original commit files touched by this commit  2.7.5_3
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
07 Sep 2013 17:21:52
Original commit files touched by this commit  2.7.5_3
Revision:326661
sunpoet search for other commits by this committer
- Add PORTSCOUT=ignore:1 to avoid false alarm
01 Mar 2013 20:12:02
Original commit files touched by this commit  2.7.3_3
Revision:313167
lwhsu search for other commits by this committer
- Install standard libraries separated as other ports to the same place
  with other standard libraries (${PYTHON_LIBDIR}/lib-dynload)
- Improve consistency of the Makefile(s)
- Whitespace cleanup for the patches
03 Oct 2012 04:06:38
Original commit files touched by this commit  2.7.3_2
Revision:305181
rm search for other commits by this committer
- do not hardcode distfile extension for lang/python ports in bsd.python.mk
  (PYTHON_DISTFILE variable)
- switch lang/python ports (and it's slaves) to tar.xz

I compared all the four pairs .tgz/.tar.xz and they have no content differences.

Discussed on:	python@
04 Sep 2012 03:05:24
Original commit files touched by this commit  2.7.3_2
Revision:303634
linimon search for other commits by this committer
Mark as broken on ARM.

PR:		ports/170946
Submitted by:	linimon
Hat:		portmgr
26 Jul 2012 05:44:07
Original commit files touched by this commit  2.7.3_2

mva search for other commits by this committer
- Don't define HAVE_LOAD_EXTENSION when sqlite3 is compiled with EXTENSION
  option turned off

PR:		ports/156076
Submitted by:	Pan Tsu <inyaoo@gmail.com>
13 Oct 2011 13:06:11
Original commit files touched by this commit  2.7.2_1

wen search for other commits by this committer
- Remove stale pkg_message

PR:             ports/161535
Submitted by:   Ruslan Mahmatkhanov <cvs-src@yandex.ru>
28 Oct 2010 21:00:21
Original commit files touched by this commit  2.6.6_1

erwin search for other commits by this committer
Deprecate md5 in favour of sha256 checksums.  md5 checksums will no longer
be generated or checked, and will be silently ignored for now.  Also,
generalize the MD5_FILE macro to DISTINFO_FILO.

PR:             149657
Submitted by:   rene
Approved by:    portmgr
Tested on:      pointyhat i386 7-exp
30 Jun 2009 21:51:53
Original commit files touched by this commit  2.6.2_1

lwhsu search for other commits by this committer
- Fix building with python3*
- Use checksum file under lang/python${PYTHON_SUFFIX}/,
  for removal lang/python/distinfo
30 Jul 2007 09:42:28
Original commit files touched by this commit  2.5.1_1

alexbl search for other commits by this committer
 - Make Python 2.5.1 the default Python version
 - Add significantly better support in bsd.python.mk for working with
   Python Eggs and the easy_install system

Tested by:      pointyhat runs
Approved by:    pav (portmgr)
Most work by:   perky
Thanks to:      pav
30 Mar 2007 04:18:18
Original commit files touched by this commit  2.5_1

kris search for other commits by this committer
Now appears to build
11 Feb 2007 01:23:35
Original commit files touched by this commit  2.5_1

kris search for other commits by this committer
Schedule these broken ports for removal on 2007-04-10 if they are still
broken at that time and no fix has been submitted.
12 Oct 2006 03:35:00
Original commit files touched by this commit  2.5_1

kris search for other commits by this committer
BROKEN: Incomplete pkg-plist

Approved by:    portmgr (self)
07 Aug 2006 02:23:05
Original commit files touched by this commit  2.5.b3_1

perky search for other commits by this committer
Make setup not to install an egg info file which isn't needed for
standard modules.
23 Jun 2006 03:54:01
Original commit files touched by this commit  2.5.b1

perky search for other commits by this committer
Add new port for python sqlite3 module.
This port installs a Python "standard" library version of pysqlite
which is provided by databases/py-pysqlite22 already.  Because
sqlite3 module was introduced in Python 2.5, this port plays only
for 2.5 or laters.

See Also:       http://docs.python.org/dev/lib/module-sqlite3.html

Number of commits found: 31

Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
powerdns-recursorMay 26
sympaMay 26
chromiumMay 24
piwigoMay 23
drupal7May 22
sympaMay 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19

17 vulnerabilities affecting 180 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-27 17:20:39


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39438
Broken 79
Deprecated 627
Ignore 347
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 23
Expired 15
Set to expire 581
Interactive 0
new 24 hours 3
new 48 hours10
new 7 days35
new fortnight86
new month244

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