Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

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



Permlink Replies: 0 Threads: [ Previous | Next ]
Eivind Bakkestuen


Posts: 447
Registered: 5/8/01
Ann: NexusDB Significant Update Info and New Licenses SALE
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 22, 2017 10:55 PM
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,
The NexusDB Team

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02