FreshPorts -- databases/sqlite3: SQL database engine in a C library

Port details

sqlite3 SQL database engine in a C library

3.45.1,1 databases =156 3.45.1,1Version of this port present on the latest quarterly branch.

Maintainer: pavelivolkov@gmail.com

Port Added: 2004-08-31 19:11:46

Last Update: 2024-03-12 04:21:55

Commit Hash: be035ff

People watching this port, also watch:: expat, libiconv, libxml2, pcre, curl

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.

¦ ¦ ¦ ¦

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

Conflicts Matches:

There are no Conflicts Matches for this port. This is usually an error.

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 = 1710050109 SHA256 (sqlite-src-3450100.zip) = 7f7b14a68edbcd4a57df3a8c4dbd56d2d3546a6e7cdd50de40ceb03af33d34ba SIZE (sqlite-src-3450100.zip) = 14152147

Packages (timestamps in pop-ups are UTC):

sqlite3
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	3.45.1,1	3.45.1,1	3.34.0,1	3.45.1,1	3.45.1,1	-	3.34.0,1	-
FreeBSD:13:quarterly	3.45.1,1	3.45.1,1	3.42.0,1	3.45.1,1	3.45.1,1	3.44.0_1,1	3.44.0_1,1	3.44.0_1,1
FreeBSD:14:latest	3.45.1,1	3.45.1,1	3.40.1,1	3.45.1,1	3.45.1,1	3.42.0,1	-	3.42.0,1
FreeBSD:14:quarterly	3.44.0_1,1	3.45.1,1	-	3.44.0_1,1	3.45.1,1	3.44.0_1,1	3.44.0_1,1	3.44.0_1,1
FreeBSD:15:latest	3.45.1,1	3.45.1,1	n/a	3.45.0_1,1	n/a	3.45.0_1,1	3.45.0_1,1	3.45.0_1,1
FreeBSD:15:quarterly	-	-	n/a	-	n/a	-	-	-

sqlite3-icu
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	3.45.1,1	3.45.1,1	-	3.45.1,1	3.45.1,1	-	-	-
FreeBSD:13:quarterly	3.45.1,1	3.45.1,1	3.42.0,1	3.45.1,1	3.45.1,1	3.44.0_1,1	3.44.0_1,1	3.44.0_1,1
FreeBSD:14:latest	3.45.1,1	3.45.1,1	3.40.1,1	3.45.1,1	3.45.1,1	3.42.0,1	-	3.42.0,1
FreeBSD:14:quarterly	3.44.0_1,1	3.45.1,1	-	3.44.0_1,1	3.45.1,1	3.44.0_1,1	3.44.0_1,1	3.44.0_1,1
FreeBSD:15:latest	3.45.1,1	3.45.1,1	n/a	3.45.0_1,1	n/a	3.45.0_1,1	3.45.0_1,1	3.45.0_1,1
FreeBSD:15:quarterly	-	-	n/a	-	n/a	-	-	-

sqlite3-tcl
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	3.45.1,1	3.45.1,1	-	3.45.1,1	3.45.1,1	-	-	-
FreeBSD:13:quarterly	3.45.1,1	3.45.1,1	3.42.0,1	3.45.1,1	3.45.1,1	3.44.0_1,1	3.44.0_1,1	3.44.0_1,1
FreeBSD:14:latest	3.45.1,1	3.45.1,1	3.40.1,1	3.45.1,1	3.45.1,1	3.42.0,1	-	3.42.0,1
FreeBSD:14:quarterly	3.44.0_1,1	3.45.1,1	-	3.44.0_1,1	3.45.1,1	3.44.0_1,1	3.44.0_1,1	3.44.0_1,1
FreeBSD:15:latest	3.45.1,1	3.45.1,1	n/a	3.45.0_1,1	n/a	3.45.0_1,1	3.45.0_1,1	3.45.0_1,1
FreeBSD:15:quarterly	-	-	n/a	-	n/a	-	-	-

Dependencies

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:

tclsh8.6 : lang/tcl86

Library dependencies:

libedit.so.0 : devel/libedit

This port is required by:

for Build

Deleted ports which required this port:

Expand this list of 16 deleted ports

for Libraries

Expand this list (553 items / 546 hidden - sorry, this count includes any deleted ports)

