Ann: NexusDB Significant Update Info and New Licenses SALE

Ann: NexusDB Significant Update Info and New Licenses SALE
==================================================

Greetings from the NexusDB Team!

We have just released v4.13, and would like to take a moment to mention some important new features in our database products. For purchase of new licenses, please see the offer towards the end.

The SQL engine has been enhanced with:

The SIMILAR predicate, which introduces Regular Expression matching using the PCRE syntax! You can now do RegEx searches against any string expression (including [N]CLOBs). Example:

SELECT Title FROM Movies WHERE Title SIMILAR TO '.{lord|wars}.' IGNORE CASE

The OVERLAY string function, allowing replacing parts of a string with another, in place. Example:

SELECT OVERLAY(Title PLACING '- overwritten -' FROM LEFT 5 TO RIGHT 5 FROM Movies

The new OVERLAY string function also supports using SIMILAR in order to use RegEx matching to determine parts to be replaced. Example:

SELECT OVERLAY(Title PLACING '---' SIMILAR TO '.{lord|wars}.' IGNORE CASE) FROM Movies

The OVERLAY syntax has also been extended to allow replace operations on parts of datetime values. Example:

SELECT OVERLAY(Birthday PLACING 2017 IN YEAR) AS This_Years_Birthdays FROM Friends

The EXTRACT datetime expression now supports extracting datetime value parts according to ISO standard 8601.


The Enterprise Manager has had a number of bug fixes applied, as has other parts of our product. The full list of changes can be found at

https://www.nexusdb.com/mantis/changelog_page.php


New Licenses SALE:
===============

From now and until the end of November, take 20% off new licenses in our web shop!

Make sure to enter NEWNOV2017 in the coupon code field when ordering products to apply the rebate.

Webshop here:

https://www.nexusdb.com/support/index.php?q=pricing

Our site: https://www.nexusdb.com


Regards,
Eivind Bakkestuen
NexusQA Pty Ltd



https://www.nexusdb.com