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
I started running short on disk space for the non-production FreshPorts hosts. This time, I have decided to ask for donations. See my recent blog post which points to my Patreon account.
Server is being updated to FreeBSD 14.3 as you read this... and it is done.
Commit processing is stalled - it is a jail issue. I will work on it later today. 2025-09-17 12:17 UTC - It has been fixed. Sometime before 17:27 UTC.
Port details on branch 2023Q4
py-sqlite3 Standard Python binding to the SQLite3 library (Python 3.11)
3.11.13_10 databases on this many watch lists=40 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.11.13_10Version 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: 2025-06-19 20:28:47
Commit Hash: 4f0eba1
People watching this port, also watch:: sqlite3, libxml2, expat, 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.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found 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 py311-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 py311-sqlite3 listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-sqlite3
Package flavors (<flavor>: <package>)
  • py311: py311-sqlite3
  • py312: py312-sqlite3
  • py310: py310-sqlite3
  • py39: py39-sqlite3
distinfo:
TIMESTAMP = 1749685283 SHA256 (python/Python-3.11.13.tar.xz) = 8fb5f9fbc7609fa822cb31549884575db7fd9657cbffb89510b5d7975963a83a SIZE (python/Python-3.11.13.tar.xz) = 20117496

Expand this list (2 items)

Collapse this list.

SHA256 (python/0c33e5baedf18ebcb04bc41dff7cfc614d5ea5fe.patch) = 2b9857d46cb45cbf0db322a7149f940f8aae8265f66f8ff8f5cd88d2af4015c5 SIZE (python/0c33e5baedf18ebcb04bc41dff7cfc614d5ea5fe.patch) = 23930

Collapse this list.

Packages (timestamps in pop-ups are UTC):
py27-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--2.7.18_7---2.7.18_7-
FreeBSD:13:quarterly--2.7.18_7--2.7.18_72.7.18_72.7.18_7
FreeBSD:14:latest--2.7.18_7--2.7.18_7-2.7.18_7
FreeBSD:14:quarterly-----2.7.18_72.7.18_72.7.18_7
FreeBSD:15:latest--n/a-n/a2.7.18_72.7.18_72.7.18_7
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/a---
 

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---
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16: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---
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/a---
 

py38-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--3.8.7_7---3.8.7_7-
FreeBSD:13:quarterly--3.8.17_7--3.8.18_73.8.18_73.8.18_7
FreeBSD:14:latest--3.8.16_7--3.8.17_7-3.8.17_7
FreeBSD:14:quarterly-----3.8.18_73.8.18_73.8.18_7
FreeBSD:15:latest--n/a-n/a3.8.18_73.8.18_73.8.18_7
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/a---
 

py39-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.9.23_103.9.23_103.9.1_73.9.23_103.9.23_10-3.9.1_7-
FreeBSD:13:quarterly3.9.23_103.9.23_103.9.17_73.9.23_103.9.23_103.9.18_73.9.18_73.9.18_7
FreeBSD:14:latest3.9.23_103.9.23_103.9.16_73.9.23_103.9.23_103.9.17_7-3.9.17_7
FreeBSD:14:quarterly3.9.23_103.9.23_10-3.9.23_103.9.23_103.9.18_73.9.18_73.9.18_7
FreeBSD:15:latest3.9.23_103.9.23_10n/a3.9.23_10n/a3.9.18_73.9.18_73.9.18_7
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/a---
 

py310-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.10.18_103.10.18_10-3.10.18_103.10.18_10---
FreeBSD:13:quarterly3.10.18_103.10.18_103.10.12_73.10.18_103.10.18_103.10.13_73.10.13_73.10.13_7
FreeBSD:14:latest3.10.18_103.10.18_103.10.9_73.10.18_103.10.18_103.10.12_7-3.10.12_7
FreeBSD:14:quarterly3.10.18_103.10.18_10-3.10.18_103.10.18_103.10.13_73.10.13_73.10.13_7
FreeBSD:15:latest3.10.18_103.10.18_10n/a3.10.18_10n/a3.10.13_73.10.13_73.10.13_7
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/a---
 

py311-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.11.13_103.11.13_10-3.11.13_103.11.13_10---
FreeBSD:13:quarterly3.11.13_103.11.13_103.11.4_73.11.13_103.11.13_103.11.7_73.11.7_73.11.8_7
FreeBSD:14:latest3.11.13_103.11.13_103.11.1_73.11.13_103.11.13_103.11.4_7-3.11.4_7
FreeBSD:14:quarterly3.11.13_103.11.13_10-3.11.13_103.11.13_103.11.7_73.11.7_73.11.8_7
FreeBSD:15:latest3.11.13_103.11.13_10n/a3.11.13_10n/a3.11.7_73.11.7_73.11.8_7
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/a---
 