Deleted ports which required this port:

Expand this list of 186 deleted ports

for Run

Deleted ports which required this port:

Expand this list of 2 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.45.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.

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: 239 (showing only 39 on this page)

« 1 | 2 | 3

Commit	Credits	Log message
Commit History - (may be incomplete: for full details, see links to repositories near top of page)
3.6.14.2 09 Jun 2009 02:40:51	mnag	- Update to 3.6.14.2
3.6.13 25 Apr 2009 02:44:12	mnag	- Update to 3.6.13. - Fix upgrade with tcl 8.4.
3.6.11 23 Mar 2009 05:31:15	mnag	- 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	mnag	- Update to 3.6.10 Requested by: many
3.6.4 29 Oct 2008 16:40:09	mnag	- 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	rafan	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 )
3.5.6 09 Apr 2008 13:42:26	pav	- Move from versioned tcl/tk CATEGORIES to simple tcl and tk categories With hat: portmgr
3.5.6 05 Apr 2008 14:49:38	mnag	- 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	mnag	- Fix build with FTS2 PR: 115271 Pointy hat to: mnag Reported by: many
3.4.1 01 Aug 2007 14:22:13	mnag	- 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	mnag	- Update to 3.3.17
3.3.16 21 Apr 2007 00:07:41	mnag	- Update to 3.3.16 PR: 111925 Submitted by: Michael Scheidell <scheidell___secnap.net>
3.3.15 10 Apr 2007 21:40:24	mnag	- 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	mnag	- Update to 3.3.14
3.3.13 25 Mar 2007 20:02:04	mnag	* 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	mnag	- 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	mnag	- 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	mnag	- Update to 3.3.8
3.3.7 13 Aug 2006 22:52:34	mnag	- Update to 3.3.7 - portlint(1)
3.3.6 11 Jun 2006 21:43:25	mnag	- Update to 3.3.6
3.3.5 16 Apr 2006 03:29:40	mnag	- 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	ade	Conversion to a single libtool environment. Approved by: portmgr (kris)
3.3.4 13 Feb 2006 16:53:12	mnag	- 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	mnag	- Update to 3.3.3 [1] - Reorganize Makefile Submitted by: cokane [1]
3.2.8 06 Jan 2006 21:16:54	mnag	Update to 3.2.8 Reorganize Makefile Notified by: edwin Version Check
3.2.7 15 Nov 2005 06:52:12	ade	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	mnag	Add SHA256
3.2.7 26 Sep 2005 13:39:55	mnag	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	green	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	pav	- 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	pav	- 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	obrien	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	obrien	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	nork	Add dependency on devel/pkgconfig. Pointy hat to: pointyhat via kris
3.0.8_1 23 Dec 2004 10:20:36	nork	Fix pkg-plist. This problem is heinousness, so I bump PORTREVISION. Pointy hat to: myself
3.0.8 23 Dec 2004 08:25:47	nork	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	edwin	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	edwin	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	green	Add SQLite 3 (in beta form).

Number of commits found: 239 (showing only 39 on this page)

« 1 | 2 | 3

Login
User Login Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts? About the authors Issues FAQ How big is it? Security Policy Privacy Blog Contact

Search
Enter Keywords: more...

Latest Vulnerabilities

gitlab	Apr 24
py-matrix-synapse	Apr 24
ruby31	Apr 23
ruby32	Apr 23
ruby33	Apr 23
glpi	Apr 22
glpi	Apr 22
glpi	Apr 22
sdl2_sound	Apr 22
chromium	Apr 21
ungoogled-chromium	Apr 21
clamav	Apr 19
jenkins	Apr 19
jenkins-lts	Apr 19
electron27	Apr 18

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

^* - modified, not new

All vulnerabilities

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

Ports
Home Categories Deleted ports Sanity Test Failures Newsfeeds

Statistics

Graphs
NEW Graphs (Javascript)

Calculated hourly:

Port count	32219
Broken	85
Deprecated	178
Ignore	217
Forbidden	2
Restricted	2
No CDROM	1
Vulnerable	41
Expired	6
Set to expire	152
Interactive	0
new 24 hours	5
new 48 hours	6
new 7 days	20
new fortnight	27
new month	126

Get notified when packages are built