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 photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Port details
sqlite3 SQL database engine in a C library
3.53.1,1 databases on this many watch lists=152 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.4_2,1Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2004-08-31 19:11:46
Last Update: 2026-05-31 12:03:06
Commit Hash: 176dd65
People watching this port, also watch:: libiconv, expat, libxml2, png, curl
License: PD
WWW:
https://www.sqlite.org/
https://github.com/sqlite/sqlite
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.
HomepageHomepage    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 = 1778366462 SHA256 (sqlite-src-3530100.zip) = 1b2b5755d9064c4d5d1b0bf5307b48b089963e291c40cc7351318aa1b61c460e SIZE (sqlite-src-3530100.zip) = 14515734

Packages (timestamps in pop-ups are UTC):
sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.4_2,13.50.4_2,13.34.0,13.50.2_1,13.50.4_2,1n/an/an/a
FreeBSD:13:quarterly3.50.4_2,13.50.4_2,13.42.0,13.50.2_1,13.50.4_2,1n/an/an/a
FreeBSD:14:latest3.53.1,13.53.1,13.40.1,13.50.2_1,13.53.1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.50.4_2,13.50.4_2,1-3.50.2_1,13.50.4_2,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.53.1,13.53.1,1n/a3.50.2_1,1n/an/a3.45.0_1,13.45.0_1,1
FreeBSD:15:quarterly3.50.4_2,13.50.4_2,1n/a-n/an/a--
FreeBSD:16:latest3.53.1,13.53.1,1n/a-n/an/a--
 
sqlite3-icu
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.4_2,13.50.4_2,1-3.50.2_1,13.50.4_2,1n/an/an/a
FreeBSD:13:quarterly3.50.4_2,13.50.4_2,13.42.0,13.50.2_1,13.50.4_2,1n/an/an/a
FreeBSD:14:latest3.53.1,13.53.1,13.40.1,13.50.2_1,13.53.1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.50.4_2,13.50.4_2,1-3.50.2_1,13.50.4_2,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.53.1,13.53.1,1n/a3.50.2_1,1n/an/a3.45.0_1,13.45.0_1,1
FreeBSD:15:quarterly3.50.4_2,13.50.4_2,1n/a-n/an/a--
FreeBSD:16:latest3.53.1,13.53.1,1n/a-n/an/a--
 
sqlite3-tcl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.50.4_2,13.50.4_2,1-3.50.2_1,13.50.4_2,1n/an/an/a
FreeBSD:13:quarterly3.50.4_2,13.50.4_2,13.42.0,13.50.2_1,13.50.4_2,1n/an/an/a
FreeBSD:14:latest3.53.1,13.53.1,13.40.1,13.50.2_1,13.53.1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.50.4_2,13.50.4_2,1-3.50.2_1,13.50.4_2,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.53.1,13.53.1,1n/a3.50.2_1,1n/an/a3.45.0_1,13.45.0_1,1
FreeBSD:15:quarterly3.50.4_2,13.50.4_2,1n/a-n/an/a--
FreeBSD:16:latest3.53.1,13.53.1,1n/a-n/an/a--
 
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. databases/py-sqlite-vec
  4. dns/opendnssec2
  5. lang/basic256
  6. misc/github-copilot-language-server
  7. ports-mgmt/portfind
