diff -urNd databases/sqlite3.orig/Makefile databases/sqlite3/Makefile
--- databases/sqlite3.orig/Makefile	2018-06-11 08:49:26.747632000 +0000
+++ databases/sqlite3/Makefile	2018-06-11 10:45:04.374545000 +0000
@@ -2,7 +2,7 @@
 # $FreeBSD: head/databases/sqlite3/Makefile 468935 2018-05-03 15:59:50Z joneum $
 
 PORTNAME=	sqlite3
-DISTVERSION=	3.23.1
+DISTVERSION=	3.24.0
 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
@@ -23,7 +23,7 @@
 OPTIONS_DEFINE=		FTS4 UPD_DEL_LIMIT URI URI_AUTHORITY METADATA \
 			DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
 			EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \
-			LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL
+			LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF
 OPTIONS_SINGLE=		RAMT
 OPTIONS_RADIO=		STAT
 OPTIONS_GROUP=		OPT_EXT OPT_FUNC UNICODE RTREEG RL
@@ -86,6 +86,9 @@
 # https://www.sqlite.org/c3ref/stmt_scanstatus.html
 STMT_DESC=		Prepared statement scan status
 
+# 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
 OPTIONS_SINGLE_RAMT=	TS0 TS1 TS2 TS3
 RAMT_DESC=		Where to store temporary file
@@ -216,6 +219,8 @@
 
 SER1_CPPFLAGS=	-DSQLITE_ENABLE_DESERIALIZE=1
 
+SORT_REF_CPPFLAGS=	-DSQLITE_ENABLE_SORTER_REFERENCES=1
+
 .include <bsd.port.options.mk>
 
 # Platform Configuration
diff -urNd databases/sqlite3.orig/distinfo databases/sqlite3/distinfo
--- databases/sqlite3.orig/distinfo	2018-06-11 08:49:26.747630000 +0000
+++ databases/sqlite3/distinfo	2018-06-11 08:53:12.257176000 +0000
@@ -1,3 +1,3 @@
-TIMESTAMP = 1525362811
-SHA256 (sqlite-autoconf-3230100.tar.gz) = 92842b283e5e744eff5da29ed3c69391de7368fccc4d0ee6bf62490ce555ef25
-SIZE (sqlite-autoconf-3230100.tar.gz) = 2675362
+TIMESTAMP = 1528707168
+SHA256 (sqlite-autoconf-3240000.tar.gz) = d9d14e88c6fb6d68de9ca0d1f9797477d82fc3aed613558f87ffbdbbc5ceb74a
+SIZE (sqlite-autoconf-3240000.tar.gz) = 2699252