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.46.1_1,1 databases on this many watch lists=157 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.46.1_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-02-14 23:12:32
Commit Hash: ff33dd4
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.
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 = 1724580150 SHA256 (sqlite-src-3460100.zip) = def3fc292eb9ecc444f6c1950e5c79d8462ed5e7b3d605fd6152d145e1d5abb4 SIZE (sqlite-src-3460100.zip) = 14276926

Packages (timestamps in pop-ups are UTC):
sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.46.1_1,13.46.1_1,13.34.0,13.46.1_1,13.46.1_1,1-3.34.0,1-
FreeBSD:13:quarterly3.46.1_1,13.46.1_1,13.42.0,13.46.1_1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.46.1_1,13.46.1_1,13.40.1,13.46.1_1,13.46.1_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.46.1,13.46.1_1,1-3.46.1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.46.1_1,13.46.1_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.46.1_1,13.46.1_1,1-3.46.1_1,13.46.1_1,1---
FreeBSD:13:quarterly3.46.1_1,13.46.1_1,13.42.0,13.46.1_1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.46.1_1,13.46.1_1,13.40.1,13.46.1_1,13.46.1_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.46.1,13.46.1_1,1-3.46.1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.46.1_1,13.46.1_1,1n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
sqlite3-tcl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.46.1_1,13.46.1_1,1-3.46.1_1,13.46.1_1,1---
FreeBSD:13:quarterly3.46.1_1,13.46.1_1,13.42.0,13.46.1_1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.46.1_1,13.46.1_1,13.40.1,13.46.1_1,13.46.1_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.46.1,13.46.1_1,1-3.46.1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.46.1_1,13.46.1_1,1n/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 (568 items / 561 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/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/libzdb
  51. databases/lua-lsqlite3
  52. databases/luasql-sqlite3
  53. databases/ocaml-sqlite3
  54. databases/ods2sql
  55. databases/pgloader3
  56. databases/php81-pdo_sqlite
  57. databases/php81-sqlite3
  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/proftpd-mod_sql_sqlite
  65. databases/py-apsw
  66. databases/py-databases
  67. databases/py-ormar
  68. databases/py-peewee
  69. databases/py-sqlite3
  70. databases/qt5-sqldrivers-sqlite3
  71. databases/qt6-base_sqldriver
  72. databases/rubygem-do_sqlite3
  73. databases/rubygem-sqlite3
  74. databases/rubygem-sqlite3-ruby
  75. databases/rubygem-sqlite31
  76. databases/soci
  77. databases/spatialite
  78. databases/spatialite-tools
  79. databases/spatialite_gui
  80. databases/sqlcached
  81. databases/sqlclient
  82. databases/sqlite-ext-miscfuncs
  83. databases/sqlite-ext-pcre
  84. databases/sqlite-ext-regexp
  85. databases/sqlite-ext-spellfix
  86. databases/sqlitebrowser
  87. databases/sqlitecpp
  88. databases/sqliteodbc
  89. databases/sqlitestudio
  90. databases/tcl-sqlite3
  91. databases/virtualpg
  92. deskutils/bookworm
  93. deskutils/calibre
  94. deskutils/cherrytree
  95. deskutils/fbreader
  96. deskutils/gnome-contacts
  97. deskutils/gnome-pomodoro
  98. deskutils/growl-for-linux
  99. deskutils/gworkspace-gwmetadata
  100. deskutils/nextcloudclient
  101. deskutils/owncloudclient
  102. deskutils/pinot
  103. deskutils/presage
  104. deskutils/subsurface
  105. deskutils/xfce4-notifyd
  106. devel/RStudio
  107. devel/appstream-glib
  108. devel/build2
  109. devel/cbang
  110. devel/codequery
  111. devel/cvstrac
  112. devel/ghostie
  113. devel/gittrac
  114. devel/ikos
  115. devel/ksql
  116. devel/kyua
  117. devel/laminar
  118. devel/libsoup
  119. devel/libsoup3
  120. devel/llbuild
  121. devel/matreshka
  122. devel/p5-subversion
  123. devel/phasar
  124. devel/poco
  125. devel/py-subversion
  126. devel/ruby-subversion
  127. devel/subversion
  128. devel/subversion-lts
  129. devel/svntrac
  130. devel/tinysparql
  131. devel/zeal
  132. dns/opendnssec2
  133. dns/powerdns
  134. editors/emacs
  135. editors/emacs-devel
  136. editors/texmacs
  137. emulators/mame
  138. emulators/mgba
  139. emulators/nemu
  140. filesystems/securefs
  141. finance/ktoblzcheck
  142. ftp/filezilla
  143. ftp/wzdftpd
  144. games/DDNet
  145. games/etlegacy
  146. games/flightgear
  147. games/freeciv
  148. games/freeciv-nox11
  149. games/freeciv21
  150. games/freeminer
  151. games/irrlamb
  152. games/ldmud
  153. games/lightsoff
  154. games/luanti
  155. games/minetestmapper
  156. games/openmw
  157. games/pokerth
  158. games/stonesoup
  159. games/supertuxkart
  160. games/warzone2100
  161. games/wyrmgus
  162. games/xmoto
  163. german/tipp10
  164. graphics/birdfont
  165. graphics/colmap
  166. graphics/colord
  167. graphics/colord-gtk
  168. graphics/darktable
  169. graphics/elementary-photos
  170. graphics/gdal
  171. graphics/hugin
  172. graphics/libchamplain
  173. graphics/librasterlite2
  174. graphics/mapcache
  175. graphics/mapnik
  176. graphics/openslide
  177. graphics/osgearth
  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/ircd-ratbox
  187. irc/soju
  188. japanese/uim-anthy
  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. mail/bogofilter-sqlite
  199. mail/cyrus-imapd30
  200. mail/cyrus-imapd310
  201. mail/cyrus-imapd32
  202. mail/cyrus-imapd34
  203. mail/cyrus-imapd36
  204. mail/cyrus-imapd38
  205. mail/dovecot-fts-xapian
  206. mail/dspam
  207. mail/evolution
  208. mail/evolution-ews
  209. mail/exim-sqlite
  210. mail/geary
  211. mail/greylite
  212. mail/mlmmj-archive-mid
  213. mail/mlmmj-archiver
  214. mail/mutt
  215. mail/opensmtpd-extras-table-sqlite
  216. mail/opensmtpd-table-sqlite
  217. mail/rspamd
  218. mail/rspamd-devel
  219. math/R-cran-terra
  220. math/cadabra2
  221. math/mdal
  222. math/octave-forge-sqlite
  223. math/openturns
  224. misc/adios2
  225. multimedia/arcan
  226. multimedia/avidemux
  227. multimedia/avidemux-cli
  228. multimedia/avidemux-plugins
  229. multimedia/avidemux-qt5
  230. multimedia/emby-server
  231. multimedia/jellyfin
  232. multimedia/kodi
  233. net/asterisk18
  234. net/asterisk20
  235. net/asterisk22
  236. net/csync2
  237. net/freeswitch
  238. net/gerbera
  239. net/glusterfs
  240. net/grilo-plugins
  241. net/kamailio
  242. net/kget
  243. net/liblinphone
  244. net/liferea
  245. net/mediastreamer
  246. net/megacmd
  247. net/minidlna
  248. net/ntopng
  249. net/onedrive
  250. net/rssguard
  251. net/turnserver
  252. net/vnstat
  253. net-im/biboumi
  254. net-im/dino
  255. net-im/ejabberd
  256. net-im/folks
  257. net-im/libaccounts-glib
  258. net-im/pidgin
  259. net-im/profanity
  260. net-im/telepathy-gabble
  261. net-im/telepathy-logger
  262. net-mgmt/aircrack-ng
  263. net-mgmt/andwatch
  264. net-mgmt/rackmonkey
  265. net-mgmt/seafile-client
  266. net-mgmt/seafile-gui
  267. net-mgmt/seafile-server
  268. net-p2p/bitcoin
  269. net-p2p/bitcoin-daemon
  270. net-p2p/c-lightning
  271. net-p2p/clboss
  272. net-p2p/lidarr
  273. net-p2p/ncdc
  274. net-p2p/prowlarr
  275. net-p2p/radarr
  276. net-p2p/readarr
  277. net-p2p/sonarr
  278. net-p2p/udpt
  279. net-p2p/uhub
  280. news/inn
  281. news/inn-current
  282. ports-mgmt/packagekit
  283. ports-mgmt/pkgcompare
  284. print/simple-fb2-reader
  285. print/sioyek
  286. science/dlib-cpp
  287. science/orthanc
  288. science/orthanc-webviewer
  289. science/paraview
  290. science/py-dlib
  291. science/py-tensorflow
  292. science/ttk
  293. science/vmd
  294. science/zotero
  295. security/arti
  296. security/authenticator
  297. security/axc
  298. security/bzrtp
  299. security/cvechecker
  300. security/diswall
  301. security/flawz
  302. security/gnupg
  303. security/klee
  304. security/libomemo
  305. security/nss
  306. security/sequoia-sq
  307. security/softhsm2
  308. security/sslproxy
  309. security/subversion-gnome-keyring
  310. security/tpm2-pkcs11
  311. security/wazuh-agent
  312. security/wazuh-manager
  313. security/ylva
  314. sysutils/bulk_extractor
  315. sysutils/cbsd
  316. sysutils/createrepo_c
  317. sysutils/dupd
  318. sysutils/libdnf
  319. sysutils/lnav
  320. sysutils/nix
  321. sysutils/sleuthkit
  322. sysutils/zeitgeist
  323. textproc/link-grammar
  324. textproc/mandoc
  325. textproc/redland
  326. textproc/soothsayer
  327. textproc/uim
  328. textproc/uim-gtk2
  329. textproc/uim-gtk3
  330. textproc/uim-m17nlib
  331. textproc/uim-qt5
  332. textproc/uim-qt6
  333. www/aria2
  334. www/bacula-web
  335. www/domoticz
  336. www/domoticz-devel
  337. www/ephemera
  338. www/epiphany
  339. www/fusionpbx
  340. www/kannel
  341. www/kannel-sqlbox
  342. www/luakit
  343. www/luakit-devel
  344. www/midori
  345. www/mod_dav_svn
  346. www/ncgopher
  347. www/newsboat
  348. www/newsraft
  349. www/rssroll
  350. www/trafficserver
  351. www/webkit2-gtk
  352. www/wt
  353. www/xsp
  354. x11/yelp
  355. x11-fonts/font-manager
  356. x11-toolkits/libshumate
  357. Collapse this list.

Deleted ports which required this port:

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

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.46.1_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: Allow 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 pathfix 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/2024/
  2. https://www2.sqlite.org/2024/
  3. https://www3.sqlite.org/2024/
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: 243 (showing only 43 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
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: 243 (showing only 43 on this page)

«  1 | 2 | 3