Expand this list (23 items / 16 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. sysutils/fastfetch
  3. Collapse this list.

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

Deleted ports which required this port:

Expand this list of 220 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/php81-pdo_sqlite*
  43. databases/php81-sqlite3*
  44. databases/pure-sql3*
  45. databases/py3-apsw*
  46. databases/py32-sqlite3*
  47. databases/py33-sqlite3*
  48. databases/py34-sqlite3*
  49. databases/py35-sqlite3*
  50. databases/py36-sqlite3*
  51. databases/pypy-sqlite3*
  52. databases/qt4-sqlite3-plugin*
  53. databases/ruby-dbd_sqlite3*
  54. databases/sqlite-ext-mobigroup*
  55. databases/sqlitebrowser-qt5*
  56. databases/sqliteman*
  57. databases/vsqlite*
  58. deskutils/growl-for-linux*
  59. deskutils/ktagebuch*
  60. deskutils/mirall*
  61. deskutils/osmo*
  62. devel/clanlib*
  63. devel/clanlib22*
  64. devel/gearmand*
  65. devel/gearmand-devel*
  66. devel/ignition-transport*
  67. devel/ksql*
  68. devel/kyua*
  69. devel/kyua-cli*
  70. devel/libopensync*
  71. devel/libopensync022*
  72. devel/libsoup-gnome*
  73. devel/monotone*
  74. devel/nemiver*
  75. devel/poco-devel*
  76. devel/poco-ssl*
  77. devel/py-yum-metadata-parser*
  78. devel/seed*
  79. devel/seed3*
  80. devel/subversion16*
  81. devel/subversion17*
  82. devel/subversion18*
  83. devel/subversion19*
  84. dns/bind10*
  85. dns/bundy*
  86. dns/opendnssec13*
  87. editors/codelite*
  88. emulators/mess*
  89. filesystems/sqlfs*
  90. games/freeminer*
  91. games/gcompris*
  92. games/kajongg-kde4*
  93. games/latrine*
  94. games/minetest*
  95. games/mudmagic*
  96. games/pokerth*
  97. games/stonesoup-sdl*
  98. games/voxelands*
  99. games/voxelands-server*
  100. games/xptools*
  101. graphics/darktable38*
  102. graphics/darktable40*
  103. graphics/darktable42*
  104. graphics/f-spot*
  105. graphics/hugin-2016*
  106. graphics/libchamplain08*
  107. graphics/librasterlite*
  108. graphics/libreatlas*
  109. graphics/osgearth*
  110. graphics/tippecanoe*
  111. irc/ircd-ratbox-devel*
  112. irc/ratbox-services*
  113. japanese/uim-anthy*
  114. java/openjfx8-devel*
  115. java/subversion-java*
  116. lang/J*
  117. lang/neko*
  118. lang/phantomjs*
  119. lang/pypy-devel*
  120. lang/pypy3-devel*
  121. lang/swift*
  122. mail/dspam-devel*
  123. mail/libmapi*
  124. math/sage*
  125. misc/katalog*
  126. misc/krecipes*
  127. misc/krecipes-kde4*
  128. multimedia/avidemux-qt4*
  129. multimedia/avidemux26*
  130. multimedia/avidemux26-cli*
  131. multimedia/avidemux26-plugins*
  132. multimedia/avidemux26-qt4*
  133. multimedia/banshee*
  134. multimedia/emby-server-devel*
  135. multimedia/freetuxtv*
  136. multimedia/gmerlin*
  137. multimedia/kodi-devel*
  138. multimedia/mediabrowser*
  139. multimedia/miro*
  140. multimedia/plexhometheater*
  141. multimedia/vdr-plugin-upnp*
  142. multimedia/xbmc*
  143. multimedia/xbmc-pvr*
  144. net/asterisk*
  145. net/asterisk10*
  146. net/asterisk11*
  147. net/asterisk13*
  148. net/asterisk15*
  149. net/asterisk16*
  150. net/asterisk18*
  151. net/coturn*
  152. net/desktop-data-model*
  153. net/glusterfs*
  154. net/kget-kde4*
  155. net/mediatomb*
  156. net/ns3*
  157. net/owncloud-csync*
  158. net/quiterss*
  159. net/s3ql*
  160. net-im/biboumi*
  161. net-im/cawbird*
  162. net-im/corebird*
  163. net-im/kopete-kde4*
  164. net-im/openfetion*
  165. net-im/ring-gnome*
  166. net-im/telepathy-salut*
  167. net-im/venom*
  168. net-mgmt/ccnet*
  169. net-mgmt/ccnet-client*
  170. net-mgmt/ccnet-server*
  171. net-mgmt/seafile*
  172. net-mgmt/sx*
  173. net-p2p/gnunet*
  174. net-p2p/sonarr-devel*
  175. news/inn-CURRENT*
  176. ports-mgmt/chucky*
  177. ports-mgmt/packagekit-qt4*
  178. ports-mgmt/prhistory*
  179. science/coot*
  180. security/certificate-transparency*
  181. security/gnomint*
  182. security/gnupg22*
  183. security/klamav*
  184. security/openvas-manager*
  185. security/openvas8-manager*
  186. security/openvas9-manager*
  187. security/ruby-bitwarden*
  188. security/softhsm*
  189. security/subversion-kwallet*
  190. security/titan*
  191. sysutils/fluxengine*
  192. sysutils/fusefs-sqlfs*
  193. sysutils/istatserver*
  194. sysutils/tracker*
  195. sysutils/tracker-client*
  196. sysutils/tracker-gnome*
  197. sysutils/tracker-libtrackergtk*
  198. sysutils/tracker-miners*
  199. sysutils/tracker3*
  200. textproc/mdocml*
  201. textproc/soothsayer*
  202. textproc/uim-gtk*
  203. textproc/uim-kde4*
  204. textproc/uim-qt4*
  205. www/glewlwyd*
  206. www/libxul*
  207. www/libxul19*
  208. www/mnogosearch*
  209. www/mod_auth_openid*
  210. www/mongrel2*
  211. www/newsbeuter*
  212. www/qt5-webkit*
  213. www/seamonkey*
  214. www/webkit-gtk2*
  215. www/webkit-gtk3*
  216. www/webkit-qt5*
  217. www/webkit2-gtk3*
  218. www/webkit2-gtk4*
  219. www/wt3*
  220. x11-toolkits/libshumate-shortwave*
  221. Collapse this list of deleted ports.
for Run
  1. comms/limesuite
  2. games/gnubg
  3. lang/mono6.8
  4. misc/github-copilot-language-server
  5. ports-mgmt/portfind
  6. 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.53.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=on: 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:
cpe 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/2026/
  2. https://www2.sqlite.org/2026/
  3. https://www3.sqlite.org/2026/
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: 253 (showing only 53 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.7.3
17 Oct 2010 09:42:48
Original commit files touched by this commit This port version is marked as vulnerable.
makc search for other commits by this committer
Update to 3.7.3
Update maintainer address

PR:             ports/151501
Submitted by:   Pavel I. Volkov (maintainer)
3.7.2
14 Sep 2010 16:19:23
Original commit files touched by this commit This port version is marked as vulnerable.
nork search for other commits by this committer
Fix build issue which is inclusion of already installed header.

Approved by:    Pavel I Volkov  pol at opk ru (maintainer)
3.7.2
02 Sep 2010 14:43:01
Original commit files touched by this commit This port version is marked as vulnerable.
amdmi3 search for other commits by this committer
- Remove options that do nothing
- Don't bump PORTREVISION as nothing really changed

PR:             150226
Submitted by:   Pavel I Volkov <pol@opk.ru> (maintainer)
Suggested by:   ale@
3.7.2
01 Sep 2010 17:49:50
Original commit files touched by this commit This port version is marked as vulnerable.
amdmi3 search for other commits by this committer
- Update to 3.7.2

PR:             149472, 150119
Submitted by:   Pavel I Volkov <pol@opk.ru> (maintainer)
3.6.23.1_3
23 Aug 2010 07:32:50
Original commit files touched by this commit This port version is marked as vulnerable.
lwhsu search for other commits by this committer
- Turn "Allow loadable extensions" option default on, the port like
  databases/py-sqlite3 needs this to execute successfully.

PR:             ports/149842
Submitted by:   lwhsu
Approved by:    Pavel I Volkov <pol AT opk.ru> (maintainer)
3.6.23.1_2
18 Aug 2010 22:06:58
Original commit files touched by this commit This port version is marked as vulnerable.
lwhsu search for other commits by this committer
- Recover missing dependency (devel/pkg-config)
- Bump PORTREVISION

PR:             ports/146876
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
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: 253 (showing only 53 on this page)

«  1 | 2 | 3