Dear MySQL users,
MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI. This release, v8.0.8, is the second development release of the
MySQL Connector/Node.js 8.0 series.
The X DevAPI enables application developers to write code that combines
the strengths of the relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.
MySQL Connector/Node.js can be downloaded through npm (see
https://www.npmjs.com/package/@mysql/xdevapi for details) or from
https://dev.mysql.com/downloads/connector/nodejs/.
To learn more about how to write applications using the X DevAPI, see
http://dev.mysql.com/doc/x-devapi-userguide/en/. For more information
about how the X DevAPI is implemented in MySQL Connector/Node.js, and
its usage, see http://dev.mysql.com/doc/dev/connector-nodejs/.
Please note that the X DevAPI requires at least MySQL Server version
5.7.12 or higher with the X Plugin enabled. For general documentation
about how to get started using MySQL as a document store, see
http://dev.mysql.com/doc/refman/5.7/en/document-store.html.
Changes in MySQL Connector/Node.js 8.0.8 (2017-09-28,
Development Milestone)
Functionality Added or Changed
* The following Collection methods were added:
replaceOne(), addOrReplaceOne(), getOne(), removeOne().
For details, see Tutorial: Working with Documents
(http://dev.mysql.com/doc/dev/connector-nodejs/tutorial-Working_with_Documents.html).
* Added row locking support by adding the lockExclusive()
and lockShared() methods to the CollectionFind and
TableSelect classes. For additional information, see
Tutorial: Row Locking
(http://dev.mysql.com/doc/dev/connector-nodejs/tutorial-Row_locking.html).
* Extended Authentication support, including SHA-256. For
additional information, see Tutorial: Secure Sessions
(http://dev.mysql.com/doc/dev/connector-nodejs/tutorial-Secure_Sessions.html).
* Added "contains" operator support for objects and arrays.
This allows additional types of expressions such as IN
[x, y, z] and IN { "x": "foo", "y": "bar" }, and also
referencing field names that map to arrays and objects,
such as someArray IN $.field and someObject IN $.field.
Bugs Fixed
* Added support for the parentheses-based IN syntax, such
as IN (x, y, z, ...), as defined in the X DevAPI. (Bug
#26666817)
Enjoy and thanks for the support!