Attachment #197729 for bug #231770

View | Details | Raw Unified | Return to bug 231770 | Differences between
Collapse All | Expand All





PORTNAME=	sqlite3
DISTVERSION=	3.25.1
PORTREVISION=	1
CATEGORIES=	databases
MASTER_SITES=	https://www.sqlite.org/2018/ http://www2.sqlite.org/2018/ http://www3.sqlite.org/2018/
DISTNAME=	sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00


MAINTAINER=	pavelivolkov@gmail.com
COMMENT=	SQL database engine in a C library
.if ${FLAVOR:U} == icu
COMMENT+=	(icu flavor)
.elif ${FLAVOR:U} == mini
COMMENT+=	(Compacted, mini flavor)
.endif

LICENSE=	PD

FLAVORS=	default icu mini
FLAVOR?=	${FLAVORS:[1]}
default_CONFLICTS_INSTALL=	sqlite3-icu sqlite3-mini
icu_CONFLICTS_INSTALL=	sqlite3 sqlite3-mini
icu_BUILD_DEPENDS=      ${LOCALBASE}/bin/icu-config:devel/icu
icu_LIB_DEPENDS=        libicudata.so:devel/icu
icu_PKGNAMESUFFIX=	-icu
mini_CONFLICTS_INSTALL=	sqlite3 sqlite3-icu
mini_PKGNAMESUFFIX=	-mini

USES=		libtool ncurses pathfix
USE_LDCONFIG=	yes

