[ANNOUNCEMENT] Updated: sqlite3-3.8.1-1 for Cygwin/Cygwin64

Jan Nijtmans jan.nijtmans@gmail.com
Mon Nov 18 15:02:00 GMT 2013

SQLite is a software library that implements a self-contained,
serverless, zero-configuration, transactional SQL database engine

Changes since 3.7.17-3
* Updated to upstream 3.8.1 release. Main new features:
  * Partial indexes: <http://www.sqlite.org/partialindex.html>
  * New query planner: <http://www.sqlite.org/queryplanner-ng.html>
* 3 new VFS's:
   "win32"  Old win32 implementation, which limits file
                  paths to 160 chars. Don't use it.
   "win32-longpath" New win32 implementation, implemented
                  by SQLite dll. Not very well tested (on Cygwin).
   "winnt": The same behavior as "win32-longpath", but implemented
                  by cygwin1.dll
* The "unix" VFS (the default) is rewritten following the SQLite
   programming conventions. It should behave exactly the same
   as the default "unix" VFS in SQLite 3.7.17-3:
   The environment variable CYGWIN_SQLITE_LOCKING can be used
   to specify which file locking is desired, "posix", "bsd", "dotfile"
or "winnt".
  The default is "winnt".
* The dll is no longer built with SQLITE_TEMP_STORE=2, which was
   a workaround for a SQLite bug. This bug should be fixed now.

If your queries are slower than before (however unlikely), see:

Jan Nijtmans

More information about the Cygwin-announce mailing list