| Port details on branch 2016Q4 |
- sqlite3 SQL database engine in a C library
- 3.14.1_1 databases
 =1       3.50.2_1,1Version of this port present on the latest quarterly branch. - Maintainer: pavelivolkov@gmail.com
- Port Added: 2016-12-26 10:04:39
- Last Update: 2016-12-26 10:04:31
- Commit Hash: 43dff64
- 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 - USE_RC_SUBR (Service Scripts)
- no SUBR information found for this port
- Dependency lines:
-
- sqlite3>0:databases/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
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1471674483
SHA256 (sqlite-autoconf-3140100.tar.gz) = bc7182476900017becb81565ecea7775d46ab747a97281aa610f4f45881c47a6
SIZE (sqlite-autoconf-3140100.tar.gz) = 2473610
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Library dependencies:
-
- libreadline.so.6 : devel/readline
- This port is required by:
- for Build
-
- devel/subversion-static
- dns/opendnssec2
- mail/thunderbird
- security/nss
- www/firefox
- www/firefox-esr
- www/libxul
- for Libraries
-
- audio/clementine-player
- databases/php56-pdo_sqlite
- databases/php56-sqlite3
- databases/php70-pdo_sqlite
- databases/php70-sqlite3
- devel/p5-subversion
- devel/py-subversion
- for Run
-
- net-p2p/sonarr
Configuration Options:- ===> The following configuration options are available for sqlite3-3.14.1_1:
ARMOR=off: Detect misuse of the API
DBSTAT=on: Enable DBSTAT Virtual Table
DIRECT_READ=off: File is read directly from disk
EXTENSION=on: Allow loadable extensions
FTS3_TOKEN=on: Enable two-args version fts3_tokenizer
FTS4=on: Enable FTS3/4 (Full Text Search) module
FTS5=off: Enable version 5 full-text search engine
JSON1=off: Enable the JSON1 extension
LIKENOTBLOB=off: LIKE does not match blobs
MEMMAN=off: Allows it to release unused memory
METADATA=on: Enable column metadata
RBU=off: Enable the Resumable Bulk Update
SECURE_DELETE=on: Overwrite deleted information with zeros
SESSION=off: Enable the Session Extension
SOUNDEX=off: Enables the soundex() SQL function
STMT=off: Prepared Statement Scan Status
STSHELL=on: Statically link libsqlite3 into shell
THREADS=on: Threading support
UNKNOWN_SQL=off: suppress unknown function errors
UNLOCK_NOTIFY=on: Enable notification on unlocking
UPD_DEL_LIMIT=off: ORDER BY and LIMIT on UPDATE and DELETE
URI=on: Enable use the URI filename
URI_AUTHORITY=off: Allow convert URL into a UNC
====> Unicode support
ICU=off: Unicode support via ICU
UNICODE61=on: Unicode Version 6.1 tokenizer
====> Index type for range queries
RTREE=on: Enable R*Tree module
RTREE_INT=off: Store 32-bit sig int (no float) coordinates
====> Which command line editing library to use:
READLINES=on: the libreadline from system
READLINEP=off: the GNU libreadline from ports
EDITLINE=off: the BSD libedit from ports
====> 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
===> Use 'make config' to modify these settings
- Options name:
- databases_sqlite3
- USES:
- libtool ncurses pathfix readline
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
Number of commits found: 2
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
3.14.1_1
26 Dec 2016 10:04:31
 |
Raphael Kubo da Costa (rakuco) |
MFH: r429442
Improve the way CFLAGS and CPPFLAGS are set.
":?" is not supported by fmake from FreeBSD 9, so replace it with an explicit
version check. The end result was still the desired one (-DHAVE_STRCHRNUL=1 was
not passed on FreeBSD 9).
While here, also improve the version check by including DragonFly (which
supports strchrnul(3) according to its online man page) and restricting the
FreeBSD version check to the revision range after strchrnul(3) was added to
base.
Also stop passing -Os when building in debug mode, and set UNICODE61_CPPFLAGS
to pet portlint.
PR: 214608
Submitted by: Pavel Volkov <pavelivolkov@gmail.com> (maintainer)
Approved by: ports-secteam (junovitch) |
3.14.1_1
26 Dec 2016 10:04:31
 |
rakuco |
MFH: r429442
Improve the way CFLAGS and CPPFLAGS are set.
":?" is not supported by fmake from FreeBSD 9, so replace it with an explicit
version check. The end result was still the desired one (-DHAVE_STRCHRNUL=1 was
not passed on FreeBSD 9).
While here, also improve the version check by including DragonFly (which
supports strchrnul(3) according to its online man page) and restricting the
FreeBSD version check to the revision range after strchrnul(3) was added to
base.
Also stop passing -Os when building in debug mode, and set UNICODE61_CPPFLAGS
to pet portlint.
PR: 214608
Submitted by: Pavel Volkov <pavelivolkov@gmail.com> (maintainer)
Approved by: ports-secteam (junovitch) |
Number of commits found: 2
|
As an Amazon Associate I earn from qualifying purchases.