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 photosAll times are UTC		 Ukraine
Port details on branch 2024Q1
py-sqlite3 Standard Python binding to the SQLite3 library (Python 3.9)
3.9.18_7 databases on this many watch lists=45 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.9.18_7Version 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: 2024-03-16 01:20:08
Commit Hash: 1328b38
People watching this port, also watch:: sqlite3, expat, libxml2, libiconv, glib
Also Listed In: python
License: PSFL
Description:
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.
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.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-sqlite3/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-sqlite3
  • pkg install py39-sqlite3
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 py39-sqlite3 listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py39-sqlite3
Package flavors (<flavor>: <package>)
  • py39: py39-sqlite3
  • py27: py27-sqlite3
  • py38: py38-sqlite3
  • py310: py310-sqlite3
  • py311: py311-sqlite3
distinfo:
TIMESTAMP = 1694092705 SHA256 (python/Python-3.9.18.tar.xz) = 01597db0132c1cf7b331eff68ae09b5a235a3c3caa9c944c29cac7d1c4c4c00a SIZE (python/Python-3.9.18.tar.xz) = 19673928
Packages (timestamps in pop-ups are UTC):
py27-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.7.18_72.7.18_72.7.18_72.7.18_72.7.18_7-2.7.18_7-
FreeBSD:13:quarterly2.7.18_72.7.18_72.7.18_72.7.18_72.7.18_72.7.18_72.7.18_72.7.18_7
FreeBSD:14:latest2.7.18_72.7.18_72.7.18_72.7.18_72.7.18_72.7.18_7-2.7.18_7
FreeBSD:14:quarterly2.7.18_72.7.18_7-2.7.18_72.7.18_72.7.18_72.7.18_72.7.18_7
FreeBSD:15:latest2.7.18_72.7.18_7n/a2.7.18_7n/a2.7.18_72.7.18_72.7.18_7
 
py36-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--3.6.12_7---3.6.12_7-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 
py37-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--3.7.9_7---3.7.9_7-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--3.7.16_7--3.7.17_7-3.7.17_7
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 
py38-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.8.20_73.8.20_73.8.7_73.8.20_73.8.20_7-3.8.7_7-
FreeBSD:13:quarterly3.8.20_73.8.20_73.8.17_73.8.20_73.8.20_73.8.18_73.8.18_73.8.18_7
FreeBSD:14:latest3.8.20_73.8.20_73.8.16_73.8.20_73.8.20_73.8.17_7-3.8.17_7
FreeBSD:14:quarterly3.8.20_73.8.20_7-3.8.20_73.8.20_73.8.18_73.8.18_73.8.18_7
FreeBSD:15:latest3.8.20_73.8.20_7n/a3.8.20_7n/a3.8.18_73.8.18_73.8.18_7
 
py39-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.9.21_73.9.21_73.9.1_73.9.20_73.9.21_7-3.9.1_7-
FreeBSD:13:quarterly3.9.20_73.9.20_73.9.17_73.9.20_73.9.20_73.9.18_73.9.18_73.9.18_7
FreeBSD:14:latest3.9.21_73.9.21_73.9.16_73.9.21_73.9.21_73.9.17_7-3.9.17_7
FreeBSD:14:quarterly3.9.20_73.9.20_7-3.9.20_73.9.20_73.9.18_73.9.18_73.9.18_7
FreeBSD:15:latest3.9.21_73.9.21_7n/a3.9.20_7n/a3.9.18_73.9.18_73.9.18_7
 
py310-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.10.16_73.10.16_7-3.10.15_73.10.16_7---
FreeBSD:13:quarterly3.10.15_73.10.15_73.10.12_73.10.15_73.10.15_73.10.13_73.10.13_73.10.13_7
FreeBSD:14:latest3.10.16_73.10.16_73.10.9_73.10.16_73.10.16_73.10.12_7-3.10.12_7
FreeBSD:14:quarterly3.10.15_73.10.15_7-3.10.15_73.10.15_73.10.13_73.10.13_73.10.13_7
FreeBSD:15:latest3.10.16_73.10.16_7n/a3.10.15_7n/a3.10.13_73.10.13_73.10.13_7
 
py311-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.11.11_73.11.11_7-3.11.10_73.11.11_7---
FreeBSD:13:quarterly3.11.10_73.11.10_73.11.4_73.11.10_73.11.10_73.11.7_73.11.7_73.11.8_7
FreeBSD:14:latest3.11.11_73.11.11_73.11.1_73.11.11_73.11.11_73.11.4_7-3.11.4_7
FreeBSD:14:quarterly3.11.10_73.11.10_7-3.11.10_73.11.10_73.11.7_73.11.7_73.11.8_7
FreeBSD:15:latest3.11.11_73.11.11_7n/a3.11.10_7n/a3.11.7_73.11.7_73.11.8_7
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py39-setuptools>=63.1.0 : devel/py-setuptools@py39
  2. python3.9 : lang/python39