# Platform Configuration
CPPFLAGS+=	-DHAVE_ISNAN=1 -DHAVE_MALLOC_USABLE_SIZE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_USLEEP=1 -DHAVE_STRCHRNUL=1
# The default numeric file permissions for newly created database files under unix.
# If not specified, the default is 0644 which means that the files is globally
# readable but only writable by the creator.
.ifdef DEFAULT_FILE_PERMISSIONS
CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
.endif
.if ${FLAVOR:U} == icu
CPPFLAGS+=   `${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1
LIBS+=       `${LOCALBASE}/bin/icu-config --ldflags`
.endif
GNU_CONFIGURE=	yes
USE_LDCONFIG=	yes
INSTALL_TARGET=	install-strip

MAKE_JOBS_UNSAFE=	yes
PLIST_FILES=    bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
                lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \
                lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \
                man/man1/sqlite3.1.gz

# Compilation Options For SQLite https://www.sqlite.org/compile.html
OPTIONS_DEFINE=	ARMOR DBPAGE DBSTAT DIRECT_READ EXTENSION \
		FTS3_TOKEN FTS4 FTS5 LIKENOTBLOB MEMMAN METADATA \
		NULL_TRIM RBU SECURE_DELETE SORT_REF STMT STSHELL \
		THREADS UNKNOWN_SQL UNLOCK_NOTIFY URI URI_AUTHORITY 
OPTIONS_DEFAULT=	DBSTAT EXTENSION FTS3_TOKEN FTS4 FTS5 METADATA \
			READLINES RTREE SECURE_DELETE STSHELL THREADS \
			TS1 UNICODE61 UNLOCK_NOTIFY URI
OPTIONS_GROUP= OPT_EXT OPT_FUNC RL RTREEG UNICODE
OPTIONS_GROUP_OPT_EXT= JSON1 SESSION
OPTIONS_GROUP_OPT_FUNC= OFFSET SER1 SOUNDEX
OPTIONS_GROUP_RL= READLINES READLINEP EDITLINE
OPTIONS_GROUP_RTREEG= RTREE RTREE_INT GEOPOLY
OPTIONS_GROUP_UNICODE= ICU UNICODE61
OPTIONS_RADIO= STAT
OPTIONS_RADIO_STAT= STAT3 STAT4
OPTIONS_SINGLE= RAMT
OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3
# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
# RTREE used by graphics/mapnik, databases/spatialite
# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
# FTS5 used by sysutils/tracker

.if ${FLAVOR:U} == icu
OPTIONS_EXCLUDE=        ICU
.endif

.if ${FLAVOR:U} == mini
OPTIONS_EXCLUDE=        ARMOR DBPAGE DBSTAT DIRECT_READ EDITLINE EXTENSION \
                        FTS3_TOKEN FTS4 FTS5 GEOPOLY ICU JSON1 LIKENOTBLOB \
                        MEMMAN METADATA NULL_TRIM OFFSET RBU READLINES \
                        READLINEP RTREE RTREE_INT SECURE_DELETE SER1 SESSION \
                        SORT_REF SOUNDEX STAT3 STAT4 STMT STSHELL UNICODE61 \
                        UNKNOWN_SQL UNLOCK_NOTIFY URI URI_AUTHORITY
.endif
SECURE_DELETE_DESC=	Overwrite deleted information with zeros
UNLOCK_NOTIFY_DESC=	Enable notification on unlocking
EXTENSION_DESC=		Allow loadable extensions
STSHELL_DESC=		Statically link libsqlite3 into shell

# https://sqlite.org/compile.html#enable_null_trim
NULL_TRIM_DESC=		Omits NULL columns at the ends of rows

# http://www.sqlite.org/compile.html#enable_offset_sql_func
OFFSET_DESC=		Enable sqlite_offset() returning record's file offset

# https://www.sqlite.org/compile.html#enable_deserialize
SER1_DESC=		Enable the sqlite3_[de]serialize() interface

# https://www.sqlite.org/sessionintro.html
SESSION_DESC=		Enable the session extension

# https://sqlite.org/compile.html#like_doesnt_match_blobs
LIKENOTBLOB_DESC=	LIKE does not match blobs

# https://www.sqlite.org/compile.html#enable_api_armor
ARMOR_DESC= 	Detect misuse of the API
# https://sqlite.org/compile.html#enable_dbpage_vtab
DBPAGE_DESC= 	Enable DBPAGE Virtual Table
# https://www.sqlite.org/dbstat.html
DBSTAT_DESC= 	Enable DBSTAT Virtual Table
DIRECT_READ_DESC= 	File is read directly from disk
EDITLINE_DESC= 	the BSD libedit from ports
EXTENSION_DESC= Allow loadable extensions
# https://www.sqlite.org/compile.html#enable_fts3_tokenizer
# https://www.sqlite.org/fts3.html#f3tknzr
FTS3_TOKEN_DESC= 	Enable two-args version fts3_tokenizer
# https://www.sqlite.org/fts3.html
# https://www.sqlite.org/compile.html#enable_fts3_parenthesis
FTS4_DESC= 	Enable FTS3/4 (Full Text Search) module

# https://www.sqlite.org/fts5.html
FTS5_DESC= 	Enable version 5 full-text search engine
# https://www.sqlite.org/geopoly.html
GEOPOLY_DESC= 	Uses the GeoJSON notation (RFC-7946)
# https://www.sqlite.org/fts3.html#f3tknzr
FTS3_TOKEN_DESC=	Enable two-args version fts3_tokenizer

# https://www.sqlite.org/json1.html
JSON1_DESC= 	Enable the JSON1 extension
# https://sqlite.org/compile.html#like_doesnt_match_blobs
LIKENOTBLOB_DESC= 	LIKE does not match blobs
MEMMAN_DESC= 	Allow it to release unused memory
METADATA_DESC= 	Enable column metadata
# https://sqlite.org/compile.html#enable_null_trim
NULL_TRIM_DESC= Omits NULL columns at the ends of rows
# http://www.sqlite.org/compile.html#enable_offset_sql_func
OFFSET_DESC= 	Enable sqlite_offset() returning record's file offset
OPT_EXT_DESC= 	Optional extensions
OPT_FUNC_DESC= 	Optional functions
# https://www.sqlite.org/rbu.html
RBU_DESC= 	Enable the resumable bulk update
READLINEP_DESC= the GNU libreadline from ports
READLINES_DESC= the libreadline from system
RL_DESC=	Which command line editing library to use:
# https://www.sqlite.org/rtree.html
RTREE_DESC= 	Enable R*Tree module
RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates
RTREEG_DESC= 	Index type for range queries
SECURE_DELETE_DESC= 	Overwrite deleted information with zeros
# https://www.sqlite.org/compile.html#enable_deserialize
SER1_DESC= 	Enable the sqlite3_[de]serialize() interface
# https://www.sqlite.org/sessionintro.html
SESSION_DESC= 	Enable the session extension
# https://www.sqlite.org/compile.html#enable_sorter_references
SORT_REF_DESC= 	To use references in the sorter
SOUNDEX_DESC= 	Enable the soundex() SQL function
# https://www.sqlite.org/queryplanner-ng.html#qpstab
STAT_DESC= 	Which query planner to use, stability or ...
STAT3_DESC= 	collect histogram data from leftmost column
STAT4_DESC= 	collect histogram data from all columns
# https://www.sqlite.org/c3ref/stmt_scanstatus.html
STMT_DESC= 	Prepared statement scan status
STSHELL_DESC= 	Statically link libsqlite3 into shell
# https://www.sqlite.org/compile.html#enable_sorter_references
SORT_REF_DESC=		To use references in the sorter

# https://www.sqlite.org/tempfiles.html#tempstore
RAMT_DESC= 	Where to store temporary file
TS0_DESC= 	Always use temporary file
TS1_DESC= 	File by default, change allowed PRAGMA
TS2_DESC= 	Memory by default, change allowed PRAGMA
TS3_DESC= 	Always use memory
UNICODE61_DESC= Unicode Version 6.1 tokenizer
UNICODE_DESC= 	Unicode support
# http://sqlite.org/compile.html#enable_unknown_sql_function
UNKNOWN_SQL_DESC= 	Suppress unknown function errors
UNLOCK_NOTIFY_DESC= 	Enable notification on unlocking
URI_AUTHORITY_DESC=	Allow convert URL into a UNC
URI_DESC= 	Enable use the URI filename

ARMOR_CPPFLAGS= 	-DSQLITE_ENABLE_API_ARMOR=1
DBPAGE_CPPFLAGS= 	-DSQLITE_ENABLE_DBPAGE_VTAB=1
DBSTAT_CPPFLAGS= 	-DSQLITE_ENABLE_DBSTAT_VTAB=1
DIRECT_READ_CPPFLAGS= 	-DSQLITE_DIRECT_OVERFLOW_READ=1
EDITLINE_CONFIGURE_ENABLE= editline
EDITLINE_PREVENTS= 	READLINES READLINEP
EDITLINE_USES= 		libedit
EXTENSION_CONFIGURE_ENABLE= dynamic-extensions
FTS3_TOKEN_CPPFLAGS= 	-DSQLITE_ENABLE_FTS3_TOKENIZER=1
FTS4_CPPFLAGS= 		-DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
FTS5_CONFIGURE_ENABLE= 	fts5
FTS5_LIBS= 		-lm
GEOPOLY_CPPFLAGS= 	-DSQLITE_ENABLE_GEOPOLY=1
GEOPOLY_IMPLIES= 	RTREE
ICU_BUILD_DEPENDS= 	${LOCALBASE}/bin/icu-config:devel/icu
ICU_CPPFLAGS= 		`${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1
ICU_LIB_DEPENDS= 	libicudata.so:devel/icu
ICU_LIBS= 		`${LOCALBASE}/bin/icu-config --ldflags`
JSON1_CONFIGURE_ENABLE= json1
LIKENOTBLOB_CPPFLAGS= 	-DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1
MEMMAN_CPPFLAGS= 	-DSQLITE_ENABLE_MEMORY_MANAGEMENT=1
METADATA_CPPFLAGS= 	-DSQLITE_ENABLE_COLUMN_METADATA=1
NULL_TRIM_CPPFLAGS= 	-DSQLITE_ENABLE_NULL_TRIM=1
OFFSET_CPPFLAGS= 	-DSQLITE_ENABLE_OFFSET_SQL_FUNC=1
RBU_CPPFLAGS= 		-DSQLITE_ENABLE_RBU=1
READLINEP_CONFIGURE_ON= --enable-readline
READLINEP_PREVENTS= 	READLINES EDITLINE
READLINEP_USES= 	readline:port
READLINES_CONFIGURE_ON= --enable-readline
READLINES_PREVENTS= 	READLINEP EDITLINE
READLINES_USES= 	readline
RTREE_CPPFLAGS=		-DSQLITE_ENABLE_RTREE=1
READLINEP_PREVENTS=	READLINES EDITLINE
EDITLINE_PREVENTS=	READLINES READLINEP

OPTIONS_DEFAULT=	FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
			EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL READLINES \
			FTS3_TOKEN FTS5
# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
# RTREE used by graphics/mapnik, databases/spatialite
# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
# FTS5 used by sysutils/tracker

PLIST_FILES=	bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
		lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \
		lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \
		man/man1/sqlite3.1.gz

# The default numeric file permissions for newly created database files under unix.
# If not specified, the default is 0644 which means that the files is globally
# readable but only writable by the creator.
.ifdef DEFAULT_FILE_PERMISSIONS
CPPFLAGS+=		-DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
.endif

# Use an in-ram database for temporary tables (never,no,yes,always),
TS0_CPPFLAGS=	-DSQLITE_TEMP_STORE=0
TS1_CPPFLAGS=	-DSQLITE_TEMP_STORE=1
TS2_CPPFLAGS=	-DSQLITE_TEMP_STORE=2
TS3_CPPFLAGS=	-DSQLITE_TEMP_STORE=3

RTREE_CPPFLAGS=	-DSQLITE_ENABLE_RTREE=1
RTREE_INT_CPPFLAGS=	-DSQLITE_RTREE_INT_ONLY=1
SECURE_DELETE_CPPFLAGS=	-DSQLITE_SECURE_DELETE=1
SER1_CPPFLAGS=		-DSQLITE_ENABLE_DESERIALIZE=1
SESSION_CONFIGURE_ENABLE=	session
SORT_REF_CPPFLAGS=	-DSQLITE_ENABLE_SORTER_REFERENCES=1
FTS5_LIBS=		-lm
FTS3_TOKEN_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_TOKENIZER=1

SOUNDEX_CPPFLAGS=	-DSQLITE_SOUNDEX=1
STAT3_CPPFLAGS=		-DSQLITE_ENABLE_STAT3=1
STAT4_CPPFLAGS=		-DSQLITE_ENABLE_STAT4=1
STMT_CPPFLAGS=		-DSQLITE_ENABLE_STMT_SCANSTATUS=1
STSHELL_CONFIGURE_ENABLE= 	static-shell
STAT3_CPPFLAGS=	-DSQLITE_ENABLE_STAT3=1
STAT4_CPPFLAGS=	-DSQLITE_ENABLE_STAT4=1
DBPAGE_CPPFLAGS=	-DSQLITE_ENABLE_DBPAGE_VTAB=1
DBSTAT_CPPFLAGS=	-DSQLITE_ENABLE_DBSTAT_VTAB=1
URI_CPPFLAGS=	-DSQLITE_USE_URI=1
URI_AUTHORITY_CPPFLAGS=	-DSQLITE_ALLOW_URI_AUTHORITY=1
DIRECT_READ_CPPFLAGS=	-DSQLITE_DIRECT_OVERFLOW_READ=1
ARMOR_CPPFLAGS=	-DSQLITE_ENABLE_API_ARMOR=1
STMT_CPPFLAGS=	-DSQLITE_ENABLE_STMT_SCANSTATUS=1

EXTENSION_CONFIGURE_ENABLE=	dynamic-extensions

THREADS_CONFIGURE_ENABLE=	threadsafe
THREADS_LIBS= -lpthread
# Use an in-ram database for temporary tables (never,no,yes,always),
TS0_CPPFLAGS=		-DSQLITE_TEMP_STORE=0
TS1_CPPFLAGS=		-DSQLITE_TEMP_STORE=1
TS2_CPPFLAGS=		-DSQLITE_TEMP_STORE=2
TS3_CPPFLAGS=		-DSQLITE_TEMP_STORE=3

UNICODE61_CPPFLAGS=	""
UNICODE61_CPPFLAGS_OFF=	-DSQLITE_DISABLE_FTS3_UNICODE=1
UNICODE61_CPPFLAGS= ""
READLINES_CONFIGURE_ON=	--enable-readline
READLINES_USES=	readline
READLINEP_CONFIGURE_ON=	--enable-readline
READLINEP_USES=	readline:port
EDITLINE_CONFIGURE_ENABLE=	editline
EDITLINE_USES=	libedit

JSON1_CONFIGURE_ENABLE=	json1

RBU_CPPFLAGS=	-DSQLITE_ENABLE_RBU=1

LIKENOTBLOB_CPPFLAGS=	-DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1

STSHELL_CONFIGURE_ENABLE=	static-shell

SESSION_CONFIGURE_ENABLE=	session

UNKNOWN_SQL_CPPFLAGS=	-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1
UNLOCK_NOTIFY_CPPFLAGS=	-DSQLITE_ENABLE_UNLOCK_NOTIFY=1
URI_AUTHORITY_CPPFLAGS=	-DSQLITE_ALLOW_URI_AUTHORITY=1
URI_CPPFLAGS=		-DSQLITE_USE_URI=1

NULL_TRIM_CPPFLAGS=	-DSQLITE_ENABLE_NULL_TRIM=1

OFFSET_CPPFLAGS=	-DSQLITE_ENABLE_OFFSET_SQL_FUNC=1

SER1_CPPFLAGS=	-DSQLITE_ENABLE_DESERIALIZE=1

SORT_REF_CPPFLAGS=	-DSQLITE_ENABLE_SORTER_REFERENCES=1

.include <bsd.port.options.mk>

# Platform Configuration
CPPFLAGS+=	-DHAVE_ISNAN=1 -DHAVE_MALLOC_USABLE_SIZE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_USLEEP=1 -DHAVE_STRCHRNUL=1

post-configure:
	@${ECHO_MSG} "===> CONFIGURE_ARGS=${CONFIGURE_ARGS}"
	@${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}"

Return to bug 231770

Lines 3-8 Link Here

(-)Makefile (-188 / +176 lines)
3		3
4	PORTNAME= sqlite3	4	PORTNAME= sqlite3
5	DISTVERSION= 3.25.1	5	DISTVERSION= 3.25.1
		6	PORTREVISION= 1
6	CATEGORIES= databases	7	CATEGORIES= databases
7	MASTER_SITES= https://www.sqlite.org/2018/ http://www2.sqlite.org/2018/ http://www3.sqlite.org/2018/	8	MASTER_SITES= https://www.sqlite.org/2018/ http://www2.sqlite.org/2018/ http://www3.sqlite.org/2018/
8	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00	9	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
Lines 9-231 Link Here
9		10
10	MAINTAINER= pavelivolkov@gmail.com	11	MAINTAINER= pavelivolkov@gmail.com
11	COMMENT= SQL database engine in a C library	12	COMMENT= SQL database engine in a C library
		13	.if ${FLAVOR:U} == icu
		14	COMMENT+= (icu flavor)
		15	.elif ${FLAVOR:U} == mini
		16	COMMENT+= (Compacted, mini flavor)
		17	.endif
12		18
13	LICENSE= PD	19	LICENSE= PD
14		20
		21	FLAVORS= default icu mini
		22	FLAVOR?= ${FLAVORS:[1]}
		23	default_CONFLICTS_INSTALL= sqlite3-icu sqlite3-mini
		24	icu_CONFLICTS_INSTALL= sqlite3 sqlite3-mini
		25	icu_BUILD_DEPENDS= ${LOCALBASE}/bin/icu-config:devel/icu
		26	icu_LIB_DEPENDS= libicudata.so:devel/icu
		27	icu_PKGNAMESUFFIX= -icu
		28	mini_CONFLICTS_INSTALL= sqlite3 sqlite3-icu
		29	mini_PKGNAMESUFFIX= -mini
		30
15	USES= libtool ncurses pathfix	31	USES= libtool ncurses pathfix
		32	USE_LDCONFIG= yes
		33
		34	# Platform Configuration
		35	CPPFLAGS+= -DHAVE_ISNAN=1 -DHAVE_MALLOC_USABLE_SIZE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_USLEEP=1 -DHAVE_STRCHRNUL=1
		36	# The default numeric file permissions for newly created database files under unix.
		37	# If not specified, the default is 0644 which means that the files is globally
		38	# readable but only writable by the creator.
		39	.ifdef DEFAULT_FILE_PERMISSIONS
		40	CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
		41	.endif
		42	.if ${FLAVOR:U} == icu
		43	CPPFLAGS+= `${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1
		44	LIBS+= `${LOCALBASE}/bin/icu-config --ldflags`
		45	.endif
16	GNU_CONFIGURE= yes	46	GNU_CONFIGURE= yes
17	USE_LDCONFIG= yes
18	INSTALL_TARGET= install-strip	47	INSTALL_TARGET= install-strip
19
20	MAKE_JOBS_UNSAFE= yes	48	MAKE_JOBS_UNSAFE= yes
		49	PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
		50	lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \
		51	lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \
		52	man/man1/sqlite3.1.gz
21		53
22	# Compilation Options For SQLite https://www.sqlite.org/compile.html	54	# Compilation Options For SQLite https://www.sqlite.org/compile.html
23	OPTIONS_DEFINE= FTS4 URI URI_AUTHORITY METADATA \	55	OPTIONS_DEFINE= ARMOR DBPAGE DBSTAT DIRECT_READ EXTENSION \
24	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \	56	FTS3_TOKEN FTS4 FTS5 LIKENOTBLOB MEMMAN METADATA \
25	EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \	57	NULL_TRIM RBU SECURE_DELETE SORT_REF STMT STSHELL \
26	LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF	58	THREADS UNKNOWN_SQL UNLOCK_NOTIFY URI URI_AUTHORITY
27	OPTIONS_SINGLE= RAMT	59	OPTIONS_DEFAULT= DBSTAT EXTENSION FTS3_TOKEN FTS4 FTS5 METADATA \
28	OPTIONS_RADIO= STAT	60	READLINES RTREE SECURE_DELETE STSHELL THREADS \
29	OPTIONS_GROUP= OPT_EXT OPT_FUNC UNICODE RTREEG RL	61	TS1 UNICODE61 UNLOCK_NOTIFY URI
		62	OPTIONS_GROUP= OPT_EXT OPT_FUNC RL RTREEG UNICODE
		63	OPTIONS_GROUP_OPT_EXT= JSON1 SESSION
		64	OPTIONS_GROUP_OPT_FUNC= OFFSET SER1 SOUNDEX
		65	OPTIONS_GROUP_RL= READLINES READLINEP EDITLINE
		66	OPTIONS_GROUP_RTREEG= RTREE RTREE_INT GEOPOLY
		67	OPTIONS_GROUP_UNICODE= ICU UNICODE61
		68	OPTIONS_RADIO= STAT
		69	OPTIONS_RADIO_STAT= STAT3 STAT4
		70	OPTIONS_SINGLE= RAMT
		71	OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3
		72	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
		73	# RTREE used by graphics/mapnik, databases/spatialite
		74	# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
		75	# FTS5 used by sysutils/tracker
30		76
31	OPTIONS_GROUP_OPT_EXT= JSON1 SESSION	77	.if ${FLAVOR:U} == icu
32	OPTIONS_GROUP_OPT_FUNC= OFFSET SER1 SOUNDEX	78	OPTIONS_EXCLUDE= ICU
		79	.endif
33		80
34	OPT_EXT_DESC= Optional extensions	81	.if ${FLAVOR:U} == mini
35	OPT_FUNC_DESC= Optional functions	82	OPTIONS_EXCLUDE= ARMOR DBPAGE DBSTAT DIRECT_READ EDITLINE EXTENSION \
36	URI_DESC= Enable use the URI filename	83	FTS3_TOKEN FTS4 FTS5 GEOPOLY ICU JSON1 LIKENOTBLOB \
37	URI_AUTHORITY_DESC= Allow convert URL into a UNC	84	MEMMAN METADATA NULL_TRIM OFFSET RBU READLINES \
38	SOUNDEX_DESC= Enable the soundex() SQL function	85	READLINEP RTREE RTREE_INT SECURE_DELETE SER1 SESSION \
39	METADATA_DESC= Enable column metadata	86	SORT_REF SOUNDEX STAT3 STAT4 STMT STSHELL UNICODE61 \
40	DIRECT_READ_DESC= File is read directly from disk	87	UNKNOWN_SQL UNLOCK_NOTIFY URI URI_AUTHORITY
41	MEMMAN_DESC= Allow it to release unused memory	88	.endif
42	SECURE_DELETE_DESC= Overwrite deleted information with zeros
43	UNLOCK_NOTIFY_DESC= Enable notification on unlocking
44	EXTENSION_DESC= Allow loadable extensions
45	STSHELL_DESC= Statically link libsqlite3 into shell
46		89
47	# https://sqlite.org/compile.html#enable_null_trim
48	NULL_TRIM_DESC= Omits NULL columns at the ends of rows
49
50	# http://www.sqlite.org/compile.html#enable_offset_sql_func
51	OFFSET_DESC= Enable sqlite_offset() returning record's file offset
52
53	# https://www.sqlite.org/compile.html#enable_deserialize
54	SER1_DESC= Enable the sqlite3_[de]serialize() interface
55
56	# https://www.sqlite.org/sessionintro.html
57	SESSION_DESC= Enable the session extension
58
59	# https://sqlite.org/compile.html#like_doesnt_match_blobs
60	LIKENOTBLOB_DESC= LIKE does not match blobs
61
62	# https://www.sqlite.org/compile.html#enable_api_armor	90	# https://www.sqlite.org/compile.html#enable_api_armor
63	ARMOR_DESC= Detect misuse of the API	91	ARMOR_DESC= Detect misuse of the API
64		92	# https://sqlite.org/compile.html#enable_dbpage_vtab
65	# http://sqlite.org/compile.html#enable_unknown_sql_function	93	DBPAGE_DESC= Enable DBPAGE Virtual Table
66	UNKNOWN_SQL_DESC= Suppress unknown function errors	94	# https://www.sqlite.org/dbstat.html
67		95	DBSTAT_DESC= Enable DBSTAT Virtual Table
		96	DIRECT_READ_DESC= File is read directly from disk
		97	EDITLINE_DESC= the BSD libedit from ports
		98	EXTENSION_DESC= Allow loadable extensions
		99	# https://www.sqlite.org/compile.html#enable_fts3_tokenizer
		100	# https://www.sqlite.org/fts3.html#f3tknzr
		101	FTS3_TOKEN_DESC= Enable two-args version fts3_tokenizer
68	# https://www.sqlite.org/fts3.html	102	# https://www.sqlite.org/fts3.html
69	# https://www.sqlite.org/compile.html#enable_fts3_parenthesis	103	# https://www.sqlite.org/compile.html#enable_fts3_parenthesis
70	FTS4_DESC= Enable FTS3/4 (Full Text Search) module	104	FTS4_DESC= Enable FTS3/4 (Full Text Search) module
71
72	# https://www.sqlite.org/fts5.html	105	# https://www.sqlite.org/fts5.html
73	FTS5_DESC= Enable version 5 full-text search engine	106	FTS5_DESC= Enable version 5 full-text search engine
74		107	# https://www.sqlite.org/geopoly.html
75	# https://www.sqlite.org/compile.html#enable_fts3_tokenizer	108	GEOPOLY_DESC= Uses the GeoJSON notation (RFC-7946)
76	# https://www.sqlite.org/fts3.html#f3tknzr
77	FTS3_TOKEN_DESC= Enable two-args version fts3_tokenizer
78
79	# https://www.sqlite.org/json1.html	109	# https://www.sqlite.org/json1.html
80	JSON1_DESC= Enable the JSON1 extension	110	JSON1_DESC= Enable the JSON1 extension
81		111	# https://sqlite.org/compile.html#like_doesnt_match_blobs
		112	LIKENOTBLOB_DESC= LIKE does not match blobs
		113	MEMMAN_DESC= Allow it to release unused memory
		114	METADATA_DESC= Enable column metadata
		115	# https://sqlite.org/compile.html#enable_null_trim
		116	NULL_TRIM_DESC= Omits NULL columns at the ends of rows
		117	# http://www.sqlite.org/compile.html#enable_offset_sql_func
		118	OFFSET_DESC= Enable sqlite_offset() returning record's file offset
		119	OPT_EXT_DESC= Optional extensions
		120	OPT_FUNC_DESC= Optional functions
82	# https://www.sqlite.org/rbu.html	121	# https://www.sqlite.org/rbu.html
83	RBU_DESC= Enable the resumable bulk update	122	RBU_DESC= Enable the resumable bulk update
84		123	READLINEP_DESC= the GNU libreadline from ports
		124	READLINES_DESC= the libreadline from system
		125	RL_DESC= Which command line editing library to use:
		126	# https://www.sqlite.org/rtree.html
		127	RTREE_DESC= Enable R*Tree module
		128	RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates
		129	RTREEG_DESC= Index type for range queries
		130	SECURE_DELETE_DESC= Overwrite deleted information with zeros
		131	# https://www.sqlite.org/compile.html#enable_deserialize
		132	SER1_DESC= Enable the sqlite3_[de]serialize() interface
		133	# https://www.sqlite.org/sessionintro.html
		134	SESSION_DESC= Enable the session extension
		135	# https://www.sqlite.org/compile.html#enable_sorter_references
		136	SORT_REF_DESC= To use references in the sorter
		137	SOUNDEX_DESC= Enable the soundex() SQL function
		138	# https://www.sqlite.org/queryplanner-ng.html#qpstab
		139	STAT_DESC= Which query planner to use, stability or ...
		140	STAT3_DESC= collect histogram data from leftmost column
		141	STAT4_DESC= collect histogram data from all columns
85	# https://www.sqlite.org/c3ref/stmt_scanstatus.html	142	# https://www.sqlite.org/c3ref/stmt_scanstatus.html
86	STMT_DESC= Prepared statement scan status	143	STMT_DESC= Prepared statement scan status
87		144	STSHELL_DESC= Statically link libsqlite3 into shell
88	# https://www.sqlite.org/compile.html#enable_sorter_references
89	SORT_REF_DESC= To use references in the sorter
90
91	# https://www.sqlite.org/tempfiles.html#tempstore	145	# https://www.sqlite.org/tempfiles.html#tempstore
92	OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3	146	RAMT_DESC= Where to store temporary file
93	RAMT_DESC= Where to store temporary file	147	TS0_DESC= Always use temporary file
94	TS0_DESC= Always use temporary file	148	TS1_DESC= File by default, change allowed PRAGMA
95	TS1_DESC= File by default, change allowed PRAGMA	149	TS2_DESC= Memory by default, change allowed PRAGMA
96	TS2_DESC= Memory by default, change allowed PRAGMA	150	TS3_DESC= Always use memory
97	TS3_DESC= Always use memory	151	UNICODE61_DESC= Unicode Version 6.1 tokenizer
		152	UNICODE_DESC= Unicode support
		153	# http://sqlite.org/compile.html#enable_unknown_sql_function
		154	UNKNOWN_SQL_DESC= Suppress unknown function errors
		155	UNLOCK_NOTIFY_DESC= Enable notification on unlocking
		156	URI_AUTHORITY_DESC= Allow convert URL into a UNC
		157	URI_DESC= Enable use the URI filename
98		158
99	# https://www.sqlite.org/queryplanner-ng.html#qpstab	159	ARMOR_CPPFLAGS= -DSQLITE_ENABLE_API_ARMOR=1
100	OPTIONS_RADIO_STAT= STAT3 STAT4	160	DBPAGE_CPPFLAGS= -DSQLITE_ENABLE_DBPAGE_VTAB=1
101	STAT_DESC= Which query planner to use, stability or ...	161	DBSTAT_CPPFLAGS= -DSQLITE_ENABLE_DBSTAT_VTAB=1
102	STAT3_DESC= collect histogram data from leftmost column	162	DIRECT_READ_CPPFLAGS= -DSQLITE_DIRECT_OVERFLOW_READ=1
103	STAT4_DESC= collect histogram data from all columns	163	EDITLINE_CONFIGURE_ENABLE= editline
104		164	EDITLINE_PREVENTS= READLINES READLINEP
105	# https://sqlite.org/compile.html#enable_dbpage_vtab	165	EDITLINE_USES= libedit
106	DBPAGE_DESC= Enable DBPAGE Virtual Table	166	EXTENSION_CONFIGURE_ENABLE= dynamic-extensions
107		167	FTS3_TOKEN_CPPFLAGS= -DSQLITE_ENABLE_FTS3_TOKENIZER=1
108	# https://www.sqlite.org/dbstat.html	168	FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
109	DBSTAT_DESC= Enable DBSTAT Virtual Table	169	FTS5_CONFIGURE_ENABLE= fts5
110		170	FTS5_LIBS= -lm
111	# https://www.sqlite.org/fts3.html#tokenizer	171	GEOPOLY_CPPFLAGS= -DSQLITE_ENABLE_GEOPOLY=1
112	OPTIONS_GROUP_UNICODE= ICU UNICODE61	172	GEOPOLY_IMPLIES= RTREE
113	UNICODE_DESC= Unicode support	173	ICU_BUILD_DEPENDS= ${LOCALBASE}/bin/icu-config:devel/icu
114	UNICODE61_DESC= Unicode Version 6.1 tokenizer	174	ICU_CPPFLAGS= `${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1
115		175	ICU_LIB_DEPENDS= libicudata.so:devel/icu
116	# https://www.sqlite.org/rtree.html	176	ICU_LIBS= `${LOCALBASE}/bin/icu-config --ldflags`
117	OPTIONS_GROUP_RTREEG= RTREE RTREE_INT GEOPOLY	177	JSON1_CONFIGURE_ENABLE= json1
118	RTREEG_DESC= Index type for range queries	178	LIKENOTBLOB_CPPFLAGS= -DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1
119	RTREE_DESC= Enable R*Tree module	179	MEMMAN_CPPFLAGS= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1
120	RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates	180	METADATA_CPPFLAGS= -DSQLITE_ENABLE_COLUMN_METADATA=1
121	# https://www.sqlite.org/geopoly.html	181	NULL_TRIM_CPPFLAGS= -DSQLITE_ENABLE_NULL_TRIM=1
122	GEOPOLY_DESC= Uses the GeoJSON notation (RFC-7946)	182	OFFSET_CPPFLAGS= -DSQLITE_ENABLE_OFFSET_SQL_FUNC=1
123	GEOPOLY_IMPLIES= RTREE	183	RBU_CPPFLAGS= -DSQLITE_ENABLE_RBU=1
124		184	READLINEP_CONFIGURE_ON= --enable-readline
125	OPTIONS_GROUP_RL= READLINES READLINEP EDITLINE	185	READLINEP_PREVENTS= READLINES EDITLINE
126	RL_DESC= Which command line editing library to use:	186	READLINEP_USES= readline:port
127	READLINES_DESC= the libreadline from system	187	READLINES_CONFIGURE_ON= --enable-readline
128	READLINEP_DESC= the GNU libreadline from ports	188	READLINES_PREVENTS= READLINEP EDITLINE
129	EDITLINE_DESC= the BSD libedit from ports	189	READLINES_USES= readline
130	READLINES_PREVENTS= READLINEP EDITLINE	190	RTREE_CPPFLAGS= -DSQLITE_ENABLE_RTREE=1
131	READLINEP_PREVENTS= READLINES EDITLINE
132	EDITLINE_PREVENTS= READLINES READLINEP
133
134	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
135	EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL READLINES \
136	FTS3_TOKEN FTS5
137	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
138	# RTREE used by graphics/mapnik, databases/spatialite
139	# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
140	# FTS5 used by sysutils/tracker
141
142	PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
143	lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \
144	lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \
145	man/man1/sqlite3.1.gz
146
147	# The default numeric file permissions for newly created database files under unix.
148	# If not specified, the default is 0644 which means that the files is globally
149	# readable but only writable by the creator.
150	.ifdef DEFAULT_FILE_PERMISSIONS
151	CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
152	.endif
153
154	# Use an in-ram database for temporary tables (never,no,yes,always),
155	TS0_CPPFLAGS= -DSQLITE_TEMP_STORE=0
156	TS1_CPPFLAGS= -DSQLITE_TEMP_STORE=1
157	TS2_CPPFLAGS= -DSQLITE_TEMP_STORE=2
158	TS3_CPPFLAGS= -DSQLITE_TEMP_STORE=3
159
160	RTREE_CPPFLAGS= -DSQLITE_ENABLE_RTREE=1
161	RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1	191	RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1
162	GEOPOLY_CPPFLAGS= -DSQLITE_ENABLE_GEOPOLY=1	192	SECURE_DELETE_CPPFLAGS= -DSQLITE_SECURE_DELETE=1
163		193	SER1_CPPFLAGS= -DSQLITE_ENABLE_DESERIALIZE=1
164	FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1	194	SESSION_CONFIGURE_ENABLE= session
165	FTS5_CONFIGURE_ENABLE= fts5	195	SORT_REF_CPPFLAGS= -DSQLITE_ENABLE_SORTER_REFERENCES=1
166	FTS5_LIBS= -lm
167	FTS3_TOKEN_CPPFLAGS= -DSQLITE_ENABLE_FTS3_TOKENIZER=1
168
169	SOUNDEX_CPPFLAGS= -DSQLITE_SOUNDEX=1	196	SOUNDEX_CPPFLAGS= -DSQLITE_SOUNDEX=1
170	MEMMAN_CPPFLAGS= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1	197	STAT3_CPPFLAGS= -DSQLITE_ENABLE_STAT3=1
171	SECURE_DELETE_CPPFLAGS= -DSQLITE_SECURE_DELETE=1	198	STAT4_CPPFLAGS= -DSQLITE_ENABLE_STAT4=1
172	UNLOCK_NOTIFY_CPPFLAGS= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1	199	STMT_CPPFLAGS= -DSQLITE_ENABLE_STMT_SCANSTATUS=1
173	METADATA_CPPFLAGS= -DSQLITE_ENABLE_COLUMN_METADATA=1	200	STSHELL_CONFIGURE_ENABLE= static-shell
174	STAT3_CPPFLAGS= -DSQLITE_ENABLE_STAT3=1
175	STAT4_CPPFLAGS= -DSQLITE_ENABLE_STAT4=1
176	DBPAGE_CPPFLAGS= -DSQLITE_ENABLE_DBPAGE_VTAB=1
177	DBSTAT_CPPFLAGS= -DSQLITE_ENABLE_DBSTAT_VTAB=1
178	URI_CPPFLAGS= -DSQLITE_USE_URI=1
179	URI_AUTHORITY_CPPFLAGS= -DSQLITE_ALLOW_URI_AUTHORITY=1
180	DIRECT_READ_CPPFLAGS= -DSQLITE_DIRECT_OVERFLOW_READ=1
181	ARMOR_CPPFLAGS= -DSQLITE_ENABLE_API_ARMOR=1
182	STMT_CPPFLAGS= -DSQLITE_ENABLE_STMT_SCANSTATUS=1
183
184	EXTENSION_CONFIGURE_ENABLE= dynamic-extensions
185
186	THREADS_CONFIGURE_ENABLE= threadsafe	201	THREADS_CONFIGURE_ENABLE= threadsafe
187	THREADS_LIBS= -lpthread	202	THREADS_LIBS= -lpthread
188		203	# Use an in-ram database for temporary tables (never,no,yes,always),
189	ICU_BUILD_DEPENDS= ${LOCALBASE}/bin/icu-config:devel/icu	204	TS0_CPPFLAGS= -DSQLITE_TEMP_STORE=0
190	ICU_LIB_DEPENDS= libicudata.so:devel/icu	205	TS1_CPPFLAGS= -DSQLITE_TEMP_STORE=1
191	ICU_CPPFLAGS= `${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1	206	TS2_CPPFLAGS= -DSQLITE_TEMP_STORE=2
192	ICU_LIBS= `${LOCALBASE}/bin/icu-config --ldflags`	207	TS3_CPPFLAGS= -DSQLITE_TEMP_STORE=3
193
194	UNICODE61_CPPFLAGS= ""
195	UNICODE61_CPPFLAGS_OFF= -DSQLITE_DISABLE_FTS3_UNICODE=1	208	UNICODE61_CPPFLAGS_OFF= -DSQLITE_DISABLE_FTS3_UNICODE=1
196		209	UNICODE61_CPPFLAGS= ""
197	READLINES_CONFIGURE_ON= --enable-readline
198	READLINES_USES= readline
199	READLINEP_CONFIGURE_ON= --enable-readline
200	READLINEP_USES= readline:port
201	EDITLINE_CONFIGURE_ENABLE= editline
202	EDITLINE_USES= libedit
203
204	JSON1_CONFIGURE_ENABLE= json1
205
206	RBU_CPPFLAGS= -DSQLITE_ENABLE_RBU=1
207
208	LIKENOTBLOB_CPPFLAGS= -DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1
209
210	STSHELL_CONFIGURE_ENABLE= static-shell
211
212	SESSION_CONFIGURE_ENABLE= session
213
214	UNKNOWN_SQL_CPPFLAGS= -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1	210	UNKNOWN_SQL_CPPFLAGS= -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1
		211	UNLOCK_NOTIFY_CPPFLAGS= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
		212	URI_AUTHORITY_CPPFLAGS= -DSQLITE_ALLOW_URI_AUTHORITY=1
		213	URI_CPPFLAGS= -DSQLITE_USE_URI=1
215		214
216	NULL_TRIM_CPPFLAGS= -DSQLITE_ENABLE_NULL_TRIM=1
217
218	OFFSET_CPPFLAGS= -DSQLITE_ENABLE_OFFSET_SQL_FUNC=1
219
220	SER1_CPPFLAGS= -DSQLITE_ENABLE_DESERIALIZE=1
221
222	SORT_REF_CPPFLAGS= -DSQLITE_ENABLE_SORTER_REFERENCES=1
223
224	.include <bsd.port.options.mk>	215	.include <bsd.port.options.mk>
225		216
226	# Platform Configuration
227	CPPFLAGS+= -DHAVE_ISNAN=1 -DHAVE_MALLOC_USABLE_SIZE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_USLEEP=1 -DHAVE_STRCHRNUL=1
228
229	post-configure:	217	post-configure:
230	@${ECHO_MSG} "===> CONFIGURE_ARGS=${CONFIGURE_ARGS}"	218	@${ECHO_MSG} "===> CONFIGURE_ARGS=${CONFIGURE_ARGS}"
231	@${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}"	219	@${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}"