| 1 |
|
# $MidnightBSD$ |
| 2 |
|
|
| 3 |
|
PORTNAME= sqlite3 |
| 4 |
< |
PORTVERSION= 3.8.7 |
| 4 |
> |
PORTVERSION= 3.9.1 |
| 5 |
|
CATEGORIES= databases |
| 6 |
< |
MASTER_SITES= http://www.sqlite.org/2014/ http://www2.sqlite.org/2014/ http://www3.sqlite.org/2014/ |
| 7 |
< |
DISTNAME= sqlite-autoconf-3080700 |
| 6 |
> |
MASTER_SITES= https://www.sqlite.org/2015/ http://www2.sqlite.org/2015/ http://www3.sqlite.org/2015/ |
| 7 |
> |
DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00 |
| 8 |
|
|
| 9 |
|
MAINTAINER= ports@MidnightBSD.org |
| 10 |
|
COMMENT= SQL database engine in a C library |
| 13 |
|
|
| 14 |
|
CONFLICTS= sqlite34-[0-9]* sqlcipher-[0-9]* |
| 15 |
|
|
| 16 |
< |
USES= pathfix pkgconfig |
| 16 |
> |
USES= pathfix pkgconfig libtool ncurses |
| 17 |
|
USE_LDCONFIG= YES |
| 18 |
|
GNU_CONFIGURE= YES |
| 19 |
+ |
INSTALL_TARGET= install-strip |
| 20 |
|
|
| 21 |
|
MAKE_JOBS_UNSAFE= yes |
| 22 |
|
|
| 23 |
|
# Compilation Options For SQLite http://www.sqlite.org/compile.html |
| 24 |
< |
OPTIONS_DEFINE= FTS3 ICU RTREE RAMTABLE UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \ |
| 25 |
< |
STAT3 DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADSAFE \ |
| 26 |
< |
EXTENSION |
| 27 |
< |
OPTIONS_DEFAULT= FTS3 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADSAFE EXTENSION |
| 28 |
< |
FTS3_DESC= Enable FTS3/4 (Full Text Search) module |
| 29 |
< |
ICU_DESC= Enable built with ICU |
| 30 |
< |
RTREE_DESC= Enable R*Tree module (${RTREE_INT}) |
| 30 |
< |
RAMTABLE_DESC= Store temporary tables in RAM = ${TEMP_STORE} |
| 24 |
> |
OPTIONS_DEFINE= FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY SOUNDEX METADATA \ |
| 25 |
> |
DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \ |
| 26 |
> |
EXTENSION READLINE ARMOR STMT DBSTAT FTS5 JSON1 RBU |
| 27 |
> |
OPTIONS_SINGLE= RAMT |
| 28 |
> |
OPTIONS_RADIO= STAT |
| 29 |
> |
OPTIONS_GROUP= UNICODE RTREEG |
| 30 |
> |
|
| 31 |
|
UPD_DEL_LIMIT_DESC= ORDER BY and LIMIT on UPDATE and DELETE |
| 32 |
|
URI_DESC= Enable use the URI filename |
| 33 |
|
URI_AUTHORITY_DESC= Allow convert URL into a UNC |
| 34 |
|
SOUNDEX_DESC= Enables the soundex() SQL function |
| 35 |
|
METADATA_DESC= Enable column metadata |
| 36 |
– |
STAT3_DESC= Help SQLite to chose a better query plan |
| 36 |
|
DIRECT_READ_DESC= File is read directly from disk |
| 37 |
|
MEMMAN_DESC= Allows it to release unused memory |
| 38 |
|
SECURE_DELETE_DESC= Overwrite deleted information with zeros |
| 39 |
|
UNLOCK_NOTIFY_DESC= Enable notification on unlocking |
| 41 |
– |
THREADSAFE_DESC= Build thread-safe library |
| 40 |
|
EXTENSION_DESC= Allow loadable extensions |
| 41 |
|
|
| 42 |
< |
.include <bsd.mport.options.mk> |
| 42 |
> |
# http://www.sqlite.org/compile.html#enable_api_armor |
| 43 |
> |
ARMOR_DESC= Detect misuse of the API |
| 44 |
|
|
| 45 |
< |
# NAME83 "Enable use 8.3 filename for temp files" off \ |
| 46 |
< |
# Some devices are compelled to use an older file system with 8+3 filename |
| 48 |
< |
# restrictions for backwards compatibility, or due to other non-technical factors. |
| 49 |
< |
# http://www.sqlite.org/shortnames.html |
| 50 |
< |
.if ${PORT_OPTIONS:MNAME83} |
| 51 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_8_3_NAMES=1 |
| 52 |
< |
.endif |
| 45 |
> |
# http://www.sqlite.org/fts3.html |
| 46 |
> |
FTS4_DESC= Enable FTS3/4 (Full Text Search) module |
| 47 |
|
|
| 48 |
+ |
# http://www.sqlite.org/fts5.html |
| 49 |
+ |
FTS5_DESC= Enable version 5 full-text search engine |
| 50 |
+ |
|
| 51 |
+ |
# http://www.sqlite.org/json1.html |
| 52 |
+ |
JSON1_DESC= Enable the JSON1 extension |
| 53 |
+ |
|
| 54 |
+ |
# http://www.sqlite.org/rbu.html |
| 55 |
+ |
RBU_DESC= Enable the Resumable Bulk Update |
| 56 |
+ |
|
| 57 |
+ |
# http://www.sqlite.org/c3ref/stmt_scanstatus.html |
| 58 |
+ |
STMT_DESC= Prepared Statement Scan Status |
| 59 |
+ |
|
| 60 |
+ |
# http://www.sqlite.org/tempfiles.html#tempstore |
| 61 |
+ |
OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3 |
| 62 |
+ |
RAMT_DESC= Where to store temporary file |
| 63 |
+ |
TS0_DESC= Always use temporary file |
| 64 |
+ |
TS1_DESC= File by default, change allowed PRAGMA |
| 65 |
+ |
TS2_DESC= Memory by default, change allowed PRAGMA |
| 66 |
+ |
TS3_DESC= Always use memory |
| 67 |
+ |
|
| 68 |
+ |
# http://www.sqlite.org/queryplanner-ng.html#qpstab |
| 69 |
+ |
OPTIONS_RADIO_STAT= STAT3 STAT4 |
| 70 |
+ |
STAT_DESC= Which query planner to use |
| 71 |
+ |
STAT3_DESC= collect histogram data from leftmost column |
| 72 |
+ |
STAT4_DESC= collect histogram data from all columns |
| 73 |
+ |
|
| 74 |
+ |
# http://www.sqlite.org/dbstat.html |
| 75 |
+ |
DBSTAT_DESC= Enable DBSTAT Virtual Table |
| 76 |
+ |
|
| 77 |
+ |
# http://www.sqlite.org/fts3.html#tokenizer |
| 78 |
+ |
OPTIONS_GROUP_UNICODE= ICU UNICODE61 |
| 79 |
+ |
UNICODE_DESC= Unicode support |
| 80 |
+ |
UNICODE61_DESC= Unicode Version 6.1 tokenizer |
| 81 |
+ |
|
| 82 |
+ |
# http://www.sqlite.org/rtree.html |
| 83 |
+ |
OPTIONS_GROUP_RTREEG= RTREE RTREE_INT |
| 84 |
+ |
RTREEG_DESC= Index type for range queries |
| 85 |
+ |
RTREE_DESC= Enable R*Tree module |
| 86 |
+ |
RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates |
| 87 |
+ |
|
| 88 |
+ |
OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \ |
| 89 |
+ |
EXTENSION TS1 UNICODE61 RTREE READLINE DBSTAT |
| 90 |
+ |
# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al. |
| 91 |
+ |
# RTREE used by graphics/mapnik, databases/spatialite |
| 92 |
+ |
|
| 93 |
+ |
PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \ |
| 94 |
+ |
lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \ |
| 95 |
+ |
lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \ |
| 96 |
+ |
man/man1/sqlite3.1.gz |
| 97 |
+ |
|
| 98 |
|
# The default numeric file permissions for newly created database files under unix. |
| 99 |
|
# If not specified, the default is 0644 which means that the files is globally |
| 100 |
|
# readable but only writable by the creator. |
| 108 |
|
CPPFLAGS+= -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=${TEMP_CACHE_SIZE} |
| 109 |
|
.endif |
| 110 |
|
|
| 111 |
< |
.if ${PORT_OPTIONS:MMEMMAN} |
| 112 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 |
| 113 |
< |
.endif |
| 111 |
> |
# Use an in-ram database for temporary tables (never,no,yes,always), |
| 112 |
> |
TS0_CPPFLAGS= -DSQLITE_TEMP_STORE=0 |
| 113 |
> |
TS1_CPPFLAGS= -DSQLITE_TEMP_STORE=1 |
| 114 |
> |
TS2_CPPFLAGS= -DSQLITE_TEMP_STORE=2 |
| 115 |
> |
TS3_CPPFLAGS= -DSQLITE_TEMP_STORE=3 |
| 116 |
|
|
| 117 |
< |
.if ${PORT_OPTIONS:MUPD_DEL_LIMIT} |
| 118 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 |
| 73 |
< |
.endif |
| 117 |
> |
RTREE_CPPFLAGS= -DSQLITE_ENABLE_RTREE=1 |
| 118 |
> |
RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1 |
| 119 |
|
|
| 120 |
< |
.if ${PORT_OPTIONS:MURI} |
| 121 |
< |
CPPFLAGS+= -DSQLITE_USE_URI=1 |
| 122 |
< |
.endif |
| 120 |
> |
FTS4_CPPFLAGS= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1 |
| 121 |
> |
SOUNDEX_CPPFLAGS= -DSQLITE_SOUNDEX=1 |
| 122 |
> |
MEMMAN_CPPFLAGS= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 |
| 123 |
> |
UPD_DEL_LIMIT_CPPFLAGS= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 |
| 124 |
> |
SECURE_DELETE_CPPFLAGS= -DSQLITE_SECURE_DELETE=1 |
| 125 |
> |
UNLOCK_NOTIFY_CPPFLAGS= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 |
| 126 |
> |
METADATA_CPPFLAGS= -DSQLITE_ENABLE_COLUMN_METADATA=1 |
| 127 |
> |
STAT3_CPPFLAGS= -DSQLITE_ENABLE_STAT3=1 |
| 128 |
> |
STAT4_CPPFLAGS= -DSQLITE_ENABLE_STAT4=1 |
| 129 |
> |
DBSTAT_CPPFLAGS= -DSQLITE_ENABLE_DBSTAT_VTAB=1 |
| 130 |
> |
URI_CPPFLAGS= -DSQLITE_USE_URI=1 |
| 131 |
> |
URI_AUTHORITY_CPPFLAGS= -DSQLITE_ALLOW_URI_AUTHORITY=1 |
| 132 |
> |
DIRECT_READ_CPPFLAGS= -DSQLITE_DIRECT_OVERFLOW_READ=1 |
| 133 |
> |
ARMOR_CPPFLAGS= -DSQLITE_ENABLE_API_ARMOR=1 |
| 134 |
> |
STMT_CPPFLAGS= -DSQLITE_ENABLE_STMT_SCANSTATUS=1 |
| 135 |
|
|
| 136 |
< |
.if ${PORT_OPTIONS:MURI_AUTHORITY} |
| 80 |
< |
CPPFLAGS+= -DSQLITE_ALLOW_URI_AUTHORITY=1 |
| 81 |
< |
.endif |
| 136 |
> |
EXTENSION_CONFIGURE_ENABLE= dynamic-extensions |
| 137 |
|
|
| 138 |
< |
.if ${PORT_OPTIONS:MSOUNDEX} |
| 139 |
< |
CPPFLAGS+= -DSQLITE_SOUNDEX=1 |
| 85 |
< |
.endif |
| 138 |
> |
THREADS_CONFIGURE_ENABLE= threadsafe |
| 139 |
> |
THREADS_LDFLAGS= -lpthread |
| 140 |
|
|
| 141 |
< |
.if ${PORT_OPTIONS:MSTAT3} |
| 142 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_STAT3=1 |
| 143 |
< |
.endif |
| 141 |
> |
ICU_BUILD_DEPENDS= ${LOCALBASE}/bin/icu-config:${PORTSDIR}/devel/icu |
| 142 |
> |
ICU_LIB_DEPENDS= libicudata.so:${PORTSDIR}/devel/icu |
| 143 |
> |
ICU_CPPFLAGS= `${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1 |
| 144 |
> |
ICU_LDFLAGS= `${LOCALBASE}/bin/icu-config --ldflags` |
| 145 |
|
|
| 146 |
< |
.if ${PORT_OPTIONS:MDIRECT_READ} |
| 92 |
< |
CPPFLAGS+= -DSQLITE_DIRECT_OVERFLOW_READ=1 |
| 93 |
< |
.endif |
| 146 |
> |
UNICODE61_CPPFLAGS_OFF= -DSQLITE_DISABLE_FTS3_UNICODE=1 |
| 147 |
|
|
| 148 |
< |
.if ${PORT_OPTIONS:MFTS3} |
| 149 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1 |
| 97 |
< |
.endif |
| 148 |
> |
READLINE_CONFIGURE_ENABLE= readline |
| 149 |
> |
READLINE_USES= readline |
| 150 |
|
|
| 151 |
< |
.if ${PORT_OPTIONS:MRTREE} |
| 100 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_RTREE=1 |
| 101 |
< |
.ifdef RTREE_INT |
| 102 |
< |
CPPFLAGS+= -DSQLITE_RTREE_INT_ONLY=1 |
| 103 |
< |
RTREE_INT= "int" |
| 104 |
< |
.else |
| 105 |
< |
RTREE_INT= "float" |
| 106 |
< |
.endif |
| 107 |
< |
.endif |
| 151 |
> |
FTS5_CONFIGURE_ENABLE= fts5 |
| 152 |
|
|
| 153 |
< |
.if ${PORT_OPTIONS:MICU} |
| 110 |
< |
BUILD_DEPENDS+= ${LOCALBASE}/bin/icu-config:${PORTSDIR}/devel/icu |
| 111 |
< |
LIB_DEPENDS+= icudata:${PORTSDIR}/devel/icu |
| 112 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_ICU=1 |
| 113 |
< |
CPPFLAGS+= `${LOCALBASE}/bin/icu-config --cppflags` |
| 114 |
< |
LDFLAGS+= `${LOCALBASE}/bin/icu-config --ldflags` |
| 115 |
< |
.endif |
| 153 |
> |
JSON1_CONFIGURE_ENABLE= json1 |
| 154 |
|
|
| 155 |
< |
# Use an in-ram database for temporary tables (never,no,yes,always), |
| 118 |
< |
# which is equivalent of TEMP_STORE=[0,1,2,3], default = 1. |
| 119 |
< |
.if ${PORT_OPTIONS:MRAMTABLE} |
| 120 |
< |
TEMP_STORE?= 2 |
| 121 |
< |
CPPFLAGS+= -DSQLITE_TEMP_STORE=${TEMP_STORE} |
| 122 |
< |
.endif |
| 155 |
> |
RBU_CPPFLAGS= -DSQLITE_ENABLE_RBU=1 |
| 156 |
|
|
| 157 |
< |
.if ${PORT_OPTIONS:MSECURE_DELETE} |
| 125 |
< |
CPPFLAGS+= -DSQLITE_SECURE_DELETE=1 |
| 126 |
< |
.endif |
| 157 |
> |
.include <bsd.mport.options.mk> |
| 158 |
|
|
| 159 |
< |
.if ${PORT_OPTIONS:MUNLOCK_NOTIFY} |
| 160 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 |
| 161 |
< |
.endif |
| 162 |
< |
|
| 163 |
< |
.if ${PORT_OPTIONS:MMETADATA} |
| 133 |
< |
CPPFLAGS+= -DSQLITE_ENABLE_COLUMN_METADATA=1 |
| 134 |
< |
.endif |
| 135 |
< |
|
| 136 |
< |
.if ${PORT_OPTIONS:MTHREADSAFE} |
| 137 |
< |
CONFIGURE_ARGS+= --enable-threadsafe |
| 138 |
< |
LDFLAGS+= ${PTHREAD_LIBS} |
| 139 |
< |
.else |
| 140 |
< |
CONFIGURE_ARGS+= --disable-threadsafe |
| 141 |
< |
.endif |
| 142 |
< |
|
| 143 |
< |
.if ${PORT_OPTIONS:MEXTENSION} |
| 144 |
< |
CONFIGURE_ARGS+= --enable-dynamic-extensions |
| 145 |
< |
.else |
| 146 |
< |
CONFIGURE_ARGS+= --disable-dynamic-extensions |
| 147 |
< |
.endif |
| 159 |
> |
post-configure: |
| 160 |
> |
@${ECHO_MSG} "===> CONFIGURE_ARGS=${CONFIGURE_ARGS}" |
| 161 |
> |
@${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}" |
| 162 |
> |
@${ECHO_MSG} "===> CFLAGS=${CFLAGS}" |
| 163 |
> |
@${ECHO_MSG} "===> LDFLAGS=${LDFLAGS}" |
| 164 |
|
|
| 165 |
|
post-build: |
| 166 |
|
.if ${ARCH}=="i386" |