Test dependencies:
  1. python3.9 : lang/python39
Runtime dependencies:
  1. py39-setuptools>=63.1.0 : devel/py-setuptools@py39
  2. python3.9 : lang/python39
Library dependencies:
  1. libsqlite3.so : databases/sqlite3
This port is required by:
for Build
  1. audio/lollypop
  2. databases/py-aiosqlite
  3. databases/py-peewee
  4. deskutils/py-paperless
  5. deskutils/py-paperless-ngx
  6. deskutils/zim
  7. finance/ktoblzcheck
Expand this list (48 items / 41 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. finance/py-finviz
  3. games/unknown-horizons
  4. games/wxlauncher
  5. graphics/qgis
  6. graphics/qgis-ltr
  7. mail/py-offlineimap3
  8. mail/thunderbird
  9. math/cado-nfs
  10. math/sage
  11. multimedia/photofilmstrip
  12. science/py-ruffus
  13. security/zeek
  14. sysutils/conan
  15. sysutils/py-bitrot
  16. textproc/ibus-table
  17. textproc/ibus-typing-booster
  18. textproc/translate-toolkit
  19. www/firefox
  20. www/firefox-esr
  21. www/gallery-dl
  22. www/librewolf
  23. www/tor-browser
  24. www/waterfox
  25. www/yt-dlp
  26. Collapse this list.

Deleted ports which required this port:

Expand this list of 17 deleted ports
  1. databases/py-sqlite3dbm*
  2. deskutils/conduit*
  3. deskutils/hamster-applet*
  4. dns/bind10*
  5. dns/bundy*
  6. games/gcompris*
  7. games/py-anki*
  8. mail/offlineimap*
  9. security/bro*
  10. security/hotssh*
  11. sysutils/uefi-edk2-bhyve-csm*
  12. sysutils/uefi-edk2-bhyve-devel*
  13. sysutils/uefi-edk2-qemu*
  14. www/cliqz*
  15. www/libxul*
  16. www/seamonkey*
  17. x11/hotwire-shell*
  18. Collapse this list of deleted ports.
for Run
  1. astro/py-indiweb
  2. audio/beets
  3. audio/lollypop
  4. audio/py-supysonic
  5. audio/solfege
  6. cad/fritzing
  7. databases/grass7
Expand this list (194 items / 187 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/grass8
  3. databases/py-aiosqlite
  4. databases/py-minidb
  5. databases/py-sqlalchemy10
  6. databases/py-sqlalchemy14
  7. databases/py-sqlalchemy20
  8. databases/py-sqlite-anyio
  9. databases/py-sqlite-fts4
  10. deskutils/py-khal
  11. deskutils/py-paperless
  12. deskutils/py-paperless-ngx
  13. deskutils/py-vdirsyncer
  14. deskutils/py-vorta
  15. deskutils/zim
  16. devel/eric6
  17. devel/ipython
  18. devel/py-acstore
  19. devel/py-b2sdk
  20. devel/py-boltons
  21. devel/py-buildbot
  22. devel/py-coverage
  23. devel/py-hg-evolve
  24. devel/py-nbformat
  25. devel/py-pre-commit
  26. devel/rbtools
  27. dns/dnsrecon
  28. emulators/fs-uae-launcher
  29. filesystems/py-dfvfs
  30. finance/electrum
  31. finance/py-finviz
  32. games/anki
  33. games/py-mnemosyne-proj
  34. games/unknown-horizons
  35. graphics/py-projpicker
  36. graphics/qgis
  37. graphics/qgis-ltr
  38. graphics/rapid-photo-downloader
  39. irc/py-sopel
  40. mail/py-offlineimap3
  41. math/cado-nfs
  42. math/py-pandas
  43. math/sage
  44. multimedia/gpodder
  45. multimedia/kodi
  46. multimedia/mythtv
  47. multimedia/pitivi
  48. multimedia/tautulli
  49. net/google-cloud-sdk
  50. net-im/gajim
  51. net-im/py-matrix-synapse
  52. net-mgmt/seafile-client
  53. net-mgmt/seafile-server
  54. net-p2p/bazarr
  55. news/sabnzbd
  56. science/gramps
  57. science/py-ruffus
  58. security/maltrail
  59. security/nyx
  60. security/py-fail2ban
  61. security/py-plaso
  62. security/py-pyaxo
  63. security/py-volatility3
  64. security/sqlmap
  65. security/theonionbox
  66. security/wapiti
  67. security/zeek
  68. security/zeronet
  69. sysutils/angrysearch
  70. sysutils/conan
  71. sysutils/py-bitrot
  72. sysutils/py-queuelib
  73. sysutils/tuptime
  74. textproc/ibus-table
  75. textproc/ibus-typing-booster
  76. textproc/py-nltk
  77. textproc/translate-toolkit
  78. www/buku
  79. www/eolie
  80. www/gallery-dl
  81. www/mitmproxy
  82. www/offpunk
  83. www/persepolis
  84. www/py-calibreweb
  85. www/py-django-cms
  86. www/py-django42
  87. www/py-django50
  88. www/py-django51
  89. www/py-lektor
  90. www/py-searxng-devel
  91. www/py-yt-dlp
  92. www/trac
  93. www/yt-dlp
  94. x11/ulauncher
  95. Collapse this list.

Deleted ports which required this port:

Expand this list of 94 deleted ports
  1. astro/gmapcatcher*
  2. audio/pytone*
  3. cad/brickutils*
  4. databases/mysql-workbench52*
  5. databases/py-htsql*
  6. databases/py-sqlalchemy*
  7. databases/py-sqlalchemy-devel*
  8. databases/py-sqlalchemy06*
  9. databases/py-sqlalchemy07*
  10. databases/py-sqlalchemy08*
  11. databases/py-sqlalchemy09*
  12. databases/py-sqlalchemy11*
  13. databases/py-sqlalchemy12*
  14. databases/py-sqlalchemy13*
  15. databases/py-sqlite3dbm*
  16. databases/py-sqlkit*
  17. databases/py-swift*
  18. deskutils/anamnesis*
  19. deskutils/conduit*
  20. deskutils/gourmet*
  21. deskutils/griffith*
  22. deskutils/hamster-applet*
  23. devel/buildbot*
  24. devel/bzr-git*
  25. devel/eric4*
  26. devel/ipython5*
  27. dns/bind10*
  28. dns/bundy*
  29. editors/leo*
  30. editors/zim*
  31. games/gcompris*
  32. games/py-anki*
  33. games/py-mnemosyne*
  34. graphics/comix*
  35. japanese/trac*
  36. mail/offlineimap*
  37. misc/diary-hercules*
  38. multimedia/kodi-devel*
  39. multimedia/miro*
  40. multimedia/plexhometheater*
  41. multimedia/plexpy*
  42. multimedia/pyjama*
  43. multimedia/xbmc*
  44. multimedia/xbmc-pvr*
  45. net/neubot*
  46. net/py-matrix-synapse*
  47. net-im/gajim-devel*
  48. net-mgmt/seafile*
  49. net-p2p/bazarr-devel*
  50. net-p2p/bitmessage*
  51. net-p2p/couchpotato*
  52. net-p2p/tribler*
  53. news/sabnzbdplus*
  54. news/xpn*
  55. security/bro*
  56. security/hotssh*
  57. security/pwman3*
  58. security/py-dfvfs*
  59. security/py-volatility*
  60. security/umit*
  61. security/w3af*
  62. security/zenmap*
  63. sysutils/yum*
  64. textproc/pootle*
  65. www/calendarserver*
  66. www/go-appengine-sdk*
  67. www/google-appengine*
  68. www/linkchecker*
  69. www/py-GinGin*
  70. www/py-buku*
  71. www/py-django-devel*
  72. www/py-django110*
  73. www/py-django111*
  74. www/py-django13*
  75. www/py-django14*
  76. www/py-django15*
  77. www/py-django16*
  78. www/py-django17*
  79. www/py-django18*
  80. www/py-django19*
  81. www/py-django20*
  82. www/py-django21*
  83. www/py-django22*
  84. www/py-django30*
  85. www/py-django31*
  86. www/py-django32*
  87. www/py-django40*
  88. www/py-django41*
  89. www/py-yt-dlp-devel*
  90. www/pycarddav*
  91. www/roundup*
  92. www/trac-devel*
  93. x11/hotwire-shell*
  94. x11-fm/sunflower*
  95. 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-sqlite3
USES:
compiler:c11 python:2.7+ tar:xz
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://www.python.org/ftp/python/3.9.18/
Collapse this list.

There are no commits on branch 2024Q1 for this port
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?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
vaultwardenDec 20
chromiumDec 19
ungoogled-chromiumDec 19
forgejo*Dec 18
forgejo7*Dec 18
liboqsDec 18
forgejoDec 17
forgejoDec 17
giteaDec 17
giteaDec 17
giteaDec 17
zeekDec 16
py-matrix-synapseDec 15
gitlabDec 12
chromiumDec 11

16 vulnerabilities affecting 274 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2024-12-24 11:27:39 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33210
Broken 115
Deprecated 200
Ignore 239
Forbidden 1
Restricted 1
No CDROM 1
Vulnerable 32
Expired 12
Set to expire 166
Interactive 0
new 24 hours 22
new 48 hours22
new 7 days59
new fortnight89
new month137
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2024 Dan Langille. All rights reserved.