Apsw

[Source](https://github.com/rogerbinns/apsw/releases/download/3.14.1-r1/apsw-3.14.1-r1.zip) ▪ [Downloads](https://rogerbinns.github.io/apsw/download.html) ▪ [Changelogs](https://rogerbinns.github.io/apsw/changes.html) ▪ [Documentation](https://rogerbinns.github.io/apsw/)

Added SQLITE_DBSTATUS_CACHE_USED_SHARED and SQLITE_OK_LOAD_PERMANENTLY constants

[Source](https://github.com/rogerbinns/apsw/releases/download/3.13.0-r1/apsw-3.13.0-r1.zip) ▪ [Downloads](https://rogerbinns.github.io/apsw/download.html) ▪ [Changelogs](https://rogerbinns.github.io/apsw/changes.html) ▪ [Documentation](https://rogerbinns.github.io/apsw/)

Added SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION constant.

Added a pip command line in the Download page.

[Source](https://github.com/rogerbinns/apsw/releases/download/3.12.2-r1/apsw-3.12.2-r1.zip) ▪ [Downloads](https://rogerbinns.github.io/apsw/download.html) ▪ [Changelogs](https://rogerbinns.github.io/apsw/changes.html) ▪ [Documentation](https://rogerbinns.github.io/apsw/)

Call PyUnicode_READY for Python 3.3 onwards. Fixes APSW issue 208, APSW issue 132, APSW issue 168.

SQLite 3.12 completely changed the semantics of VFS.xGetLastError() in an incompatible way. This required a rewrite of the relevant C, Python and test code. If you implement or use this method then you have to rewrite your code too. Also note that running the test suite from an earlier version of APSW against this or future SQLite versions will result in consuming all memory, swap or address space (an underlying integer changed meaning).

Added SQLITE_CONFIG_STMTJRNL_SPILL and SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER constants.

Added support for SQLITE_CONFIG_STMTJRNL_SPILL in apsw.config().

[Source](https://github.com/rogerbinns/apsw/releases/download/3.11.1-r1/apsw-3.11.1-r1.zip) ▪ [Downloads](https://rogerbinns.github.io/apsw/download.html) ▪ [Changelogs](https://rogerbinns.github.io/apsw/changes.html) ▪ [Documentation](https://rogerbinns.github.io/apsw/)

setup.py attempts to use setuptools if present, before falling back to distutils. This allows setuptools only commands such as bdist_wheel to work. You can force use of distutils by setting the environment variable APSW_FORCE_DISTUTILS to any value. Note that setuptools may also affect the output file names. (APSW issue 207)

[Source](https://github.com/rogerbinns/apsw/releases/download/3.11.0-r1/apsw-3.11.0-r1.zip) ▪ [Downloads](https://rogerbinns.github.io/apsw/download.html) ▪ [Changelogs](https://rogerbinns.github.io/apsw/changes.html) ▪ [Documentation](https://rogerbinns.github.io/apsw/)

The shell dump command now outputs the page size and user version. There were both output before as comments.

Updated SQLite download logic for 2016 folder.

Updated VFS test suite due to changes in SQLite default VFS implemented methods.

Added SQLITE_INDEX_CONSTRAINT_LIKE, SQLITE_INDEX_CONSTRAINT_REGEXP, SQLITE_INDEX_CONSTRAINT_GLOB, SQLITE_IOERR_AUTH, SQLITE_FCNTL_JOURNAL_POINTER, and SQLITE_FCNTL_VFS_POINTER constants.

Allow Connection subclasses for backup api (APSW issue 199).

FTS5 and JSON1 extensions are now built by default for –enable-all-extensions. It is recommended you wait a few more releases for these extensions to mature.

Added a mapping for virtual table scan flags

Use SQLITE_ENABLE_API_ARMOR for extra error checking.

[Source](https://github.com/rogerbinns/apsw/releases/download/3.9.2-r1/apsw-3.9.2-r1.zip) ▪ [Downloads](http://rogerbinns.github.io/apsw/download.html) ▪ [Changelogs](http://rogerbinns.github.io/apsw/changes.html) ▪ [Documentation](http://rogerbinns.github.io/apsw/)

Added SQLITE_IOERR_VNODE constant.

Windows builds for Python 3.5 are now provided.