Attachment #165298 for bug #206062

View | Details | Raw Unified | Return to bug 206062
Collapse All | Expand All




# $FreeBSD: head/databases/sqlite3/Makefile 401015 2015-11-07 18:26:02Z riggs $

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

MAINTAINER=	pavelivolkov@gmail.com


LICENSE=	public
LICENSE_NAME=	Public Domain
LICENSE_TEXT=	Description of the license can be obtained from the following URL: https://www.sqlite.org/copyright.html
LICENSE_PERMS=	dist-mirror dist-sell pkg-mirror pkg-sell auto-accept

CONFLICTS=	sqlcipher-[0-9]*


MAKE_JOBS_UNSAFE=	yes

# Compilation Options For SQLite https://www.sqlite.org/compile.html
OPTIONS_DEFINE=	FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \
		DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
		EXTENSION ARMOR STMT DBSTAT FTS5 JSON1 RBU \
		LIKENOTBLOB STSHELL
OPTIONS_SINGLE=	RAMT
OPTIONS_RADIO=	STAT RL
OPTIONS_GROUP=	UNICODE RTREEG

UPD_DEL_LIMIT_DESC=	ORDER BY and LIMIT on UPDATE and DELETE

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#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://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/json1.html
JSON1_DESC=		Enable the JSON1 extension

# https://www.sqlite.org/rbu.html
RBU_DESC=		Enable the Resumable Bulk Update

# https://www.sqlite.org/c3ref/stmt_scanstatus.html
STMT_DESC=		Prepared Statement Scan Status

# https://www.sqlite.org/tempfiles.html#tempstore
OPTIONS_SINGLE_RAMT=	TS0 TS1 TS2 TS3
RAMT_DESC=		Where to store temporary file
TS0_DESC=		Always use temporary file

TS2_DESC=		Memory by default, change allowed PRAGMA
TS3_DESC=		Always use memory

# https://www.sqlite.org/queryplanner-ng.html#qpstab
OPTIONS_RADIO_STAT=	STAT3 STAT4
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/dbstat.html
DBSTAT_DESC=		Enable DBSTAT Virtual Table

# https://www.sqlite.org/fts3.html#tokenizer
OPTIONS_GROUP_UNICODE=	ICU UNICODE61
UNICODE_DESC=		Unicode support
UNICODE61_DESC=		Unicode Version 6.1 tokenizer

# https://www.sqlite.org/rtree.html
OPTIONS_GROUP_RTREEG=	RTREE RTREE_INT
RTREEG_DESC=		Index type for range queries
RTREE_DESC=		Enable R*Tree module
RTREE_INT_DESC=		Store 32-bit sig int (no float) coordinates

OPTIONS_RADIO_RL=	READLINES READLINEP EDITLINE
RL_DESC=		What is the command line editing is used:
READLINES_DESC=		the libreadline from system
READLINEP_DESC=		the GNU libreadline from ports
EDITLINE_DESC=		the BSD libedit from ports

OPTIONS_DEFAULT=	FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
			EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL
# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
# RTREE used by graphics/mapnik, databases/spatialite


CPPFLAGS+=		-DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
.endif

# This macro sets the default size of the page-cache for temporary files
# created by SQLite to store intermediate results, in pages.
.ifdef TEMP_CACHE_SIZE
CPPFLAGS+=		-DSQLITE_DEFAULT_TEMP_CACHE_SIZE=${TEMP_CACHE_SIZE}
.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

RTREE_CPPFLAGS=	-DSQLITE_ENABLE_RTREE=1
RTREE_INT_CPPFLAGS=	-DSQLITE_RTREE_INT_ONLY=1

FTS4_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
SOUNDEX_CPPFLAGS=	-DSQLITE_SOUNDEX=1
MEMMAN_CPPFLAGS=	-DSQLITE_ENABLE_MEMORY_MANAGEMENT=1
UPD_DEL_LIMIT_CPPFLAGS=	-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1


UNICODE61_CPPFLAGS_OFF=	-DSQLITE_DISABLE_FTS3_UNICODE=1

READLINES_CONFIGURE_ON=	--enable-readline
READLINES_USES=	readline
READLINEP_CONFIGURE_ON=	--enable-readline
READLINEP_USES=	readline:port
EDITLINE_CONFIGURE_ENABLE=	editline
EDITLINE_USES=	libedit

FTS5_CONFIGURE_ENABLE=	fts5



RBU_CPPFLAGS=	-DSQLITE_ENABLE_RBU=1

