Port details |
- sqlite3 SQL database engine in a C library
- 3.46.1,1 databases =159 3.46.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-08-26 16:28:31
- Commit Hash: 8d38e8f
- 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
- 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):
- 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
-
- databases/lua-lsqlite3
- databases/py-apsw
- dns/opendnssec2
- lang/basic256
- ports-mgmt/portfind
- sysutils/fastfetch
-
Deleted ports which required this port:
- for Libraries
-
- archivers/rpm4
- archivers/urbackup-client
- archivers/urbackup-server
- astro/foxtrotgps
- astro/merkaartor
- astro/opencpn
- astro/viking
-
Deleted ports which required this port:
- for Run
-
- comms/limesuite
- games/gnubg
- lang/mono6.8
- ports-mgmt/portfind
- ports-mgmt/portsdb
- sysutils/cbsd
-
Deleted ports which required this port:
- * - 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:
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:
|
Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
3.6.19 02 Nov 2009 10:11:49 |
ale |
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 |
mezz |
-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 |
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). |