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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details on branch 2023Q1
sqlite3 SQL database engine in a C library
3.40.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.40.1,1Version of this port present on the latest quarterly branch.
Maintainer: pavelivolkov@gmail.com search for ports maintained by this maintainer
Port Added: 2023-01-06 16:27:06
Last Update: 2023-01-06 16:21:25
Commit Hash: 7486923
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
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
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 = 1672831817 SHA256 (sqlite-src-3400100.zip) = 5064126aa50db20c35578b612b56c3129425c0506ed4d1610efa4a0f01bdf8d0 SIZE (sqlite-src-3400100.zip) = 13725560
Packages (timestamps in pop-ups are UTC):
sqlite3
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.45.1,13.45.1,13.34.0,13.45.1,13.45.1,1-3.34.0,1-
FreeBSD:13:quarterly3.45.1,13.45.1,13.42.0,13.45.1,13.45.1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.45.1,13.45.1,13.40.1,13.45.1,13.45.1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.44.0_1,13.45.1,1-3.44.0_1,13.45.1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.45.1,13.45.1,1n/a3.45.0_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
FreeBSD:15:quarterly--n/a-n/a---
 
sqlite3-icu
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.45.1,13.45.1,1-3.45.1,13.45.1,1---
FreeBSD:13:quarterly3.45.1,13.45.1,13.42.0,13.45.1,13.45.1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.45.1,13.45.1,13.40.1,13.45.1,13.45.1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.44.0_1,13.45.1,1-3.44.0_1,13.45.1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.45.1,13.45.1,1n/a3.45.0_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
FreeBSD:15:quarterly--n/a-n/a---
 
sqlite3-tcl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.45.1,13.45.1,1-3.45.1,13.45.1,1---
FreeBSD:13:quarterly3.45.1,13.45.1,13.42.0,13.45.1,13.45.1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:14:latest3.45.1,13.45.1,13.40.1,13.45.1,13.45.1,13.42.0,1-3.42.0,1
FreeBSD:14:quarterly3.44.0_1,13.45.1,1-3.44.0_1,13.45.1,13.44.0_1,13.44.0_1,13.44.0_1,1
FreeBSD:15:latest3.45.1,13.45.1,1n/a3.45.0_1,1n/a3.45.0_1,13.45.0_1,13.45.0_1,1
FreeBSD:15:quarterly--n/a-n/a---
 
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 Build
  1. textproc/mergestat
for Libraries
  1. audio/audacity
  2. graphics/birdfont
  3. graphics/qgis
  4. graphics/qgis-ltr
  5. irc/soju
  6. net-im/dino
  7. security/nss
Expand this list (8 items / 1 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. sysutils/cbsd
  3. Collapse this list.
for Run
  1. sysutils/cbsd
Configuration Options:
===> The following configuration options are available for sqlite3-3.40.1,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/2022/
  2. https://www2.sqlite.org/2022/
  3. https://www3.sqlite.org/2022/
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.40.1,1
06 Jan 2023 16:21:25
commit hash: 74869232a12d8d50d73532f5863bea5456f1f655commit hash: 74869232a12d8d50d73532f5863bea5456f1f655commit hash: 74869232a12d8d50d73532f5863bea5456f1f655commit hash: 74869232a12d8d50d73532f5863bea5456f1f655 files touched by this commit		 Fernando Apesteguía (fernape) search for other commits by this committer
Author: Pavel Volkov		 
databases/sqlite3: Update to 3.40.1

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

 * Fix the --safe command-line option to the CLI such that it correctly
   disallows the use of SQL functions like writefile() that can cause harmful
   side-effects.
 * Fix a potential infinite loop in the memsys5 alternative memory allocator.
   This bug was introduced by a performance optimization in version 3.39.0.

 * Various other obscure fixes.

PR:		268762
Reported by:	pavelivolkov@gmail.com (maintainer)
MFH:		2023Q1 (bugfix release)

(cherry picked from commit 6b1d30b18d6a1538fd06b9ae5a422f9fe407c9eb)

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
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25
glpi*Apr 25

38 vulnerabilities affecting 232 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2024-04-25 11:22:49 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 32219
Broken 85
Deprecated 178
Ignore 217
Forbidden 2
Restricted 2
No CDROM 1
Vulnerable 39
Expired 6
Set to expire 152
Interactive 0
new 24 hours 1
new 48 hours5
new 7 days17
new fortnight27
new month126
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2024 Dan Langille. All rights reserved.