LIKENOTBLOB_CPPFLAGS=	-DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1

STSHELL_CONFIGURE_ENABLE=	static-shell

.include <bsd.port.options.mk>

post-configure:

Lines 1-2 Link Here

(-)ports/databases/sqlite3/distinfo (-2 / +2 lines)
1	SHA256 (sqlite-autoconf-3090200.tar.gz) = 064c0abe9c9177534d4c770bca7a5902f9924b629ac886b4c08956be6dfbc36b	1	SHA256 (sqlite-autoconf-3100000.tar.gz) = 43cc292d70711fa7580250c8a1cd7c64813a4a0a479dbd502cce5f10b5d91042
2	SIZE (sqlite-autoconf-3090200.tar.gz) = 2284431	2	SIZE (sqlite-autoconf-3100000.tar.gz) = 2331542

Lines 1-6 Link Here

(-)ports/databases/sqlite3/pkg-descr (-1 / +1 lines)
1	SQLite is an SQL database engine in a C library. Programs that link the SQLite	1	SQLite is an SQL database engine in a C library. Programs that link the SQLite
2	library can have SQL database access without running a separate RDBMS process.	2	library can have SQL database access without running a separate RDBMS process.
3	The distribution comes with a standalone command-line access program (sqlite)	3	The distribution comes with a standalone command-line access program (sqlite3)
4	that can be used to administer an SQLite database and which serves as an	4	that can be used to administer an SQLite database and which serves as an
5	example of how to use the SQLite library.	5	example of how to use the SQLite library.
6		6

Return to bug 206062

Lines 2-10 Link Here

(-)ports/databases/sqlite3/Makefile (-28 / +42 lines)
2	# $FreeBSD: head/databases/sqlite3/Makefile 401015 2015-11-07 18:26:02Z riggs $	2	# $FreeBSD: head/databases/sqlite3/Makefile 401015 2015-11-07 18:26:02Z riggs $
3		3
4	PORTNAME= sqlite3	4	PORTNAME= sqlite3
5	PORTVERSION= 3.9.2	5	PORTVERSION= 3.10.0
6	CATEGORIES= databases	6	CATEGORIES= databases
7	MASTER_SITES= https://www.sqlite.org/2015/ http://www2.sqlite.org/2015/ http://www3.sqlite.org/2015/	7	MASTER_SITES= https://www.sqlite.org/2016/ http://www2.sqlite.org/2016/ http://www3.sqlite.org/2016/
8	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00	8	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
9		9
10	MAINTAINER= pavelivolkov@gmail.com	10	MAINTAINER= pavelivolkov@gmail.com
Lines 12-18 COMMENT= SQL database engine in a C libr Link Here
12		12
13	LICENSE= public	13	LICENSE= public
14	LICENSE_NAME= Public Domain	14	LICENSE_NAME= Public Domain
15	LICENSE_TEXT= Description of the license can be obtained from the following URL: http://www.sqlite.org/copyright.html	15	LICENSE_TEXT= Description of the license can be obtained from the following URL: https://www.sqlite.org/copyright.html
16	LICENSE_PERMS= dist-mirror dist-sell pkg-mirror pkg-sell auto-accept	16	LICENSE_PERMS= dist-mirror dist-sell pkg-mirror pkg-sell auto-accept
17		17
18	CONFLICTS= sqlcipher-[0-9]*	18	CONFLICTS= sqlcipher-[0-9]*
Lines 25-36 CFLAGS+= -Os Link Here
25		25
26	MAKE_JOBS_UNSAFE= yes	26	MAKE_JOBS_UNSAFE= yes
27		27
28	# Compilation Options For SQLite http://www.sqlite.org/compile.html	28	# Compilation Options For SQLite https://www.sqlite.org/compile.html
29	OPTIONS_DEFINE= FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \	29	OPTIONS_DEFINE= FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \
30	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \	30	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
31	EXTENSION READLINE ARMOR STMT DBSTAT FTS5 JSON1 RBU	31	EXTENSION ARMOR STMT DBSTAT FTS5 JSON1 RBU \
		32	LIKENOTBLOB STSHELL