py312-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.12.11_103.12.11_10-3.12.11_103.12.11_10---
FreeBSD:13:quarterly3.12.11_103.12.11_10-3.12.11_103.12.11_10---
FreeBSD:14:latest3.12.11_103.12.11_10-3.12.11_103.12.11_10---
FreeBSD:14:quarterly3.12.11_103.12.11_10-3.12.11_103.12.11_10---
FreeBSD:15:latest3.12.11_103.12.11_10n/a3.12.11_10n/a---
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest--n/a-n/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. python3.11 : lang/python311
  4. py311-build>=0 : devel/py-build@py311
  5. 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. 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-data
Expand this list (49 items / 42 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. mail/thunderbird-esr
  10. math/cado-nfs
  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 18 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. math/sage*
  10. security/bro*
  11. security/hotssh*
  12. sysutils/uefi-edk2-bhyve-csm*
  13. sysutils/uefi-edk2-bhyve-devel*
  14. sysutils/uefi-edk2-qemu*
  15. www/cliqz*
  16. www/libxul*
  17. www/seamonkey*
  18. x11/hotwire-shell*
  19. 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/grass8
Expand this list (198 items / 191 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/py-aiosqlite
  3. databases/py-minidb
  4. databases/py-sqlalchemy10
  5. databases/py-sqlalchemy14
  6. databases/py-sqlalchemy20
  7. databases/py-sqlite-anyio
  8. databases/py-sqlite-fts4
  9. deskutils/py-khal
  10. deskutils/py-paperless
  11. deskutils/py-paperless-ngx
  12. deskutils/py-vdirsyncer
  13. deskutils/py-vorta
  14. deskutils/zim
  15. devel/eric6
  16. devel/ipython
  17. devel/py-acstore
  18. devel/py-avocado-framework
  19. devel/py-b2sdk
  20. devel/py-boltons
  21. devel/py-coverage
  22. devel/py-hg-evolve
  23. devel/py-nbformat
  24. devel/py-pre-commit
  25. devel/rbtools
  26. dns/dnsrecon
  27. emulators/fs-uae-launcher
  28. filesystems/py-dfvfs
  29. finance/electrum
  30. finance/py-finviz
  31. games/anki
  32. games/py-mnemosyne-proj
  33. games/unknown-horizons
  34. graphics/py-mcomix
  35. graphics/py-projpicker
  36. graphics/qgis
  37. graphics/qgis-ltr
  38. graphics/rapid-photo-downloader
  39. irc/py-sopel
  40. mail/notimail
  41. mail/py-offlineimap3
  42. mail/py-tlsrpt-reporter
  43. math/cado-nfs
  44. math/py-pandas
  45. multimedia/gpodder
  46. multimedia/kodi
  47. multimedia/mythtv
  48. multimedia/pitivi
  49. multimedia/tautulli
  50. net/google-cloud-sdk
  51. net-im/gajim
  52. net-im/py-matrix-synapse
  53. net-mgmt/seafile-client
  54. net-mgmt/seafile-server
  55. net-p2p/bazarr
  56. news/sabnzbd
  57. science/gramps
  58. science/py-ruffus
  59. security/maltrail
  60. security/nyx
  61. security/py-fail2ban
  62. security/py-plaso
  63. security/py-pyaxo
  64. security/py-volatility3
  65. security/sqlmap
  66. security/theonionbox
  67. security/wapiti
  68. security/zeek
  69. security/zeronet
  70. sysutils/angrysearch
  71. sysutils/conan
  72. sysutils/py-bitrot
  73. sysutils/py-queuelib
  74. sysutils/tuptime
  75. textproc/ibus-table
  76. textproc/ibus-typing-booster
  77. textproc/py-nltk
  78. textproc/translate-toolkit
  79. www/buku
  80. www/eolie
  81. www/gallery-dl
  82. www/mitmproxy
  83. www/offpunk
  84. www/persepolis
  85. www/py-calibreweb
  86. www/py-django-cms
  87. www/py-django42
  88. www/py-django51
  89. www/py-django52
  90. www/py-lektor
  91. www/py-searxng-devel
  92. www/py-yt-dlp
  93. www/trac
  94. www/yt-dlp
  95. x11/ulauncher
  96. Collapse this list.

Deleted ports which required this port:

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

There are no commits on branch 2023Q4 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
pcre2Sep 20
jenkinsSep 17
jenkins-ltsSep 17
cups*Sep 16
chromiumSep 11
gitlabSep 11
ungoogled-chromiumSep 11
chromiumSep 07
ungoogled-chromiumSep 07
exiv2Sep 04
exiv2Sep 04
py-django42Sep 04
py-django51Sep 04
py-django52Sep 04
linux-viebSep 03

6 vulnerabilities affecting 166 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-09-20 08:13:42 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33650
Broken 126
Deprecated 181
Ignore 244
Forbidden 0
Restricted 2
No CDROM 1
Vulnerable 34
Expired 15
Set to expire 125
Interactive 0
new 24 hours 6
new 48 hours11
new 7 days43
new fortnight82
new month159
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.