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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

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=42 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, libxml2, expat, pcre, 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
FreeBSD:15:quarterly--n/a-n/a---
 
py310-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.10.14_73.10.14_7-3.10.14_73.10.14_7---
FreeBSD:13:quarterly3.10.14_73.10.14_73.10.12_73.10.14_73.10.14_73.10.13_73.10.13_73.10.13_7
FreeBSD:14:latest3.10.14_73.10.14_73.10.9_73.10.14_73.10.14_73.10.12_7-3.10.12_7
FreeBSD:14:quarterly3.10.13_73.10.14_7-3.10.13_73.10.14_73.10.13_73.10.13_73.10.13_7
FreeBSD:15:latest3.10.13_73.10.14_7n/a3.10.13_7n/a3.10.13_73.10.13_73.10.13_7
FreeBSD:15:quarterly--n/a-n/a---
 
py311-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.11.9_73.11.9_7-3.11.9_73.11.9_7---
FreeBSD:13:quarterly3.11.9_73.11.9_73.11.4_73.11.9_73.11.9_73.11.7_73.11.7_73.11.8_7
FreeBSD:14:latest3.11.8_73.11.9_73.11.1_73.11.8_73.11.9_73.11.4_7-3.11.4_7
FreeBSD:14:quarterly3.11.8_73.11.9_7-3.11.8_73.11.9_73.11.7_73.11.7_73.11.8_7
FreeBSD:15:latest3.11.8_73.11.9_7n/a3.11.8_7n/a3.11.7_73.11.7_73.11.8_7
FreeBSD:15:quarterly--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---
 
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---
 
py38-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.8.19_73.8.19_73.8.7_73.8.19_73.8.19_7-3.8.7_7-
FreeBSD:13:quarterly3.8.19_73.8.19_73.8.17_73.8.19_73.8.19_73.8.18_73.8.18_73.8.18_7
FreeBSD:14:latest3.8.19_73.8.19_73.8.16_73.8.19_73.8.19_73.8.17_7-3.8.17_7
FreeBSD:14:quarterly3.8.18_73.8.19_7-3.8.18_73.8.19_73.8.18_73.8.18_73.8.18_7
FreeBSD:15:latest3.8.18_73.8.19_7n/a3.8.18_7n/a3.8.18_73.8.18_73.8.18_7
FreeBSD:15:quarterly--n/a-n/a---
 
py39-sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.9.18_73.9.18_73.9.1_73.9.18_73.9.18_7-3.9.1_7-
FreeBSD:13:quarterly3.9.18_73.9.18_73.9.17_73.9.18_73.9.18_73.9.18_73.9.18_73.9.18_7
FreeBSD:14:latest3.9.18_73.9.18_73.9.16_73.9.18_73.9.18_73.9.17_7-3.9.17_7
FreeBSD:14:quarterly3.9.18_73.9.18_7-3.9.18_73.9.18_73.9.18_73.9.18_73.9.18_7
FreeBSD:15:latest3.9.18_73.9.18_7n/a3.9.18_7n/a3.9.18_73.9.18_73.9.18_7
FreeBSD:15:quarterly--n/a-n/a---
 
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/yt-dlp
  25. 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. 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. www/waterfox*
  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/solfege
  5. cad/fritzing
  6. databases/grass7
  7. databases/grass8
