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 2023Q1
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.20_73.9.21_73.9.16_73.9.20_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.20_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.15_73.10.16_73.10.9_73.10.15_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.15_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.10_73.11.11_73.11.1_73.11.10_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.10_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 2023Q1 for this port