| Port details on branch 2024Q2 |
- sqlite3 SQL database engine in a C library
- 3.53.3,1 databases
 =152       3.53.1,1Version of this port present on the latest quarterly branch. - Maintainer: sunpoet@FreeBSD.org
- Port Added: 2004-08-31 19:11:46
- Last Update: 2026-06-30 22:11:47
- Commit Hash: 6a9678c
- People watching this port, also watch:: libiconv, expat, libxml2, png, curl
- License: PD
- WWW:
- https://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.
  ¦  ¦  ¦  ¦ 
- 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: sqlite-icu
- tcl: sqlite-tcl
- distinfo:
- TIMESTAMP = 1782657200
SHA256 (sqlite-src-3530300.zip) = bb80bf8a3bffc19241ce8aba5a4bc74e9c3980013cb0b5f0f0976a99516942af
SIZE (sqlite-src-3530300.zip) = 14537772
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
- databases/py-sqlite-vec
- dns/opendnssec2
- lang/basic256
- misc/github-copilot-language-server
- ports-mgmt/portfind
-
Deleted ports which required this port:
- for Libraries
-
- archivers/rpm4
- archivers/urbackup-client
- archivers/urbackup-server
- astro/foxtrotgps
- astro/opencpn
- astro/viking
- audio/audacity
-
Deleted ports which required this port:
- for Run
-
- comms/limesuite
- games/gnubg
- lang/mono6.8
- misc/github-copilot-language-server
- ports-mgmt/portfind
- ports-mgmt/portsdb
-
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.53.3,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
TCL=off: Enable tcl extension and sqlite_analyzer
THREADS=on: Threading support
TRUSTED_SCHEMA=off: SQL functions & virtual tables are considered unsafe
UNKNOWN_SQL=off: Suppress unknown function errors
UNLOCK_NOTIFY=on: Enable notification on unlocking
UPDATE_LIMIT=off: UPDATE/DELETE is extended with ORDER BY and LIMIT
URI=on: Enable use the URI filename
URI_AUTHORITY=off: Allow convert URL into a UNC
====> Optional extensions
SESSION=on: Enable the session extension
====> Optional functions
OFFSET=off: Enable sqlite_offset() returning records file offset
SOUNDEX=off: Enable the soundex() SQL function
====> Index type for range queries
GEOPOLY=off: Uses the GeoJSON notation (RFC-7946)
RTREE=on: Enable R*Tree module
RTREE_INT=off: Store 32-bit sig int (no float) coordinates
====> Unicode support
ICU=off: Unicode support via ICU
UNICODE61=on: Unicode Version 6.1 tokenizer
====> Where to store temporary file: you have to select exactly one of them
TS0=off: Always use temporary file
TS1=on: File by default, change allowed PRAGMA
TS2=off: Memory by default, change allowed PRAGMA
TS3=off: Always use memory
====> Which query planner to use, stability or ...: you can only select none or one of them
STAT3=off: Collect histogram data from leftmost column
STAT4=off: Collect histogram data from all columns
====> Command line editing library: you can only select none or one of them
LIBEDIT=on: Command line editing via libedit
READLINE=off: Command line editing via libreadline
===> Use 'make config' to modify these settings
- Options name:
- databases_sqlite3
- USES:
- cpe libtool ncurses zip libedit tcl:build
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
As an Amazon Associate I earn from qualifying purchases.