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 on branch 2025Q4
sqlite3 SQL database engine in a C library
3.50.4_1,1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.50.4_1,1Version of this port present on the latest quarterly branch.
Maintainer: pavelivolkov@gmail.com search for ports maintained by this maintainer
Port Added: 2025-11-07 17:16:40
Last Update: 2025-11-07 17:14:33
Commit Hash: 8cdfe27
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 - no subversion history for this port

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 = 1762533612 SHA256 (sqlite-src-3500400.zip) = b7b4dc060f36053902fb65b344bbbed592e64b2291a26ac06fe77eec097850e9 SIZE (sqlite-src-3500400.zip) = 14393367

No package information for this port in our database
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
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 Libraries
  1. audio/strawberry
  2. databases/qt5-sqldrivers-sqlite3
  3. devel/zeal
  4. graphics/qgis
  5. graphics/qgis-ltr
  6. net/kamailio
  7. security/nss

Configuration Options:
===> The following configuration options are available for sqlite3-3.50.4_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 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/2025/
  2. https://www2.sqlite.org/2025/
  3. https://www3.sqlite.org/2025/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
3.50.4_1,1
07 Nov 2025 17:14:33
commit hash: 8cdfe27078747b95e8e260ce1f9e43217464b893commit hash: 8cdfe27078747b95e8e260ce1f9e43217464b893commit hash: 8cdfe27078747b95e8e260ce1f9e43217464b893commit hash: 8cdfe27078747b95e8e260ce1f9e43217464b893 files touched by this commit
Matthias Andree (mandree) search for other commits by this committer
databases/sqlite3: security update to 3.50.4

Changes per <https://sqlite.org/changes.html>:

2025-07-30 (3.50.4)

  1 Fix two long-standings cases of the use of uninitialized variables
    in obscure circumstances.

2025-07-17 (3.50.3)

  1 Fix a possible memory error that can occur if a query is made
    against against FTS5 index that has been deliberately corrupted in a
    very specific way.
  2 Fix the parser so that it ignored SQL comments in all places of a
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 1