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.
Port details
sqlite3 SQL database engine in a C library
3.50.2_1,1 databases on this many watch lists=154 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.50.2_1,1Version of this port present on the latest quarterly branch.
Maintainer: pavelivolkov@gmail.com search for ports maintained by this maintainer
Port Added: 2004-08-31 19:11:46
Last Update: 2025-08-01 09:42:48
Commit Hash: 180cc2b
People watching this port, also watch:: expat, libiconv, libxml2, pcre, png
License: PD
WWW:
https://www.sqlite.org/
Description:
SQLite is an SQL database engine in a C library. Programs that link the SQLite library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite3) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.
Homepage    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:
  • sqlite3>0:databases/sqlite3
Conflicts:
CONFLICTS_INSTALL:
  • sqlite3
  • sqlite3-icu
  • sqlite3-tcl
  • tcl-sqlite3
To install the port:
cd /usr/ports/databases/sqlite3/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/sqlite3
  • pkg install sqlite3
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: sqlite3
Package flavors (<flavor>: <package>)
  • default: sqlite3
  • icu: sqlite3-icu
  • tcl: sqlite3-tcl
distinfo:
TIMESTAMP = 1751267280 SHA256 (sqlite-src-3500200.zip) = 091eeec3ae2ccb91aac21d0e9a4a58944fb2cb112fa67bffc3e08c2eca2d85c8 SIZE (sqlite-src-3500200.zip) = 14392422

Packages (timestamps in pop-ups are UTC):
sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.2_1,13.50.2_1,13.34.0,13.50.2_1,13.50.2_1,1-3.34.0,1-
FreeBSD:13:quarterly3.46.1_1,13.50.2_1,13.42.0,13.46.1_1,13.50.2_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.50.2_1,13.50.2_1,13.40.1,13.50.2_1,13.50.2_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.50.2_1,13.50.2_1,1-3.46.1_1,13.50.2_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.50.2_1,13.50.2_1,1n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
sqlite3-icu
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.2_1,13.50.2_1,1-3.50.2_1,13.50.2_1,1---
FreeBSD:13:quarterly3.46.1_1,13.50.2_1,13.42.0,13.46.1_1,13.50.2_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.50.2_1,13.50.2_1,13.40.1,13.50.2_1,13.50.2_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.50.2_1,13.50.2_1,1-3.46.1_1,13.50.2_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest--n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
sqlite3-tcl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.2_1,13.50.2_1,1-3.50.2_1,13.50.2_1,1---
FreeBSD:13:quarterly3.46.1_1,13.50.2_1,13.42.0,13.46.1_1,13.50.2_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.50.2_1,13.50.2_1,13.40.1,13.50.2_1,13.50.2_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.50.2_1,13.50.2_1,1-3.46.1_1,13.50.2_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest--n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. tclsh8.6 : lang/tcl86
Library dependencies:
  1. libedit.so.0 : devel/libedit
This port is required by:
for Build
  1. databases/lua-lsqlite3
  2. databases/py-apsw
  3. dns/opendnssec2
  4. lang/basic256
  5. ports-mgmt/portfind
  6. sysutils/fastfetch

Deleted ports which required this port:

Expand this list of 15 deleted ports
  1. databases/php-sqlite3*
  2. devel/gearmand-devel*
  3. devel/subversion-static*
  4. dns/bind10*
  5. dns/bundy*
  6. dns/opendnssec13*
  7. misc/cdcollect*
  8. net/desktop-data-model*
  9. sysutils/docker-freebsd*
  10. textproc/askgit*
  11. textproc/mergestat*
  12. www/cliqz*
  13. www/hedgedoc*
  14. www/libxul*
  15. www/seamonkey*
  16. Collapse this list of deleted ports.
for Libraries
  1. archivers/rpm4
  2. archivers/urbackup-client
  3. archivers/urbackup-server
  4. astro/foxtrotgps
  5. astro/merkaartor
  6. astro/opencpn
  7. astro/viking
