Changes 3.8.6:
Added support for hexadecimal integer literals in the SQL parser. (Ex: 0x123abc)
Enhanced the PRAGMA integrity_check command to detect UNIQUE and NOT NULL constraint violations.
Increase the maximum value of SQLITE_MAX_ATTACHED from 62 to 125.
Increase the timeout in WAL mode before issuing an SQLITE_PROTOCOL error from 1 second to 10 seconds.
Added the likely(X) SQL function.
The unicode61 tokenizer is now included in FTS4 by default.
Trigger automatic reprepares on all prepared statements when ANALYZE is run.
Added a new loadable extension source code file to the source tree: fileio.c
Add extension functions readfile(X) and writefile(X,Y) (using code copy/pasted from fileio.c in the previous bullet) to the command-line shell.
Added the .fullschema dot-command to the command-line shell.

Performance Enhancements:
-------------------------
Deactivate the DISTINCT keyword on subqueries on the right-hand side of the IN operator.
Add the capability of evaluating an IN operator as a sequence of comparisons as an alternative to using a table lookup. Use the sequence of comparisons implementation in circumstances where it is likely to be faster, such as when the right-hand side of the IN operator is small and/or changes frequently.
The query planner now uses sqlite_stat4 information (created by ANALYZE) to help determine if the skip-scan optimization is appropriate.
Ensure that the query planner never tries to use a self-made transient index in place of a schema-defined index.
Other minor tweaks to improve the quality of VDBE code.

Bug Fixes:
----------
Fix a bug in CREATE UNIQUE INDEX, introduced when WITHOUT ROWID support added in version 3.8.2, that allows a non-unique NOT NULL column to be given a UNIQUE index.
Fix a bug in R-Tree extension, introduced in the previous release, that can cause an incorrect results for queries that use the rowid of the R-Tree on the left-hand side of an IN operator.
Fix the sqlite3_stmt_busy() interface so that it gives the correct answer for ROLLBACK statements that have been stepped but never reset.
Fix a bug in that would cause a null pointer to be dereferenced if a column with a DEFAULT that is an aggregate function tried to usee its DEFAULT.
CSV output from the command-line shell now always uses CRNL for the row separator and avoids inserting CR in front of NLs contained in data.
Fix a column affinity problem with the IN operator.
Fix the ANALYZE command so that it adds correct samples for WITHOUT ROWID tables in the sqlite_stat4 table.
Changes 4.84:
TL/01 Bugzilla 1506: Re-add a 'return NULL' to silence complaints from static
      checkers that were complaining about end of non-void function with no
      return.

JH/01 Bug 1513: Fix parsing of quoted parameter values in MIME headers.
      This was a regression intruduced in 4.83 by another bugfix.

JH/02 Fix broken compilation when EXPERIMENTAL_DSN is enabled.

TL/02 Bug 1509: Fix exipick for enhanced spoolfile specification used when
      EXPERIMENTAL_DNS is enabled.
Don't use "/bin/ksh" as wrapper shell under Mac OS X Mavericks.
It frequently crashes, at least if you use parallel builds.
Security update to version 3.9.2

Changes:

* Fixes a possible denial of service issue in PHP’s XML processing, reported by
  Nir Goldshlager of the Salesforce.com Product Security Team. Fixed by Michael
  Adams and Andrew Nacin of the WordPress security team and David Rothstein of
  the Drupal security team.
* Fixes a possible but unlikely code execution when processing widgets
  (WordPress is not affected by default), discovered by Alex Concha of the
  WordPress security team.
* Prevents information disclosure via XML entity attacks in the external GetID3
  library, reported by Ivan Novikov of ONSec.
* Adds protections against brute attacks against CSRF tokens, reported by David
  Tomaschik of the Google Security Team.
* Contains some additional security hardening, like preventing cross-site
  scripting that could be triggered only by administrators.
