FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

Port details
py-sqlite3 Standard Python binding to the SQLite3 library (Python 2.7)
2.7.12_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
Maintainer: python@FreeBSD.org search for ports maintained by this maintainer
Port Added: 23 Jun 2006 03:54:22
Also Listed In: python
License: PSFL
SQLite is a library that provides a SQL-language database that
stores data in disk files without requiring a separate server
process. pysqlite provides a SQL interface compliant with the DB-API
2.0 specification described by PEP 249. This means that it should
be possible to write the first version of your applications using
SQLite for data storage. If switching to a larger database such as
PostgreSQL or Oracle is later necessary, the switch should be
relatively easy.
SVNWeb : PortsMon

To install the port: cd /usr/ports/databases/py-sqlite3/ && make install clean
To add the package: pkg install py27-sqlite3

PKGNAME: py27-sqlite3

distinfo:

TIMESTAMP = 1467158541
SHA256 (python/Python-2.7.12.tar.xz) = d7837121dd5652a05fef807c361909d255d173280c4e1a4ded94d73d80a1f978
SIZE (python/Python-2.7.12.tar.xz) = 12390820


Slave ports
  1. databases/py33-sqlite3
  2. databases/py34-sqlite3
  3. databases/py35-sqlite3

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. py27-setuptools27>0 : devel/py-setuptools27
  2. python2.7 : lang/python27
Runtime dependencies:
  1. py27-setuptools27>0 : devel/py-setuptools27
  2. python2.7 : lang/python27
Library dependencies:
  1. libsqlite3.so : databases/sqlite3

This port is required by:

for Build for Run
  1. astro/gmapcatcher
  2. audio/beets
  3. audio/pytone
  4. cad/brickutils
  5. cad/fritzing
  6. databases/mysql-workbench52*
  7. databases/py-htsql
  8. Expand this list (102 items)
  9. databases/py-sqlalchemy*
  10. databases/py-sqlalchemy-devel*
  11. databases/py-sqlalchemy06
  12. databases/py-sqlalchemy07
  13. databases/py-sqlalchemy08
  14. databases/py-sqlalchemy09
  15. databases/py-sqlalchemy10
  16. databases/py-sqlite3dbm
  17. databases/py-sqlkit*
  18. databases/py-swift
  19. deskutils/anamnesis
  20. deskutils/calibre
  21. deskutils/conduit
  22. deskutils/gourmet
  23. deskutils/griffith
  24. deskutils/hamster-applet*
  25. deskutils/py-khal
  26. deskutils/zim
  27. devel/buildbot
  28. devel/bzr-git
  29. devel/eric4*
  30. devel/eric6
  31. devel/git-cvs
  32. devel/ipython
  33. devel/py-hypothesis
  34. devel/rbtools
  35. dns/bind10*
  36. editors/leo
  37. editors/zim*
  38. games/anki
  39. games/craft
  40. games/gcompris
  41. games/py-anki*
  42. games/py-mnemosyne
  43. games/py-pychess*
  44. games/unknown-horizons
  45. graphics/comix*
  46. graphics/qgis
  47. japanese/trac*
  48. mail/offlineimap
  49. math/py-pandas
  50. misc/diary-hercules*
  51. multimedia/gpodder
  52. multimedia/kodi
  53. multimedia/miro
  54. multimedia/plexhometheater
  55. multimedia/plexpy
  56. multimedia/py-openlp
  57. multimedia/pyjama
  58. multimedia/xbmc*
  59. multimedia/xbmc-pvr*
  60. net/neubot
  61. net/py-matrix-synapse
  62. net-im/emesene
  63. net-im/gajim
  64. net-im/gajim-devel*
  65. net-mgmt/seafile
  66. net-p2p/bitmessage
  67. net-p2p/tribler
  68. news/sabnzbdplus
  69. news/xpn
  70. security/bro
  71. security/hotssh
  72. security/pwman3
  73. security/py-dfvfs
  74. security/py-fail2ban
  75. security/py-plaso
  76. security/py-volatility
  77. security/umit
  78. security/w3af
  79. security/zenmap
  80. security/zeronet
  81. sysutils/tuptime
  82. sysutils/yum
  83. textproc/ibus-table
  84. textproc/translate-toolkit
  85. www/calendarserver
  86. www/google-appengine
  87. www/linkchecker
  88. www/py-GinGin
  89. www/py-django
  90. www/py-django-devel
  91. www/py-django13*
  92. www/py-django14*
  93. www/py-django15*
  94. www/py-django16
  95. www/py-django17*
  96. www/py-django18
  97. www/py-django19
  98. www/py-scrapy
  99. www/pycarddav
  100. www/roundup
  101. www/trac
  102. x11/hotwire-shell
  103. x11-fonts/font-manager
  104. Collapse this list.
* - 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

USES:
python tar:xz

Master Sites:
  1. http://www.python.org/ftp/python/2.7.12/

Number of commits found: 30

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
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: 30

Login
User Login
Create account

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

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

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
krb5-113*Jul 26
krb5-114*Jul 26
php55Jul 26
php55-bz2Jul 26
php55-exifJul 26
php55-gdJul 26
php55-odbcJul 26
php55-snmpJul 26
php55-xmlrpcJul 26
php55-zipJul 26
php56Jul 26
php56-bz2Jul 26
php56-exifJul 26
php56-gdJul 26
php56-odbcJul 26

19 vulnerabilities affecting 59 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 26086
Broken 83
Deprecated 123
Ignore 354
Forbidden 0
Restricted 201
No CDROM 83
Vulnerable 69
Expired 11
Set to expire 110
Interactive 0
new 24 hours 2
new 48 hours9
new 7 days28
new fortnight52
new month171

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