Expand this list (579 items / 572 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. audio/audacity
  3. audio/deadbeef-waveform-seekbar-plugin
  4. audio/gnome-podcasts
  5. audio/gogglesmm
  6. audio/gonic
  7. audio/harp
  8. audio/libdjinterop
  9. audio/libgpod
  10. audio/linuxsampler
  11. audio/lollypop
  12. audio/mixxx
  13. audio/osd-lyrics
  14. audio/owntone
  15. audio/pragha
  16. audio/shortwave
  17. audio/strawberry
  18. biology/abyss
  19. biology/augustus
  20. biology/gcta
  21. biology/ncbi-blast+
  22. biology/ugene
  23. cad/camotics
  24. cad/horizon-eda
  25. cad/qelectrotech
  26. chinese/ibus-array
  27. chinese/ibus-libpinyin
  28. chinese/ibus-pinyin
  29. chinese/libcangjie
  30. chinese/libchewing
  31. chinese/pycangjie
  32. chinese/pyzy
  33. comms/trustedqsl
  34. databases/akonadi
  35. databases/courier-authlib-sqlite
  36. databases/cppdb
  37. databases/diesel
  38. databases/evolution-data-server
  39. databases/fmptools
  40. databases/gom
  41. databases/grass8
  42. databases/kdb
  43. databases/libdbi-drivers
  44. databases/libdrizzle
  45. databases/libgda5
  46. databases/libgda5-jdbc
  47. databases/libgda5-ldap
  48. databases/libgda5-mysql
  49. databases/libgda5-postgresql
  50. databases/libgda5-ui
  51. databases/libgda6
  52. databases/libzdb
  53. databases/lua-lsqlite3
  54. databases/luasql-sqlite3
  55. databases/ocaml-sqlite3
  56. databases/ods2sql
  57. databases/pgloader3
  58. databases/php81-pdo_sqlite
  59. databases/php81-sqlite3
  60. databases/php82-pdo_sqlite
  61. databases/php82-sqlite3
  62. databases/php83-pdo_sqlite
  63. databases/php83-sqlite3
  64. databases/php84-pdo_sqlite
  65. databases/php84-sqlite3
  66. databases/php85-pdo_sqlite
  67. databases/php85-sqlite3
  68. databases/proftpd-mod_sql_sqlite
  69. databases/py-apsw
  70. databases/py-databases
  71. databases/py-ormar
  72. databases/py-peewee
  73. databases/py-sqlite3
  74. databases/qt5-sqldrivers-sqlite3
  75. databases/qt6-base_sqldriver
  76. databases/rubygem-do_sqlite3
  77. databases/rubygem-sqlite3
  78. databases/rubygem-sqlite3-ruby
  79. databases/rubygem-sqlite31
  80. databases/soci
  81. databases/spatialite
  82. databases/spatialite-tools
  83. databases/spatialite_gui
  84. databases/sqlcached
  85. databases/sqlclient
  86. databases/sqlite-ext-miscfuncs
  87. databases/sqlite-ext-pcre
  88. databases/sqlite-ext-regexp
  89. databases/sqlite-ext-spellfix
  90. databases/sqlitebrowser
  91. databases/sqlitecpp
  92. databases/sqliteodbc
  93. databases/sqlitestudio
  94. databases/tcl-sqlite3
  95. databases/virtualpg
  96. deskutils/bookworm
  97. deskutils/calibre
  98. deskutils/cherrytree
  99. deskutils/fbreader
  100. deskutils/gnome-contacts
  101. deskutils/gnome-pomodoro
  102. deskutils/growl-for-linux
  103. deskutils/gworkspace-gwmetadata
  104. deskutils/nextcloudclient
  105. deskutils/owncloudclient
  106. deskutils/pinot
  107. deskutils/presage
  108. deskutils/subsurface
  109. deskutils/xfce4-notifyd
  110. devel/RStudio
  111. devel/appstream-glib
  112. devel/build2
  113. devel/cbang
  114. devel/codequery
  115. devel/cvstrac
  116. devel/ghostie
  117. devel/gittrac
  118. devel/ikos
  119. devel/kyua
  120. devel/laminar
  121. devel/libsoup
  122. devel/libsoup3
  123. devel/llbuild
  124. devel/matreshka
  125. devel/p5-subversion
  126. devel/phasar
  127. devel/poco
  128. devel/py-subversion
  129. devel/ruby-subversion
  130. devel/subversion
  131. devel/subversion-lts
  132. devel/svntrac
  133. devel/tinysparql
  134. devel/zeal
  135. dns/opendnssec2
  136. dns/powerdns
  137. editors/emacs
  138. editors/emacs-devel
  139. editors/texmacs
  140. emulators/mame
  141. emulators/mgba
  142. emulators/nemu
  143. filesystems/securefs
  144. finance/ktoblzcheck
  145. ftp/filezilla
  146. ftp/wzdftpd
  147. games/DDNet
  148. games/etlegacy
  149. games/flightgear
  150. games/freeciv
  151. games/freeciv-nox11
  152. games/freeciv21
  153. games/freeminer
  154. games/irrlamb
  155. games/ldmud
  156. games/luanti
  157. games/minetestmapper
  158. games/openmw
  159. games/pokerth
  160. games/stonesoup
  161. games/supertuxkart
  162. games/warzone2100
  163. games/wyrmgus
  164. games/xmoto
  165. german/tipp10
  166. graphics/birdfont
  167. graphics/colmap
  168. graphics/colord
  169. graphics/colord-gtk
  170. graphics/darktable
  171. graphics/elementary-photos
  172. graphics/gdal
  173. graphics/hugin
  174. graphics/libchamplain
  175. graphics/librasterlite2
  176. graphics/mapcache
  177. graphics/mapnik
  178. graphics/openslide
  179. graphics/osgearth
  180. graphics/ossim
  181. graphics/proj
  182. graphics/qgis
  183. graphics/qgis-ltr
  184. graphics/rawstudio
  185. graphics/shotwell
  186. graphics/tippecanoe
  187. graphics/zathura
  188. irc/anope-devel
  189. irc/ircd-ratbox
  190. irc/soju
  191. japanese/uim-anthy-unicode
  192. java/java-subversion
  193. java/openjfx14
  194. java/sqlitejdbc
  195. lang/munger
  196. lang/racket
  197. lang/seed7
  198. lang/smalltalk
  199. lang/snobol4
  200. lang/swift510
  201. mail/balsa
  202. mail/bogofilter-sqlite
  203. mail/cyrus-imapd30
  204. mail/cyrus-imapd310
  205. mail/cyrus-imapd312
  206. mail/cyrus-imapd32
  207. mail/cyrus-imapd34
  208. mail/cyrus-imapd36
  209. mail/cyrus-imapd38
  210. mail/dovecot-fts-xapian
  211. mail/dspam
  212. mail/evolution
  213. mail/evolution-ews
  214. mail/exim-sqlite
  215. mail/geary
  216. mail/greylite
  217. mail/mlmmj-archive-mid
  218. mail/mlmmj-archiver
  219. mail/mutt
  220. mail/opensmtpd-extras-table-sqlite
  221. mail/opensmtpd-table-sqlite
  222. mail/rspamd
  223. mail/rspamd-devel
  224. math/R-cran-terra
  225. math/cadabra2
  226. math/mdal
  227. math/octave-forge-sqlite
  228. math/openturns
  229. misc/adios2
  230. multimedia/arcan
  231. multimedia/avidemux
  232. multimedia/avidemux-cli
  233. multimedia/avidemux-plugins
  234. multimedia/avidemux-qt5
  235. multimedia/emby-server
  236. multimedia/jellyfin
  237. multimedia/kodi
  238. net/asterisk18
  239. net/asterisk20
  240. net/asterisk22
  241. net/csync2
  242. net/freeswitch
  243. net/gerbera
  244. net/glusterfs
  245. net/grilo-plugins
  246. net/kamailio
  247. net/kget
  248. net/liblinphone
  249. net/liferea
  250. net/mediastreamer
  251. net/megacmd
  252. net/minidlna
  253. net/ntopng
  254. net/onedrive
  255. net/rssguard
  256. net/siproxd
  257. net/turnserver
  258. net/vnstat
  259. net-im/abaddon
  260. net-im/dino
  261. net-im/ejabberd
  262. net-im/folks
  263. net-im/libaccounts-glib
  264. net-im/pidgin
  265. net-im/profanity
  266. net-im/telepathy-gabble
  267. net-im/telepathy-logger
  268. net-mgmt/aircrack-ng
  269. net-mgmt/andwatch
  270. net-mgmt/rackmonkey
  271. net-mgmt/seafile-client
  272. net-mgmt/seafile-gui
  273. net-mgmt/seafile-server
  274. net-p2p/bitcoin
  275. net-p2p/bitcoin-daemon
  276. net-p2p/bitcoin-utils
  277. net-p2p/c-lightning
  278. net-p2p/clboss
  279. net-p2p/lidarr
  280. net-p2p/ncdc
  281. net-p2p/prowlarr
  282. net-p2p/radarr
  283. net-p2p/readarr
  284. net-p2p/sonarr
  285. net-p2p/udpt
  286. net-p2p/uhub
  287. news/inn
  288. news/inn-current
  289. ports-mgmt/packagekit
  290. ports-mgmt/pkgcompare
  291. print/simple-fb2-reader
  292. print/sioyek
  293. science/dlib-cpp
  294. science/orthanc
  295. science/orthanc-webviewer
  296. science/paraview
  297. science/py-dlib
  298. science/py-tensorflow
  299. science/ttk
  300. science/vmd
  301. science/zotero
  302. security/arti
  303. security/authenticator
  304. security/axc
  305. security/bzrtp
  306. security/cvechecker
  307. security/diswall
  308. security/flawz
  309. security/gnupg
  310. security/klee
  311. security/libomemo
  312. security/nss
  313. security/sequoia-chameleon-gnupg
  314. security/sequoia-sq
  315. security/softhsm2
  316. security/sslproxy
  317. security/subversion-gnome-keyring
  318. security/tpm2-pkcs11
  319. security/wazuh-agent
  320. security/wazuh-manager
  321. security/ylva
  322. sysutils/bulk_extractor
  323. sysutils/cbsd
  324. sysutils/createrepo_c
  325. sysutils/dupd
  326. sysutils/libdnf
  327. sysutils/lnav
  328. sysutils/nix
  329. sysutils/sleuthkit
  330. sysutils/zeitgeist
  331. textproc/link-grammar
  332. textproc/mandoc
  333. textproc/redland
  334. textproc/uim
  335. textproc/uim-gtk2
  336. textproc/uim-gtk3
  337. textproc/uim-m17nlib
  338. textproc/uim-qt5
  339. textproc/uim-qt6
  340. www/aria2
  341. www/bacula-web
  342. www/domoticz
  343. www/domoticz-devel
  344. www/ephemera
  345. www/epiphany
  346. www/fusionpbx
  347. www/kannel
  348. www/kannel-sqlbox
  349. www/luakit
  350. www/luakit-devel
  351. www/midori
  352. www/mod_dav_svn
  353. www/ncgopher
  354. www/newsboat
  355. www/newsraft
  356. www/rssroll
  357. www/trafficserver
  358. www/webkit2-gtk
  359. www/wt
  360. www/xsp
  361. x11/yelp
  362. x11-fonts/font-manager
  363. x11-toolkits/libshumate
  364. Collapse this list.

Deleted ports which required this port:

Expand this list of 210 deleted ports
  1. archivers/rpm5*
  2. astro/osmium*
  3. astro/tangogps*
  4. audio/clementine-player*
  5. audio/firefly*
  6. audio/forked-daapd*
  7. audio/gmpc*
  8. audio/gmpc-magnatune*
  9. audio/gradio*
  10. audio/libgpod-sharp*
  11. audio/linnya*
  12. audio/xmms2*
  13. biology/seqtools*
  14. chinese/sunpinyin*
  15. databases/adabase*
  16. databases/emacs-sqlite3-api*
  17. databases/gdl2*
  18. databases/gosqlite3*
  19. databases/grass7*
  20. databases/gtksql*
  21. databases/mysql-workbench52*
  22. databases/php5-pdo_sqlite*
  23. databases/php5-sqlite3*
  24. databases/php53-pdo_sqlite*
  25. databases/php53-sqlite3*
  26. databases/php55-pdo_sqlite*
  27. databases/php55-sqlite3*
  28. databases/php56-pdo_sqlite*
  29. databases/php56-sqlite3*
  30. databases/php70-pdo_sqlite*
  31. databases/php70-sqlite3*
  32. databases/php71-pdo_sqlite*
  33. databases/php71-sqlite3*
  34. databases/php72-pdo_sqlite*
  35. databases/php72-sqlite3*
  36. databases/php73-pdo_sqlite*
  37. databases/php73-sqlite3*
  38. databases/php74-pdo_sqlite*
  39. databases/php74-sqlite3*
  40. databases/php80-pdo_sqlite*
  41. databases/php80-sqlite3*
  42. databases/pure-sql3*
  43. databases/py3-apsw*
  44. databases/py32-sqlite3*
  45. databases/py33-sqlite3*
  46. databases/py34-sqlite3*
  47. databases/py35-sqlite3*
  48. databases/py36-sqlite3*
  49. databases/pypy-sqlite3*
  50. databases/qt4-sqlite3-plugin*
  51. databases/ruby-dbd_sqlite3*
  52. databases/sqlite-ext-mobigroup*
  53. databases/sqlitebrowser-qt5*
  54. databases/sqliteman*
  55. databases/vsqlite*
  56. deskutils/ktagebuch*
  57. deskutils/mirall*
  58. deskutils/osmo*
  59. devel/clanlib*
  60. devel/clanlib22*
  61. devel/gearmand*
  62. devel/gearmand-devel*
  63. devel/ignition-transport*
  64. devel/ksql*
  65. devel/kyua-cli*
  66. devel/libopensync*
  67. devel/libopensync022*
  68. devel/libsoup-gnome*
  69. devel/monotone*
  70. devel/nemiver*
  71. devel/poco-devel*
  72. devel/poco-ssl*
  73. devel/py-yum-metadata-parser*
  74. devel/seed*
  75. devel/seed3*
  76. devel/subversion16*
  77. devel/subversion17*
  78. devel/subversion18*
  79. devel/subversion19*
  80. dns/bind10*
  81. dns/bundy*
  82. dns/opendnssec13*
  83. editors/codelite*
  84. emulators/mess*
  85. filesystems/sqlfs*
  86. games/gcompris*
  87. games/kajongg-kde4*
  88. games/latrine*
  89. games/minetest*
  90. games/mudmagic*
  91. games/stonesoup-sdl*
  92. games/voxelands*
  93. games/voxelands-server*
  94. games/xptools*
  95. graphics/darktable38*
  96. graphics/darktable40*
  97. graphics/darktable42*
  98. graphics/f-spot*
  99. graphics/hugin-2016*
  100. graphics/libchamplain08*
  101. graphics/librasterlite*
  102. graphics/libreatlas*
  103. irc/ircd-ratbox-devel*
  104. irc/ratbox-services*
  105. japanese/uim-anthy*
  106. java/openjfx8-devel*
  107. java/subversion-java*
  108. lang/J*
  109. lang/neko*
  110. lang/phantomjs*
  111. lang/pypy-devel*
  112. lang/pypy3-devel*
  113. lang/swift*
  114. mail/dspam-devel*
  115. mail/libmapi*
  116. math/sage*
  117. misc/katalog*
  118. misc/krecipes*
  119. misc/krecipes-kde4*
  120. multimedia/avidemux-qt4*
  121. multimedia/avidemux26*
  122. multimedia/avidemux26-cli*
  123. multimedia/avidemux26-plugins*
  124. multimedia/avidemux26-qt4*
  125. multimedia/banshee*
  126. multimedia/emby-server-devel*
  127. multimedia/freetuxtv*
  128. multimedia/gmerlin*
  129. multimedia/kodi-devel*
  130. multimedia/mediabrowser*
  131. multimedia/miro*
  132. multimedia/plexhometheater*
  133. multimedia/vdr-plugin-upnp*
  134. multimedia/xbmc*
  135. multimedia/xbmc-pvr*
  136. net/asterisk*
  137. net/asterisk10*
  138. net/asterisk11*
  139. net/asterisk13*
  140. net/asterisk15*
  141. net/asterisk16*
  142. net/coturn*
  143. net/desktop-data-model*
  144. net/kget-kde4*
  145. net/mediatomb*
  146. net/ns3*
  147. net/owncloud-csync*
  148. net/quiterss*
  149. net/s3ql*
  150. net-im/biboumi*
  151. net-im/cawbird*
  152. net-im/corebird*
  153. net-im/kopete-kde4*
  154. net-im/openfetion*
  155. net-im/ring-gnome*
  156. net-im/telepathy-salut*
  157. net-im/venom*
  158. net-mgmt/ccnet*
  159. net-mgmt/ccnet-client*
  160. net-mgmt/ccnet-server*
  161. net-mgmt/seafile*
  162. net-mgmt/sx*
  163. net-p2p/gnunet*
  164. net-p2p/sonarr-devel*
  165. news/inn-CURRENT*
  166. ports-mgmt/chucky*
  167. ports-mgmt/packagekit-qt4*
  168. ports-mgmt/prhistory*
  169. science/coot*
  170. security/certificate-transparency*
  171. security/gnomint*
  172. security/gnupg22*
  173. security/klamav*
  174. security/openvas-manager*
  175. security/openvas8-manager*
  176. security/openvas9-manager*
  177. security/ruby-bitwarden*
  178. security/softhsm*
  179. security/subversion-kwallet*
  180. security/titan*
  181. sysutils/fluxengine*
  182. sysutils/fusefs-sqlfs*
  183. sysutils/istatserver*
  184. sysutils/tracker*
  185. sysutils/tracker-client*
  186. sysutils/tracker-gnome*
  187. sysutils/tracker-libtrackergtk*
  188. sysutils/tracker-miners*
  189. sysutils/tracker3*
  190. textproc/mdocml*
  191. textproc/soothsayer*
  192. textproc/uim-gtk*
  193. textproc/uim-kde4*
  194. textproc/uim-qt4*
  195. www/glewlwyd*
  196. www/libxul*
  197. www/libxul19*
  198. www/mnogosearch*
  199. www/mod_auth_openid*
  200. www/mongrel2*
  201. www/newsbeuter*
  202. www/qt5-webkit*
  203. www/seamonkey*
  204. www/webkit-gtk2*
  205. www/webkit-gtk3*
  206. www/webkit-qt5*
  207. www/webkit2-gtk3*
  208. www/webkit2-gtk4*
  209. www/wt3*
  210. x11-toolkits/libshumate-shortwave*
  211. Collapse this list of deleted ports.
for Run
  1. comms/limesuite
  2. games/gnubg
  3. lang/mono6.8
  4. ports-mgmt/portfind
  5. ports-mgmt/portsdb

Deleted ports which required this port:

Expand this list of 2 deleted ports
  1. misc/cdcollect*
  2. sysutils/docker-freebsd*
  3. 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:
===> The following configuration options are available for sqlite3-3.50.2_1,1: ARMOR=off: Detect misuse of the API DBPAGE=on: Enable DBPAGE Virtual Table DBSTAT=on: Enable DBSTAT Virtual Table DIRECT_READ=on: File is read directly from disk DQS=off: Double-quoted String Literals EXAMPLES=on: Build and/or install examples EXTENSION=on: Enable loadable extensions FTS3_TOKEN=on: Enable two-args version fts3_tokenizer FTS4=on: Enable FTS3/4 (Full Text Search) module FTS5=on: Enable version 5 full-text search engine LIKENOTBLOB=off: LIKE does not match blobs MEMMAN=off: Allow it to release unused memory METADATA=on: Enable column metadata NORMALIZE=off: Enable normalized sql function NULL_TRIM=off: Omits NULL columns at the ends of rows RBU=off: Enable the resumable bulk update SECURE_DELETE=on: Overwrite deleted information with zeros SORT_REF=off: To use references in the sorter STATIC=off: Build static executables and/or libraries STMT=off: Prepared statement scan status STRIP=on: Strip binaries before installation TCL=off: Enable tcl extension and sqlite_analyzer THREADS=on: Threading support TRUSTED_SCHEMA=off: SQL functions & virtual tables are considered unsafe UNKNOWN_SQL=off: Suppress unknown function errors UNLOCK_NOTIFY=on: Enable notification on unlocking UPDATE_LIMIT=off: UPDATE/DELETE is extended with ORDER BY and LIMIT URI=on: Enable use the URI filename URI_AUTHORITY=off: Allow convert URL into a UNC ====> Optional extensions SESSION=off: Enable the session extension ====> Optional functions OFFSET=off: Enable sqlite_offset() returning records file offset SOUNDEX=off: Enable the soundex() SQL function ====> Index type for range queries GEOPOLY=off: Uses the GeoJSON notation (RFC-7946) RTREE=on: Enable R*Tree module RTREE_INT=off: Store 32-bit sig int (no float) coordinates ====> Unicode support ICU=off: Unicode support via ICU UNICODE61=on: Unicode Version 6.1 tokenizer ====> Where to store temporary file: you have to select exactly one of them TS0=off: Always use temporary file TS1=on: File by default, change allowed PRAGMA TS2=off: Memory by default, change allowed PRAGMA TS3=off: Always use memory ====> Which query planner to use, stability or ...: you can only select none or one of them STAT3=off: Collect histogram data from leftmost column STAT4=off: Collect histogram data from all columns ====> Command line editing library: you can only select none or one of them LIBEDIT=on: Command line editing via libedit READLINE=off: Command line editing via libreadline ===> Use 'make config' to modify these settings
Options name:
databases_sqlite3
USES:
libtool ncurses zip libedit tcl:build
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (3 items)
Collapse this list.
  1. https://www.sqlite.org/2025/
  2. https://www2.sqlite.org/2025/
  3. https://www3.sqlite.org/2025/
Collapse this list.
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2023-03-13
    Affects: users of databases/sqlite3
    Author: fuz@FreeBSD.org
    Reason: 
      Due to various ports not being prepared for this change (see 20230227
      entry), the DQS option of databases/sqlite3 has been reenabled as a
      stop gap measure.  It is scheduled to be disabled again for good no
      earlier than 20240101, giving downstream software authors more time
      to fix their queries.
    
      See also: https://sqlite.org/quirks.html#dblquote
    
    
Expand this list (1 items)
  • 2023-02-27
    Affects: users of databases/sqlite3
    Author: fuz@FreeBSD.org
    Reason: 
      Option DQS is now disabled by default.  This option controls the "double
      quoted string literals are accepted" quirk, permitting the use of double
      quotes around string literals if enabled.  Users who rely on this quirk
      need to manually build databases/sqlite3 with the DQS option enabled.
    
      See also: https://sqlite.org/quirks.html#dblquote
    
    
  • Collapse this list.

Number of commits found: 247 (showing only 47 on this page)

«  1 | 2 | 3 

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
3.6.23.1_1
18 Aug 2010 22:02:12
Original commit files touched by this commit This port version is marked as vulnerable.
lwhsu search for other commits by this committer
- Fix 'make package' when NO_INSTALL_MANPAGES is defined

PR:             ports/146083
Submitted by:   Sunpoet Po-Chuan Hsieh <sunpoet AT sunpoet.net>
Approved by:    Pavel I Volkov <pol AT opk.ru> (maintainer)
3.6.23.1_1
03 Aug 2010 01:08:14
Original commit files touched by this commit This port version is marked as vulnerable.
linimon search for other commits by this committer
Over to new volunteer.

Approved by:    old maintainer
3.6.23.1_1
22 Apr 2010 15:34:08
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Revert to TCL patch-Makefile
3.6.23.1_1
22 Apr 2010 15:29:12
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Unbroken FTS3 and RTree usign TCL to build.
- Install manpages [1]
- Bump PORTREVISION

PR:             137296 [1]
Submitted by:   Pavel I Volkov <pol___opk.ru> [1]
3.6.23.1
20 Apr 2010 23:45:58
Original commit files touched by this commit This port version is marked as vulnerable.
wxs search for other commits by this committer
Update to 3.6.32.1.
Remove TCL build dependency using a patch from OpenBSD.

PR:             ports/145213
Submitted by:   Bapt <baptiste.daroussin@gmail.com>
Approved by:    mnag@ (maintainer timeout)
3.6.19
05 Mar 2010 19:31:38
Original commit files touched by this commit This port version is marked as vulnerable.
glarkin search for other commits by this committer
- Added OPTION to enable extension library loading

PR:             ports/143329
Submitted by:   glarkin
Approved by:    maintainer timeout (mnag; 37 days)
Feature safe:   yes
3.6.19
02 Nov 2009 10:11:49
Original commit files touched by this commit This port version is marked as vulnerable.
ale search for other commits by this committer
Update sqlite3 to 3.6.19 release:
- fix thread-safe support (does it make sense to have an option to disable it?)
- add R*Tree index OPTION
- rework/simplify the port

PR:             ports/139276
Submitted by:   ale
Approved by:    maintainer
3.6.14.2
02 Aug 2009 19:36:34
Original commit files touched by this commit This port version is marked as vulnerable.
mezz search for other commits by this committer
-Repocopy devel/libtool15 -> libtool22 and libltdl15 -> libltdl22.
-Update libtool and libltdl to 2.2.6a.
-Remove devel/libtool15 and devel/libltdl15.
-Fix ports build with libtool22/libltdl22.
-Bump ports that depend on libltdl22 due to shared library version change.
-Explain what to do update in the UPDATING.

It has been tested with GNOME2, XFCE4, KDE3, KDE4 and other many wm/desktop
and applications in the runtime.

With help:      marcus and kwm
Pointyhat-exp:  a few times by pav
Tested by:      pgollucci, "Romain Tartière" <romain@blogreen.org>, and
                a few MarcusCom CVS users. Also, I might have missed a few.
Repocopy by:    marcus
Approved by:    portmgr
3.6.14.2
09 Jun 2009 02:40:51
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.6.14.2
3.6.13
25 Apr 2009 02:44:12
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.6.13.
- Fix upgrade with tcl 8.4.
3.6.11
23 Mar 2009 05:31:15
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.6.11
- Change hard coded TCL dependancy to USE_TCL [1]

PR:             132382 [1]
Submitted by:   Scot W. Hetzel <swhetzel___gmail.com> [1]
3.6.10
27 Jan 2009 02:16:09
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.6.10

Requested by:   many
3.6.4
29 Oct 2008 16:40:09
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.6.4 [1]
- Add option to enable/disable column metadata [2]

PR:             125004 [2]
Submitted by:   Lapo Luchini <lapo___lapo.it> [2]
Requested by:   many [1]
3.5.6
21 Aug 2008 06:18:49
Original commit files touched by this commit This port version is marked as vulnerable.
rafan search for other commits by this committer
Update CONFIGURE_ARGS for how we pass CONFIGURE_TARGET to configure script.
Specifically, newer autoconf (> 2.13) has different semantic of the
configure target. In short, one should use --build=CONFIGURE_TARGET
instead of CONFIGURE_TARGET directly. Otherwise, you will get a warning
and the old semantic may be removed in later autoconf releases.

To workaround this issue, many ports hack the CONFIGURE_TARGET variable
so that it contains the ``--build='' prefix.

To solve this issue, under the fact that some ports still have
configure script generated by the old autoconf, we use runtime detection
in the do-configure target so that the proper argument can be used.

Changes to Mk/*:
 - Add runtime detection magic in bsd.port.mk
(Only the first 15 lines of the commit message are shown above View all of this commit message)
3.5.6
09 Apr 2008 13:42:26
Original commit files touched by this commit This port version is marked as vulnerable.
pav search for other commits by this committer
- Move from versioned tcl/tk CATEGORIES to simple tcl and tk categories

With hat:       portmgr
3.5.6
05 Apr 2008 14:49:38
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Finally, update to 3.5.6
- Enable THREADS by default

PS: See UPDATING if you have problems.

Requested by:   many
3.4.1
10 Aug 2007 12:07:12
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Fix build with FTS2

PR:             115271
Pointy hat to:  mnag
Reported by:    many
3.4.1
01 Aug 2007 14:22:13
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.4.1
- Make sqlite3 respect CC [1]
- Add support for FTS2 [2]

PR:             112286 [1], 113477 [2]
Submitted by:   Sergey Prikhodko <sergey___network-asp.biz> [1],
                Anton Berezin <tobez___FreeBSD.org> [2]
3.3.17
28 May 2007 18:21:27
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.17
3.3.16
21 Apr 2007 00:07:41
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.16

PR:             111925
Submitted by:   Michael Scheidell <scheidell___secnap.net>
3.3.15
10 Apr 2007 21:40:24
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.15
- Install example.tcl only if WITH_TCLWRAPPER are set [1]

Submitted by:   bland [1]
3.3.14
06 Apr 2007 02:07:35
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.14
3.3.13
25 Mar 2007 20:02:04
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
* databases/Makefile

- Add sqlite3-threads port

* databases/sqlite3

- Upgrade to 3.3.13 [1]

* databases/sqlite3-threads

- Create a slave port for threads-override-locks. [2]

PR:             110446 [1], 110104 [2]
Submitted by:   Michael Scheidell <scheidell___secnap.net> [1], thierry [2]
3.3.12
12 Feb 2007 12:47:47
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.12 [1]
- Fix FTS1 build [2]

Notified by:    Max Khitrov <mkhitrov___umd.edu> [1],
                Jeroen Ruigrok/asmodai <asmodai___in-nomine.org> [2]
3.3.8
13 Dec 2006 03:16:47
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Add OPTION to build FTS1 (Full text search).

PR:             106281
Submitted by:   Barry Pederson<bp___barryp.org>
3.3.8
21 Nov 2006 12:25:47
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.8
3.3.7
13 Aug 2006 22:52:34
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.7
- portlint(1)
3.3.6
11 Jun 2006 21:43:25
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.6
3.3.5
16 Apr 2006 03:29:40
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.5
- Teach sqlite{,3}.pc to use ${PTHREAD_LIBS} when select PTHREAD OPTIONS.
- Building docs via ALL_TARGET instead of post-build
3.3.4_1
23 Feb 2006 10:40:45
Original commit files touched by this commit This port version is marked as vulnerable.
ade search for other commits by this committer
Conversion to a single libtool environment.

Approved by:    portmgr (kris)
3.3.4
13 Feb 2006 16:53:12
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.4
- Add THREADS, DEBUG and DOCS in OPTIONS
- Fix build when select WITH_TCLWRAPPER and NOPORTDOCS
- Reorganize Makefile
3.3.3
10 Feb 2006 00:07:20
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
- Update to 3.3.3 [1]
- Reorganize Makefile

Submitted by:   cokane [1]
3.2.8
06 Jan 2006 21:16:54
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
Update to 3.2.8
Reorganize Makefile

Notified by:    edwin Version Check
3.2.7
15 Nov 2005 06:52:12
Original commit files touched by this commit This port version is marked as vulnerable.
ade search for other commits by this committer
Mass-conversion to the USE_AUTOTOOLS New World Order.  The code present
in bsd.autotools.mk essentially makes this a no-op given that all the
old variables set a USE_AUTOTOOLS_COMPAT variable, which is parsed in
exactly the same way as USE_AUTOTOOLS itself.

Moreover, USE_AUTOTOOLS has already been extensively tested by the GNOME
team -- all GNOME 2.12.x ports use it.

Preliminary documentation can be found at:
        http://people.FreeBSD.org/~ade/autotools.txt

which is in the process of being SGMLized before introduction into the
Porters Handbook.

Light blue touch-paper.  Run.
3.2.7
09 Nov 2005 02:32:50
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
Add SHA256
3.2.7
26 Sep 2005 13:39:55
Original commit files touched by this commit This port version is marked as vulnerable.
mnag search for other commits by this committer
Update to 3.2.7 [1]
Take MAINTAINER

PR:             86288
Submitted by:   Robin Breathe <robin@isometry.net> [1]
Approved by:    pav (mentor), green (maintainer)
3.2.5
06 Sep 2005 05:35:35
Original commit files touched by this commit This port version is marked as vulnerable.
green search for other commits by this committer
Update to version 3.2.5.
Unmark "beta" (from inside COMMENT).
Fix a NOPORTDOCS build issue.

Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
PR:     85420
3.2.2
15 Jul 2005 19:01:06
Original commit files touched by this commit This port version is marked as vulnerable.
pav search for other commits by this committer
- Update to 3.2.2

PR:             ports/82483
Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
Approved by:    maintainer timeout (24 days)
3.2.1
22 May 2005 00:06:40
Original commit files touched by this commit This port version is marked as vulnerable.
pav search for other commits by this committer
- Update to 3.2.1
- Use OPTIONS

PR:             ports/79024
Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
Approved by:    maintainer timeout (2 months)
3.0.8_2
12 Apr 2005 03:26:57
Original commit files touched by this commit This port version is marked as vulnerable.
obrien search for other commits by this committer
At Kris's request, back out the MACHINE_ARCH spelling correction until
after 5.4-RELEASE.
3.0.8_2
11 Apr 2005 08:04:41
Original commit files touched by this commit This port version is marked as vulnerable.
obrien search for other commits by this committer
Assist getting more ports working on AMD64 by obeying the
Ports Collection documentation and use 'ARCH' rather than 'MACHINE_ARCH'.
3.0.8_2
26 Dec 2004 01:22:43
Original commit files touched by this commit This port version is marked as vulnerable.
nork search for other commits by this committer
Add dependency on devel/pkgconfig.

Pointy hat to:  pointyhat via kris
3.0.8_1
23 Dec 2004 10:20:36
Original commit files touched by this commit This port version is marked as vulnerable.
nork search for other commits by this committer
Fix pkg-plist.  This problem is heinousness, so I bump PORTREVISION.

Pointy hat to:  myself
3.0.8
23 Dec 2004 08:25:47
Original commit files touched by this commit This port version is marked as vulnerable.
nork search for other commits by this committer
Clean up SQLite and related ports.
o Move databases/sqlite to databases/sqlite2.
o Fix dependency on databases/sqlite.
o Update sqlite2 to 2.8.15.
o Bump PORTREVISION, accordingly.

Approved by:    portmgr, maintainers of sqlite and related ports
3.0.8
23 Dec 2004 04:33:05
Original commit files touched by this commit This port version is marked as vulnerable.
edwin search for other commits by this committer
databases/sqlite3 does not link with tcl8.3

        When trying to build databases/sqlite3 port with SQLITE_WITH_TCL83
        defined, the linking stage fails.  It looks like sqlite3
        uses a funciton which is only available in tcl8.4.

Removed TCL83 support for databases/sqlite3

PR:             ports/72918
Submitted by:   Anton Berezin <tobez@freebsd.org>
3.0.8
23 Dec 2004 04:26:41
Original commit files touched by this commit This port version is marked as vulnerable.
edwin search for other commits by this committer
Update databases/sqlite3 to 3.0.8

        Update databases/sqlite3 to 3.0.8

PR:             ports/74571
Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
3.0.5
31 Aug 2004 19:06:39
Original commit files touched by this commit This port version is marked as vulnerable.
green search for other commits by this committer
Add SQLite 3 (in beta form).

Number of commits found: 247 (showing only 47 on this page)

«  1 | 2 | 3