Note update of www/wordpress
Changes 2.1.0:
Incompatible changes:
---------------------
The 82573L NIC was incorrectly treated as an 8254xx model. It no longer works correctly on either Linux (3.14.*) or Windows 7 and has been removed.
On x86, migration from QEMU 1.7 to QEMU 2.0 was broken if the guest had PCI bridges or for some number of CPUs (12, 13, 14, 54, 55, 56, 97, 98, 99, 139, 140) are the only ones). QEMU 2.1 fixes this, so that migration from QEMU 1.7 to QEMU 2.1 should always work. However, the fix breaks the following scenarios instead:
migration from QEMU 2.0 to QEMU 2.1 with PCI bridges and machine types pc-i440fx-1.7/pc-i440fx-2.0
migration from QEMU 2.0 to QEMU 2.1 with the aforementioned number of CPUs and machine type pc-i440fx-1.7

Future incompatible changes:
----------------------------
Three options are using different names on the command line and in configuration file. In particular:
The "acpi" configuration file section matches command-line option "acpitable";
The "boot-opts" configuration file section matches command-line option "boot";
The "smp-opts" configuration file section matches command-line option "smp".
Starting with QEMU xyz.jkl, -readconfig will standardize on the name for the command line option.

ARM
---
Firmware can be passed to the vexpress machine via -bios.
Improvements to Allwinner SoC emulation.
AArch64 TCG system emulation support.
AArch64 SHA and Crypto instruction support.

LM32
----
Support for semihosting.

Microblaze
----------
Support for u-boot initrd images.

MIPS
----
Support for KVM in the Malta board.

more...
Updated databases/sqlite3 to 3.8.6; mail/exim to 4.84; emulators/qemu to 2.1.0
Changes 1.7.76:
Updated libpng to version 1.6.12.
Updated graphics/pngcrush to 1.7.76
Fix SDL_LoadObject to try the soname itself first, without any prefixes,
and only fallback to other places when that fails.
Bump PKGREVISION.
Updated devel/SDL to 1.2.15nb12
File to centralise common definitions for OCaml packages. Not yet used at
the moment, but I will start slowly converting packages.
Update to 0.9.21:

Tux Paint 0.9.21 features nearly two dozen new Magic tools, as well
as updates to old favorites. Many of these were developed by six
students from around the globe during Google's 2008 Summer of Code
program, under the mentorship of Tux Paint developers.

Exciting new Magic tools include intelligent train tracks that
automatically connect when their paths cross, a realistic rainbow
tool, a fisheye lens effect, edge and silhouette tracing tools,
various string art effects, and a tool to fold the edges of your
drawing up from the corners. There is also a brush that paints with
'toothpaste', and others that paint with confetti, rain, snowballs,
and snowflakes! Additionally, many classic Magic tools (like Blur
and Tint) can now affect the entire drawing, instead of just a
selected area.

Coloring-book style Starter Images are now easier to make. Images
with transparency (alpha channel) are still supported, but
additionally, if no transparent layer is found, Tux Paint will
assume that white is the background color. This means you can now
draw or scan any simple black-and-white image and use it as a Tux
Paint Starter Image!

New in Tux Paint 0.9.21, the Text tool now supports bidirectional
languages like Hebrew and Arabic, thanks to the FriBidi library.
Tux Paint has also been translated to two new languages, Shuswap
and Songhay, and many other translations have been updated.

On Linux, environment variables (like "$HOME") may now be used when
setting directories for saving images or finding data files.

And of course, Tux Paint 0.9.21 incorporates a number of minor
improvements and bug fixes requested by the Tux Paint community.
For example, Tux Paint no longer drops out of fullscreen mode in
Windows if the [Windows] key is pressed (XP, 2000 and Vista only),
and it brings up an error window if it fails to print.
Updated graphics/tuxpaint to 0.9.21
Import Moos-0.29 as devel/p5-Moos.

Moos completes the M to Moose sequence of Perl OO modules.

This one is pure Perl, single file and mostly Moose compatible(for
what it does). Moos has no non-core dependencies, but certain
features (roles, debugging functions, legacy Perl support) do
require additional modules. If you steer away from those features,
you don't need those additional modules.
Add p5-Moos
Added devel/p5-Moos version 0.29
Disable emacs detection by default.
Add notmuch emacs option that pulls in emacs and installs compiled lisp
files as well.

Based on a similar patch by J. Lewis Muir on pkgsrc-users.

Bump PKGREVISION.
Updated mail/notmuch to 0.18.1nb1
Describe notmuch-emacs option.