| Port details on branch 2022Q3 |
- sqlite3 SQL database engine in a C library
- 3.39.2,1 databases
 =0       3.50.2_1,1Version of this port present on the latest quarterly branch. - Maintainer: pavelivolkov@gmail.com
- Port Added: 2022-08-30 23:18:10
- Last Update: 2022-08-30 23:16:13
- Commit Hash: e99a813
- 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.
WWW: https://www.sqlite.org/
  ¦  ¦  ¦  ¦ 
- 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 = 1661900706
SHA256 (sqlite-src-3390200.zip) = e933d77000f45f3fbc8605f0050586a3013505a8de9b44032bd00ed72f1586f0
SIZE (sqlite-src-3390200.zip) = 13403722
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
-
- databases/php81-pdo_sqlite
- databases/php81-sqlite3
- graphics/qgis
- graphics/qgis-ltr
- security/arti
- security/nss
- sysutils/cbsd
- for Run
-
- sysutils/cbsd
Configuration Options:- ===> The following configuration options are available for sqlite3-3.39.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:
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
3.39.2,1
30 Aug 2022 23:16:13
 |
Cy Schubert (cy) |
databases/sqlite3: Update to 3.39.2
Security: CVE-2022-35737
ChangeLog: https://www.sqlite.org/releaselog/3_39_2.html
Reported by: pavelivolkov@gmail.com (maintainer) via delpij
(cherry picked from commit 87109576c6173946f287f7649bf3bce7cf9555f4) |
3.39.0,1
30 Aug 2022 23:15:42
|
Cy Schubert (cy)
Author: Pavel Volkov |
databases/sqlite3: Update to 3.39
ChangeLog: https://www.sqlite.org/releaselog/3_39_0.html
* Add (long overdue) support for RIGHT and FULL OUTER JOIN.
* Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM
that are equivalent to IS and IS NOT, respective, for compatibility with
PostgreSQL and SQL standards.
* Add a new return code (value "3") from the sqlite3_vtab_distinct() interface
that indicates a query that has both DISTINCT and ORDER BY clauses.
* Added the sqlite3_db_name() interface.
* The unix os interface resolves all symbolic links in database filenames to
create a canonical name for the database before the file is opened.
* Defer materializing views until the materialization is actually needed, thus
avoiding unnecessary work if the materialization turns out to never be used.
* The HAVING clause of a SELECT statement is now allowed on any aggregate
query, even queries that do not have a GROUP BY clause.
* Many microoptimizations collectively reduce CPU cycles by about 2.3%.
PR: 264974
Reported by: pavelivolkov@gmail.com (maintainer)
(cherry picked from commit 5bf2947fce86388fd612492f980540c07d41f0b2) |
As an Amazon Associate I earn from qualifying purchases.