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 2023Q2
sqlite3 SQL database engine in a C library
3.41.2,1 databases on this many watch lists=0 search for ports that depend on this port This port version is marked as vulnerable. Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.41.2,1Version of this port present on the latest quarterly branch.
Maintainer: pavelivolkov@gmail.com search for ports maintained by this maintainer
Port Added: 2023-04-17 12:24:11
Last Update: 2023-04-17 12:17:26
Commit Hash: 0920ce2
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.
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 = 1681539596 SHA256 (sqlite-src-3410200.zip) = 87191fcecb8b707d9a10edb13607686317d7169c080b9bdc5d39d06358376ccc SIZE (sqlite-src-3410200.zip) = 13836230
Packages (timestamps in pop-ups are UTC):
sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.46.1_1,13.46.1_1,13.34.0,13.46.1_1,13.46.1_1,1-3.34.0,1-
FreeBSD:13:quarterly3.46.1_1,13.46.1_1,13.42.0,13.46.1_1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.46.1_1,13.46.1_1,13.40.1,13.46.1_1,13.46.1_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.46.1,13.46.1_1,1-3.46.1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.46.1_1,13.46.1_1,1n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
sqlite3-icu
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.46.1_1,13.46.1_1,1-3.46.1_1,13.46.1_1,1---
FreeBSD:13:quarterly3.46.1_1,13.46.1_1,13.42.0,13.46.1_1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.46.1_1,13.46.1_1,13.40.1,13.46.1_1,13.46.1_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.46.1,13.46.1_1,1-3.46.1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.46.1_1,13.46.1_1,1n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
sqlite3-tcl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.46.1_1,13.46.1_1,1-3.46.1_1,13.46.1_1,1---
FreeBSD:13:quarterly3.46.1_1,13.46.1_1,13.42.0,13.46.1_1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.46.1_1,13.46.1_1,13.40.1,13.46.1_1,13.46.1_1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.46.1,13.46.1_1,1-3.46.1,13.46.1_1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.46.1_1,13.46.1_1,1n/a3.46.1_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
 
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/gonic
  2. emulators/mame
  3. graphics/qgis
  4. graphics/qgis-ltr
  5. net/minidlna
  6. security/nss
  7. sysutils/cbsd
for Run
  1. multimedia/jellyfin
  2. net-p2p/lidarr
  3. net-p2p/prowlarr
  4. sysutils/cbsd
Configuration Options:
===> The following configuration options are available for sqlite3-3.41.2,1: ARMOR=off: Detect misuse of the API DBPAGE=on: Enable DBPAGE Virtual Table DBSTAT=on: Enable DBSTAT Virtual Table DIRECT_READ=off: File is read directly from disk DQS=on: 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 record's 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.
  1. https://www.sqlite.org/2023/
  2. https://www2.sqlite.org/2023/
  3. https://www3.sqlite.org/2023/
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.41.2,1
17 Apr 2023 12:17:26
commit hash: 0920ce211c40e7e09c03bf3f6b5425aef363a6a2commit hash: 0920ce211c40e7e09c03bf3f6b5425aef363a6a2commit hash: 0920ce211c40e7e09c03bf3f6b5425aef363a6a2commit hash: 0920ce211c40e7e09c03bf3f6b5425aef363a6a2 files touched by this commit This port version is marked as vulnerable.		 Fernando Apesteguía (fernape) search for other commits by this committer
Author: Pavel Volkov		 
databases/sqlite3: Update to 3.41.2

ChangeLog: https://www.sqlite.org/releaselog/3_41_2.html

PR:		270857
Reported by:	pavelivolkov@gmail.com (maintainer)
MFH:		2023Q2	(bugfixes)

(cherry picked from commit ee827729f96f7e894d5aa54a89f8cf880e7dd897)

Number of commits found: 1
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
gitlabApr 24
redisApr 24
redis62Apr 24
redis72Apr 24
valkeyApr 24
chromiumApr 23
ungoogled-chromiumApr 23
navidromeApr 22
erlangApr 20
erlang-runtime21Apr 20
erlang-runtime22Apr 20
erlang-runtime23Apr 20
erlang-runtime24Apr 20
erlang-runtime25Apr 20
erlang-runtime26Apr 20

14 vulnerabilities affecting 332 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-04-25 06:28:01 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33283
Broken 124
Deprecated 365
Ignore 241
Forbidden 1
Restricted 2
No CDROM 1
Vulnerable 36
Expired 32
Set to expire 309
Interactive 0
new 24 hours 2
new 48 hours4
new 7 days21
new fortnight39
new month84
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.