Expand this list (188 items / 181 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-sqlalchemy11
  6. databases/py-sqlalchemy12
  7. databases/py-sqlalchemy13
  8. databases/py-sqlalchemy14
  9. databases/py-sqlalchemy20
  10. databases/py-sqlite-fts4
  11. deskutils/griffith
  12. deskutils/py-khal
  13. deskutils/py-paperless
  14. deskutils/py-paperless-ngx
  15. deskutils/py-vdirsyncer
  16. deskutils/zim
  17. devel/b2
  18. devel/eric6
  19. devel/ipython
  20. devel/py-acstore
  21. devel/py-b2sdk
  22. devel/py-boltons
  23. devel/py-buildbot
  24. devel/py-coverage
  25. devel/py-hg-evolve
  26. devel/py-nbformat
  27. devel/py-pre-commit
  28. devel/rbtools
  29. dns/dnsrecon
  30. emulators/fs-uae-launcher
  31. finance/electrum
  32. finance/py-finviz
  33. games/anki
  34. games/py-mnemosyne-proj
  35. games/unknown-horizons
  36. graphics/py-projpicker
  37. graphics/qgis
  38. graphics/qgis-ltr
  39. graphics/rapid-photo-downloader
  40. irc/py-sopel
  41. mail/py-offlineimap3
  42. math/cado-nfs
  43. math/py-pandas
  44. math/sage
  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-dfvfs
  62. security/py-fail2ban
  63. security/py-plaso
  64. security/py-pyaxo
  65. security/py-volatility3
  66. security/sqlmap
  67. security/theonionbox
  68. security/wapiti
  69. security/zeek
  70. security/zeronet
  71. sysutils/angrysearch
  72. sysutils/conan
  73. sysutils/py-bitrot
  74. sysutils/py-queuelib
  75. sysutils/tuptime
  76. textproc/ibus-table
  77. textproc/ibus-typing-booster
  78. textproc/py-nltk
  79. textproc/translate-toolkit
  80. www/buku
  81. www/eolie
  82. www/gallery-dl
  83. www/mitmproxy
  84. www/offpunk
  85. www/persepolis
  86. www/py-django-cms
  87. www/py-django32
  88. www/py-django42
  89. www/py-django50
  90. www/py-lektor
  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 88 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-sqlite3dbm*
  13. databases/py-sqlkit*
  14. databases/py-swift*
  15. deskutils/anamnesis*
  16. deskutils/conduit*
  17. deskutils/gourmet*
  18. deskutils/hamster-applet*
  19. devel/buildbot*
  20. devel/bzr-git*
  21. devel/eric4*
  22. devel/ipython5*
  23. dns/bind10*
  24. dns/bundy*
  25. editors/leo*
  26. editors/zim*
  27. games/gcompris*
  28. games/py-anki*
  29. games/py-mnemosyne*
  30. graphics/comix*
  31. japanese/trac*
  32. mail/offlineimap*
  33. misc/diary-hercules*
  34. multimedia/kodi-devel*
  35. multimedia/miro*
  36. multimedia/plexhometheater*
  37. multimedia/plexpy*
  38. multimedia/pyjama*
  39. multimedia/xbmc*
  40. multimedia/xbmc-pvr*
  41. net/neubot*
  42. net/py-matrix-synapse*
  43. net-im/gajim-devel*
  44. net-mgmt/seafile*
  45. net-p2p/bazarr-devel*
  46. net-p2p/bitmessage*
  47. net-p2p/couchpotato*
  48. net-p2p/tribler*
  49. news/sabnzbdplus*
  50. news/xpn*
  51. security/bro*
  52. security/hotssh*
  53. security/pwman3*
  54. security/py-volatility*
  55. security/umit*
  56. security/w3af*
  57. security/zenmap*
  58. sysutils/yum*
  59. textproc/pootle*
  60. www/calendarserver*
  61. www/go-appengine-sdk*
  62. www/google-appengine*
  63. www/linkchecker*
  64. www/py-GinGin*
  65. www/py-buku*
  66. www/py-django-devel*
  67. www/py-django110*
  68. www/py-django111*
  69. www/py-django13*
  70. www/py-django14*
  71. www/py-django15*
  72. www/py-django16*
  73. www/py-django17*
  74. www/py-django18*
  75. www/py-django19*
  76. www/py-django20*
  77. www/py-django21*
  78. www/py-django22*
  79. www/py-django30*
  80. www/py-django31*
  81. www/py-django40*
  82. www/py-django41*
  83. www/py-yt-dlp-devel*
  84. www/pycarddav*
  85. www/roundup*
  86. www/trac-devel*
  87. x11/hotwire-shell*
  88. x11-fm/sunflower*
  89. 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
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
gitlabApr 24
py-matrix-synapseApr 24
ruby31Apr 23
ruby32Apr 23
ruby33Apr 23
glpiApr 22
glpiApr 22
glpiApr 22
sdl2_soundApr 22
chromiumApr 21
ungoogled-chromiumApr 21
clamavApr 19
jenkinsApr 19
jenkins-ltsApr 19
electron27Apr 18

21 vulnerabilities affecting 286 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2024-04-24 21:00:48 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 32219
Broken 85
Deprecated 178
Ignore 217
Forbidden 2
Restricted 2
No CDROM 1
Vulnerable 41
Expired 5
Set to expire 152
Interactive 0
new 24 hours 5
new 48 hours6
new 7 days20
new fortnight27
new month126
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2024 Dan Langille. All rights reserved.