diff options
author | adam <adam> | 2017-02-13 17:44:01 +0000 |
---|---|---|
committer | adam <adam> | 2017-02-13 17:44:01 +0000 |
commit | 87821c2935d3c12945355ee6cd6ddb1eecaccec0 (patch) | |
tree | 1606866592c6d05a1d6aac5447dae18befc69bc0 /databases/sqlite3 | |
parent | 59d742cb786862b134528fe93f633ae7200eb046 (diff) | |
download | pkgsrc-87821c2935d3c12945355ee6cd6ddb1eecaccec0.tar.gz |
SQLite Release 3.17.0 On 2017-02-13
* Approximately 25% better performance from the R-Tree extension.
* Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for byteswapping when available.
* Uses the sqlite3_blob key/value access object instead of SQL for pulling content out of R-Tree nodes
* Other miscellaneous enhancements such as loop unrolling.
* Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
* Increase the default lookaside size from 512,125 to 1200,100 as this provides better performance while only adding 56KB of extra memory per connection. Memory-sensitive applications can restore the old default at compile-time, start-time, or run-time.
* Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and __builtin_mul_overflow() when available. (All compiler built-ins can be omitted with the SQLITE_DISABLE_INTRINSIC compile-time option.)
* Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in significantly smaller database files for some applications, at the risk of being incompatible with older versions of SQLite.
* Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance.
* Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE.
* Perform some UPDATE operations in a single pass instead of in two passes.
* Enhance the session extension to support WITHOUT ROWID tables.
* Fixed performance problems and potential stack overflows when creating views from multi-row VALUES clauses with hundreds of thousands of rows.
* Added the sha1.c extension.
* In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl".
* Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as long as the pages being read are not in the WAL file.
* Enhance the LEMON parser generator so that it can store the parser object as a stack variable rather than allocating space from the heap and make use of that enhancement in the amalgamation.
* Other performance improvements. Uses about 6.5% fewer CPU cycles.
Bug Fixes:
* Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN into an INNER JOIN.
* Use the correct affinity for columns of automatic indexes.
* Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows.
Diffstat (limited to 'databases/sqlite3')
-rw-r--r-- | databases/sqlite3/Makefile | 4 | ||||
-rw-r--r-- | databases/sqlite3/Makefile.common | 4 | ||||
-rw-r--r-- | databases/sqlite3/Makefile.version | 6 | ||||
-rw-r--r-- | databases/sqlite3/distinfo | 10 |
4 files changed, 12 insertions, 12 deletions
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile index 6f54e6bf47e..62489b62ec8 100644 --- a/databases/sqlite3/Makefile +++ b/databases/sqlite3/Makefile @@ -1,6 +1,4 @@ -# $NetBSD: Makefile,v 1.113 2017/01/02 17:52:23 adam Exp $ -# -# used by databases/sqlite3-tcl/Makefile +# $NetBSD: Makefile,v 1.114 2017/02/13 17:44:01 adam Exp $ .include "Makefile.common" diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common index be99a4de646..096ec610f24 100644 --- a/databases/sqlite3/Makefile.common +++ b/databases/sqlite3/Makefile.common @@ -1,4 +1,6 @@ -# $NetBSD: Makefile.common,v 1.50 2016/10/22 00:18:39 kamil Exp $ +# $NetBSD: Makefile.common,v 1.51 2017/02/13 17:44:01 adam Exp $ +# +# used by databases/sqlite3-tcl/Makefile DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION} diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version index 1f7a44b90c7..25addc2d027 100644 --- a/databases/sqlite3/Makefile.version +++ b/databases/sqlite3/Makefile.version @@ -1,12 +1,12 @@ -# $NetBSD: Makefile.version,v 1.29 2017/01/19 18:52:05 agc Exp $ +# $NetBSD: Makefile.version,v 1.30 2017/02/13 17:44:01 adam Exp $ # # used by databases/sqlite3/Makefile # used by databases/sqlite3-docs/Makefile # used by databases/sqlite3-tcl/Makefile # used by devel/lemon/Makefile -SQLITE3_DISTVERSION= 3160200 -SQLITE3_VERSION= 3.16.2 +SQLITE3_DISTVERSION= 3170000 +SQLITE3_VERSION= 3.17.0 MASTER_SITES= http://www.hwaci.com/sw/sqlite/2017/ MASTER_SITES+= http://www.sqlite.org/2017/ diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo index 5c831cbc917..5b712a03130 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.131 2017/01/07 10:23:00 adam Exp $ +$NetBSD: distinfo,v 1.132 2017/02/13 17:44:01 adam Exp $ -SHA1 (sqlite-autoconf-3160200.tar.gz) = 64ca578ad44a94115b1db0406740e14288f74bb8 -RMD160 (sqlite-autoconf-3160200.tar.gz) = 86b351cfa4321a857fe6987694e188655226951f -SHA512 (sqlite-autoconf-3160200.tar.gz) = 83bdd588504f265bbe93fb98a33a292aff5618c14f94d521c8557efbb5f777e82dfbb2d186cbfd4c628ee9522b1fcb73857e24ca2318fa34af3a3f9540e72b9a -Size (sqlite-autoconf-3160200.tar.gz) = 2508179 bytes +SHA1 (sqlite-autoconf-3170000.tar.gz) = 7bcff1c158ed9e2c0e159c1b4b6c36d4d65dff8c +RMD160 (sqlite-autoconf-3170000.tar.gz) = c198f8c3f91894ba017b7e71a9d6e5c31a9ef12c +SHA512 (sqlite-autoconf-3170000.tar.gz) = bebf2693ade1c99b6a178bbe663f64911bf7751932a2524506994cbbb19ab254e7febe3693a76084e55853c1ea85db9e4ece87192422583555fbe569915a2ca8 +Size (sqlite-autoconf-3170000.tar.gz) = 2515143 bytes |