32	OPTIONS_SINGLE= RAMT	33	OPTIONS_SINGLE= RAMT
33	OPTIONS_RADIO= STAT	34	OPTIONS_RADIO= STAT RL
34	OPTIONS_GROUP= UNICODE RTREEG	35	OPTIONS_GROUP= UNICODE RTREEG
35		36
36	UPD_DEL_LIMIT_DESC= ORDER BY and LIMIT on UPDATE and DELETE	37	UPD_DEL_LIMIT_DESC= ORDER BY and LIMIT on UPDATE and DELETE
Lines 43-68 MEMMAN_DESC= Allows it to release unuse Link Here
43	SECURE_DELETE_DESC= Overwrite deleted information with zeros	44	SECURE_DELETE_DESC= Overwrite deleted information with zeros
44	UNLOCK_NOTIFY_DESC= Enable notification on unlocking	45	UNLOCK_NOTIFY_DESC= Enable notification on unlocking
45	EXTENSION_DESC= Allow loadable extensions	46	EXTENSION_DESC= Allow loadable extensions
		47	STSHELL_DESC= Statically link libsqlite3 into shell
46		48
47	# http://www.sqlite.org/compile.html#enable_api_armor	49	# https://sqlite.org/compile.html#like_doesnt_match_blobs
		50	LIKENOTBLOB_DESC= LIKE does not match blobs
		51
		52	# https://www.sqlite.org/compile.html#enable_api_armor
48	ARMOR_DESC= Detect misuse of the API	53	ARMOR_DESC= Detect misuse of the API
49		54
50	# http://www.sqlite.org/fts3.html	55	# https://www.sqlite.org/fts3.html
		56	# https://www.sqlite.org/compile.html#enable_fts3_parenthesis
51	FTS4_DESC= Enable FTS3/4 (Full Text Search) module	57	FTS4_DESC= Enable FTS3/4 (Full Text Search) module
52		58
53	# http://www.sqlite.org/fts5.html	59	# https://www.sqlite.org/fts5.html
54	FTS5_DESC= Enable version 5 full-text search engine	60	FTS5_DESC= Enable version 5 full-text search engine
55		61
56	# http://www.sqlite.org/json1.html	62	# https://www.sqlite.org/json1.html
57	JSON1_DESC= Enable the JSON1 extension	63	JSON1_DESC= Enable the JSON1 extension
58		64
59	# http://www.sqlite.org/rbu.html	65	# https://www.sqlite.org/rbu.html
60	RBU_DESC= Enable the Resumable Bulk Update	66	RBU_DESC= Enable the Resumable Bulk Update
61		67
62	# http://www.sqlite.org/c3ref/stmt_scanstatus.html	68	# https://www.sqlite.org/c3ref/stmt_scanstatus.html
63	STMT_DESC= Prepared Statement Scan Status	69	STMT_DESC= Prepared Statement Scan Status
64		70
65	# http://www.sqlite.org/tempfiles.html#tempstore	71	# https://www.sqlite.org/tempfiles.html#tempstore
66	OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3	72	OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3
67	RAMT_DESC= Where to store temporary file	73	RAMT_DESC= Where to store temporary file
68	TS0_DESC= Always use temporary file	74	TS0_DESC= Always use temporary file
Lines 70-97 TS1_DESC= File by default, change allow Link Here
70	TS2_DESC= Memory by default, change allowed PRAGMA	76	TS2_DESC= Memory by default, change allowed PRAGMA
71	TS3_DESC= Always use memory	77	TS3_DESC= Always use memory
72		78
73	# http://www.sqlite.org/queryplanner-ng.html#qpstab	79	# https://www.sqlite.org/queryplanner-ng.html#qpstab
74	OPTIONS_RADIO_STAT= STAT3 STAT4	80	OPTIONS_RADIO_STAT= STAT3 STAT4
75	STAT_DESC= Which query planner to use	81	STAT_DESC= Which query planner to use, Stability or ...
76	STAT3_DESC= collect histogram data from leftmost column	82	STAT3_DESC= collect histogram data from leftmost column
77	STAT4_DESC= collect histogram data from all columns	83	STAT4_DESC= collect histogram data from all columns
78		84
79	# http://www.sqlite.org/dbstat.html	85	# https://www.sqlite.org/dbstat.html
80	DBSTAT_DESC= Enable DBSTAT Virtual Table	86	DBSTAT_DESC= Enable DBSTAT Virtual Table
81		87
82	# http://www.sqlite.org/fts3.html#tokenizer	88	# https://www.sqlite.org/fts3.html#tokenizer
83	OPTIONS_GROUP_UNICODE= ICU UNICODE61	89	OPTIONS_GROUP_UNICODE= ICU UNICODE61
84	UNICODE_DESC= Unicode support	90	UNICODE_DESC= Unicode support
85	UNICODE61_DESC= Unicode Version 6.1 tokenizer	91	UNICODE61_DESC= Unicode Version 6.1 tokenizer
86		92
87	# http://www.sqlite.org/rtree.html	93	# https://www.sqlite.org/rtree.html
88	OPTIONS_GROUP_RTREEG= RTREE RTREE_INT	94	OPTIONS_GROUP_RTREEG= RTREE RTREE_INT
89	RTREEG_DESC= Index type for range queries	95	RTREEG_DESC= Index type for range queries
90	RTREE_DESC= Enable R*Tree module	96	RTREE_DESC= Enable R*Tree module
91	RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates	97	RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates
92		98
		99	OPTIONS_RADIO_RL= READLINES READLINEP EDITLINE
		100	RL_DESC= What is the command line editing is used:
		101	READLINES_DESC= the libreadline from system
		102	READLINEP_DESC= the GNU libreadline from ports
		103	EDITLINE_DESC= the BSD libedit from ports
		104
