notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
sqlite3 SQL database engine in a C library
3.50.4_2,1 databases on this many watch lists=153 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: pavelivolkov@gmail.com search for ports maintained by this maintainer
Port Added: 2004-08-31 19:11:46
Last Update: 2025-11-11 07:17:10
Commit Hash: b5b732d
People watching this port, also watch:: libiconv, expat, libxml2, png, pcre
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 = 1762533612 SHA256 (sqlite-src-3500400.zip) = b7b4dc060f36053902fb65b344bbbed592e64b2291a26ac06fe77eec097850e9 SIZE (sqlite-src-3500400.zip) = 14393367

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.50.4_2,13.50.4_2,13.40.1,13.50.2_1,13.50.4_2,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.50.4_2,13.50.4_2,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.50.4_2,13.50.4_2,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.50.4_2,13.50.4_2,13.40.1,13.50.2_1,13.50.4_2,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.50.4_2,13.50.4_2,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.50.4_2,13.50.4_2,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.50.4_2,13.50.4_2,13.40.1,13.50.2_1,13.50.4_2,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.50.4_2,13.50.4_2,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.50.4_2,13.50.4_2,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. dns/opendnssec2
  4. lang/basic256
  5. misc/github-copilot-language-server
  6. ports-mgmt/portfind
  7. 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 (593 items / 586 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. 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/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/sqlitebrowser
  89. databases/sqlitecpp
  90. databases/sqliteodbc
  91. databases/sqlitestudio
  92. databases/tcl-sqlite3
  93. databases/virtualpg
  94. deskutils/bookworm
  95. deskutils/calibre
  96. deskutils/cherrytree
  97. deskutils/fbreader
  98. deskutils/gnome-contacts
  99. deskutils/gnome-pomodoro
  100. deskutils/growl-for-linux
  101. deskutils/gworkspace-gwmetadata
  102. deskutils/nextcloudclient
  103. deskutils/owncloudclient
  104. deskutils/pinot
  105. deskutils/presage
  106. deskutils/subsurface
  107. deskutils/xfce4-notifyd
  108. devel/RStudio
  109. devel/appstream-glib
  110. devel/build2
  111. devel/cbang
  112. devel/codequery
  113. devel/cvstrac
  114. devel/fnc
  115. devel/ghostie
  116. devel/gittrac
  117. devel/ikos
  118. devel/kyua
  119. devel/laminar
  120. devel/libsoup
  121. devel/libsoup3
  122. devel/llbuild
  123. devel/matreshka
  124. devel/p5-subversion
  125. devel/phasar
  126. devel/poco
  127. devel/py-subversion
  128. devel/root
  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/libreoffice
  140. editors/texmacs
  141. emulators/mame
  142. emulators/mgba
  143. emulators/nemu
  144. filesystems/securefs
  145. finance/ktoblzcheck
  146. ftp/filezilla
  147. ftp/wzdftpd
  148. games/DDNet
  149. games/etlegacy
  150. games/flightgear
  151. games/freeciv
  152. games/freeciv-nox11
  153. games/freeciv21
  154. games/irrlamb
  155. games/ldmud
  156. games/luanti
  157. games/minetestmapper
  158. games/openmw
  159. games/stonesoup
  160. games/supertuxkart
  161. games/warzone2100
  162. games/wyrmgus
  163. games/xmoto
  164. german/tipp10
  165. graphics/birdfont
  166. graphics/colmap
  167. graphics/colord
  168. graphics/colord-gtk
  169. graphics/darktable
  170. graphics/elementary-photos
  171. graphics/gdal
  172. graphics/hugin
  173. graphics/libchamplain
  174. graphics/librasterlite2
  175. graphics/mapcache
  176. graphics/mapnik
  177. graphics/openslide
  178. graphics/ossim
  179. graphics/proj
  180. graphics/qgis
  181. graphics/qgis-ltr
  182. graphics/rawstudio
  183. graphics/shotwell
  184. graphics/tippecanoe
  185. graphics/zathura
  186. irc/anope-devel
  187. irc/ircd-ratbox
  188. irc/soju
  189. japanese/uim-anthy-unicode
  190. java/java-subversion
  191. java/openjfx14
  192. java/sqlitejdbc
  193. lang/munger
  194. lang/racket
  195. lang/seed7
  196. lang/smalltalk
  197. lang/snobol4
  198. lang/swift510
  199. mail/balsa
  200. mail/bogofilter-sqlite
  201. mail/cyrus-imapd30
  202. mail/cyrus-imapd310
  203. mail/cyrus-imapd312
  204. mail/cyrus-imapd32
  205. mail/cyrus-imapd34
  206. mail/cyrus-imapd36
  207. mail/cyrus-imapd38
  208. mail/dovecot-fts-xapian
  209. mail/dspam
  210. mail/evolution
  211. mail/evolution-ews
  212. mail/exim-sqlite
  213. mail/geary
  214. mail/greylite
  215. mail/mlmmj-archive-mid
  216. mail/mlmmj-archiver
  217. mail/mutt
  218. mail/opensmtpd-extras-table-sqlite
  219. mail/opensmtpd-table-sqlite
  220. mail/rspamd
  221. mail/rspamd-devel
  222. math/R-cran-terra
  223. math/cadabra2
  224. math/mdal
  225. math/octave-forge-sqlite
  226. math/openturns
  227. misc/adios2
  228. multimedia/arcan
  229. multimedia/avidemux
  230. multimedia/avidemux-cli
  231. multimedia/avidemux-plugins
  232. multimedia/avidemux-qt5
  233. multimedia/emby-server
  234. multimedia/jellyfin
  235. multimedia/kodi
  236. multimedia/tenacity
  237. net/asterisk20
  238. net/asterisk22
  239. net/csync2
  240. net/freeswitch
  241. net/gerbera
  242. net/grilo-plugins
  243. net/kamailio
  244. net/kget
  245. net/liblinphone
  246. net/liferea
  247. net/linphone
  248. net/mediastreamer
  249. net/megacmd
  250. net/minidlna
  251. net/mosquitto
  252. net/ntopng
  253. net/onedrive
  254. net/rssguard
  255. net/siproxd
  256. net/turnserver
  257. net/vnstat
  258. net-im/abaddon
  259. net-im/dino
  260. net-im/ejabberd
  261. net-im/libaccounts-glib
  262. net-im/nchat
  263. net-im/pidgin
  264. net-im/profanity
  265. net-im/telepathy-gabble
  266. net-im/telepathy-logger
  267. net-mgmt/aircrack-ng
  268. net-mgmt/andwatch
  269. net-mgmt/rackmonkey
  270. net-mgmt/seafile-client
  271. net-mgmt/seafile-gui
  272. net-mgmt/seafile-server
  273. net-mgmt/simplomon
  274. net-p2p/autopulse
  275. net-p2p/bitcoin
  276. net-p2p/bitcoin-daemon
  277. net-p2p/bitcoin-utils
  278. net-p2p/c-lightning
  279. net-p2p/clboss
  280. net-p2p/lidarr
  281. net-p2p/ncdc
  282. net-p2p/prowlarr
  283. net-p2p/radarr
  284. net-p2p/readarr
  285. net-p2p/sonarr
  286. net-p2p/udpt
  287. net-p2p/uhub
  288. news/inn
  289. news/inn-current
  290. ports-mgmt/packagekit
  291. ports-mgmt/pkgcompare
  292. print/simple-fb2-reader
  293. print/sioyek
  294. science/dlib-cpp
  295. science/orthanc
  296. science/orthanc-webviewer
  297. science/paraview
  298. science/py-dlib
  299. science/py-tensorflow
  300. science/ttk
  301. science/vmd
  302. science/zotero
  303. security/arti
  304. security/authenticator
  305. security/axc
  306. security/bitwarden-cli
  307. security/bzrtp
  308. security/cvechecker
  309. security/diswall
  310. security/flawz
  311. security/gnupg
  312. security/gnupg25
  313. security/klee
  314. security/libomemo
  315. security/nss
  316. security/sequoia-chameleon-gnupg
  317. security/sequoia-sq
  318. security/softhsm2
  319. security/sslproxy
  320. security/subversion-gnome-keyring
  321. security/tpm2-pkcs11
  322. security/wazuh-agent
  323. security/wazuh-manager
  324. security/ylva
  325. sysutils/bulk_extractor
  326. sysutils/cbsd
  327. sysutils/createrepo_c
  328. sysutils/dupd
  329. sysutils/elephant
  330. sysutils/fwupd
  331. sysutils/libdnf
  332. sysutils/lnav
  333. sysutils/nix
  334. sysutils/sleuthkit
  335. sysutils/zeitgeist
  336. textproc/link-grammar
  337. textproc/mandoc
  338. textproc/redland
  339. textproc/uim
  340. textproc/uim-gtk2
  341. textproc/uim-gtk3
  342. textproc/uim-m17nlib
  343. textproc/uim-qt5
  344. textproc/uim-qt6
  345. www/aria2
  346. www/bacula-web
  347. www/domoticz
  348. www/domoticz-devel
  349. www/ephemera
  350. www/epiphany
  351. www/fusionpbx
  352. www/kannel
  353. www/kannel-sqlbox
  354. www/luakit
  355. www/luakit-devel
  356. www/midori
  357. www/mod_dav_svn
  358. www/ncgopher
  359. www/newsboat
  360. www/newsraft
  361. www/node22
  362. www/node24
  363. www/node25
  364. www/rssroll
  365. www/webkit2-gtk
  366. www/wt
  367. www/xsp
  368. x11/yelp
  369. x11-fonts/font-manager
  370. x11-toolkits/libshumate
  371. Collapse this list.

Deleted ports which required this port:

Expand this list of 217 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/ktagebuch*
  59. deskutils/mirall*
  60. deskutils/osmo*
  61. devel/clanlib*
  62. devel/clanlib22*
  63. devel/gearmand*
  64. devel/gearmand-devel*
  65. devel/ignition-transport*
  66. devel/ksql*
  67. devel/kyua-cli*
  68. devel/libopensync*
  69. devel/libopensync022*
  70. devel/libsoup-gnome*
  71. devel/monotone*
  72. devel/nemiver*
  73. devel/poco-devel*
  74. devel/poco-ssl*
  75. devel/py-yum-metadata-parser*
  76. devel/seed*
  77. devel/seed3*
  78. devel/subversion16*
  79. devel/subversion17*
  80. devel/subversion18*
  81. devel/subversion19*
  82. dns/bind10*
  83. dns/bundy*
  84. dns/opendnssec13*
  85. editors/codelite*
  86. emulators/mess*
  87. filesystems/sqlfs*
  88. games/freeminer*
  89. games/gcompris*
  90. games/kajongg-kde4*
  91. games/latrine*
  92. games/minetest*
  93. games/mudmagic*
  94. games/pokerth*
  95. games/stonesoup-sdl*
  96. games/voxelands*
  97. games/voxelands-server*
  98. games/xptools*
  99. graphics/darktable38*
  100. graphics/darktable40*
  101. graphics/darktable42*
  102. graphics/f-spot*
  103. graphics/hugin-2016*
  104. graphics/libchamplain08*
  105. graphics/librasterlite*
  106. graphics/libreatlas*
  107. graphics/osgearth*
  108. irc/ircd-ratbox-devel*
  109. irc/ratbox-services*
  110. japanese/uim-anthy*
  111. java/openjfx8-devel*
  112. java/subversion-java*
  113. lang/J*
  114. lang/neko*
  115. lang/phantomjs*
  116. lang/pypy-devel*
  117. lang/pypy3-devel*
  118. lang/swift*
  119. mail/dspam-devel*
  120. mail/libmapi*
  121. math/sage*
  122. misc/katalog*
  123. misc/krecipes*
  124. misc/krecipes-kde4*
  125. multimedia/avidemux-qt4*
  126. multimedia/avidemux26*
  127. multimedia/avidemux26-cli*
  128. multimedia/avidemux26-plugins*
  129. multimedia/avidemux26-qt4*
  130. multimedia/banshee*
  131. multimedia/emby-server-devel*
  132. multimedia/freetuxtv*
  133. multimedia/gmerlin*
  134. multimedia/kodi-devel*
  135. multimedia/mediabrowser*
  136. multimedia/miro*
  137. multimedia/plexhometheater*
  138. multimedia/vdr-plugin-upnp*
  139. multimedia/xbmc*
  140. multimedia/xbmc-pvr*
  141. net/asterisk*
  142. net/asterisk10*
  143. net/asterisk11*
  144. net/asterisk13*
  145. net/asterisk15*
  146. net/asterisk16*
  147. net/asterisk18*
  148. net/coturn*
  149. net/desktop-data-model*
  150. net/glusterfs*
  151. net/kget-kde4*
  152. net/mediatomb*
  153. net/ns3*
  154. net/owncloud-csync*
  155. net/quiterss*
  156. net/s3ql*
  157. net-im/biboumi*
  158. net-im/cawbird*
  159. net-im/corebird*
  160. net-im/kopete-kde4*
  161. net-im/openfetion*
  162. net-im/ring-gnome*
  163. net-im/telepathy-salut*
  164. net-im/venom*
  165. net-mgmt/ccnet*
  166. net-mgmt/ccnet-client*
  167. net-mgmt/ccnet-server*
  168. net-mgmt/seafile*
  169. net-mgmt/sx*
  170. net-p2p/gnunet*
  171. net-p2p/sonarr-devel*
  172. news/inn-CURRENT*
  173. ports-mgmt/chucky*
  174. ports-mgmt/packagekit-qt4*
  175. ports-mgmt/prhistory*
  176. science/coot*
  177. security/certificate-transparency*
  178. security/gnomint*
  179. security/gnupg22*
  180. security/klamav*
  181. security/openvas-manager*
  182. security/openvas8-manager*
  183. security/openvas9-manager*
  184. security/ruby-bitwarden*
  185. security/softhsm*
  186. security/subversion-kwallet*
  187. security/titan*
  188. sysutils/fluxengine*
  189. sysutils/fusefs-sqlfs*
  190. sysutils/istatserver*
  191. sysutils/tracker*
  192. sysutils/tracker-client*
  193. sysutils/tracker-gnome*
  194. sysutils/tracker-libtrackergtk*
  195. sysutils/tracker-miners*
  196. sysutils/tracker3*
  197. textproc/mdocml*
  198. textproc/soothsayer*
  199. textproc/uim-gtk*
  200. textproc/uim-kde4*
  201. textproc/uim-qt4*
  202. www/glewlwyd*
  203. www/libxul*
  204. www/libxul19*
  205. www/mnogosearch*
  206. www/mod_auth_openid*
  207. www/mongrel2*
  208. www/newsbeuter*
  209. www/qt5-webkit*
  210. www/seamonkey*
  211. www/webkit-gtk2*
  212. www/webkit-gtk3*
  213. www/webkit-qt5*
  214. www/webkit2-gtk3*
  215. www/webkit2-gtk4*
  216. www/wt3*
  217. x11-toolkits/libshumate-shortwave*
  218. 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.50.4_2,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:
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: 250 (showing only 50 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.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: 250 (showing only 50 on this page)

«  1 | 2 | 3