| Port details on branch 2025Q3 |
- sqlite3 SQL database engine in a C library
- 3.50.2_1,1 databases
 =0       3.50.2_1,1Version of this port present on the latest quarterly branch. - Maintainer: pavelivolkov@gmail.com
- Port Added: 2025-08-07 09:27:05
- Last Update: 2025-08-07 09:23:18
- Commit Hash: eaf396c
- 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.
- 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 = 1751267280
SHA256 (sqlite-src-3500200.zip) = 091eeec3ae2ccb91aac21d0e9a4a58944fb2cb112fa67bffc3e08c2eca2d85c8
SIZE (sqlite-src-3500200.zip) = 14392422
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 Libraries
-
- archivers/urbackup-client
- archivers/urbackup-server
- audio/strawberry
- biology/ncbi-blast+
- databases/akonadi
- databases/qt6-base_sqldriver
- graphics/mapnik
Configuration Options:- ===> The following configuration options are available for sqlite3-3.50.2_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: 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=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 ncurses 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.50.2_1,1
07 Aug 2025 09:23:18
 |
Älven (alven)
Author: Matthias Andree |
databases/sqlite3: Add reminder comment about linux ports
I saw several vuxml entries that lacked corresponding
linux-*-sqlite entries, or linux_base-rl9 these days (since June 2025).
Add a reminder comment near the PORTVERSION to remind people to
also add linux-*-sqlite VuXML entries as needed.
(cherry picked from commit 180cc2bb44cd169e9beede3b86d8610086a845cf) |
3.50.2_1,1
07 Aug 2025 09:23:17
|
Älven (alven)
Author: Vladimir Druzenko |
databases/sqlite3: Fix soname, fix build if ICU=on LIBEDIT=off and READLINE=off
--soname=libsqlite3.so.${DISTVERSION} mean that users must
rebuild/reinstall all consumers of the sqlite3 after each patch-level
update.
Use --soname=legacy => soname = libsqlite3.so.0 - ABI and API didn't
changed.
PR: 287983
Approved by: Pavel Volkov <pavelivolkov@gmail.com> (maintainer, implicit - fix
runtime)
Fixes: 8af3fe5ef31b (update to 3.50.2)
Co-authored-by: russian@russerver.org
(cherry picked from commit 25ef3857b80f0bda031c638303ff49369e2501ac) |
3.50.2,1
07 Aug 2025 09:23:16
|
Älven (alven)
Author: Philippe Audeoud |
databases/sqlite3: update to 3.50.2
PR: 287983
(cherry picked from commit 8af3fe5ef31bd6ab4bfddc982ca7c7dc33c8a1ab) |
As an Amazon Associate I earn from qualifying purchases.