93	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \	105	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
94	EXTENSION TS1 UNICODE61 RTREE READLINE DBSTAT	106	EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL
95	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.	107	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
96	# RTREE used by graphics/mapnik, databases/spatialite	108	# RTREE used by graphics/mapnik, databases/spatialite
97		109
Lines 107-118 PLIST_FILES= bin/sqlite3 include/sqlite3 Link Here
107	CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}	119	CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
108	.endif	120	.endif
109		121
110	# This macro sets the default size of the page-cache for temporary files
111	# created by SQLite to store intermediate results, in pages.
112	.ifdef TEMP_CACHE_SIZE
113	CPPFLAGS+= -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=${TEMP_CACHE_SIZE}
114	.endif
115
116	# Use an in-ram database for temporary tables (never,no,yes,always),	122	# Use an in-ram database for temporary tables (never,no,yes,always),
117	TS0_CPPFLAGS= -DSQLITE_TEMP_STORE=0	123	TS0_CPPFLAGS= -DSQLITE_TEMP_STORE=0
118	TS1_CPPFLAGS= -DSQLITE_TEMP_STORE=1	124	TS1_CPPFLAGS= -DSQLITE_TEMP_STORE=1
Lines 122-128 TS3_CPPFLAGS= -DSQLITE_TEMP_STORE=3 Link Here
122	RTREE_CPPFLAGS= -DSQLITE_ENABLE_RTREE=1	128	RTREE_CPPFLAGS= -DSQLITE_ENABLE_RTREE=1
123	RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1	129	RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1
124		130
125	FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1	131	FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
126	SOUNDEX_CPPFLAGS= -DSQLITE_SOUNDEX=1	132	SOUNDEX_CPPFLAGS= -DSQLITE_SOUNDEX=1
127	MEMMAN_CPPFLAGS= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1	133	MEMMAN_CPPFLAGS= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1
128	UPD_DEL_LIMIT_CPPFLAGS= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1	134	UPD_DEL_LIMIT_CPPFLAGS= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1
Lines 150-157 ICU_LDFLAGS= `${LOCALBASE}/bin/icu-confi Link Here
150		156
151	UNICODE61_CPPFLAGS_OFF= -DSQLITE_DISABLE_FTS3_UNICODE=1	157	UNICODE61_CPPFLAGS_OFF= -DSQLITE_DISABLE_FTS3_UNICODE=1
152		158
153	READLINE_CONFIGURE_ENABLE= readline	159	READLINES_CONFIGURE_ON= --enable-readline
154	READLINE_USES= readline	160	READLINES_USES= readline
		161	READLINEP_CONFIGURE_ON= --enable-readline
		162	READLINEP_USES= readline:port
		163	EDITLINE_CONFIGURE_ENABLE= editline
		164	EDITLINE_USES= libedit
155		165
156	FTS5_CONFIGURE_ENABLE= fts5	166	FTS5_CONFIGURE_ENABLE= fts5
157		167
Lines 159-164 JSON1_CONFIGURE_ENABLE= json1 Link Here
159		169
160	RBU_CPPFLAGS= -DSQLITE_ENABLE_RBU=1	170	RBU_CPPFLAGS= -DSQLITE_ENABLE_RBU=1
161		171
		172	LIKENOTBLOB_CPPFLAGS= -DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1
		173
		174	STSHELL_CONFIGURE_ENABLE= static-shell
		175
162	.include <bsd.port.options.mk>	176	.include <bsd.port.options.mk>
163		177
164	post-configure:	178	post-configure: