New version of Red Database 2.5

Red Soft Corporation is pleased to announce the Red Database 2.5.0.10582.
You can download community edition here.
The most interesting changes are:

  1. New built-in functions:
    • CREATE_FILE - create file from BLOB;
    • READ_FILE   - create BLOB from file;
    • REGEXP_SUBSTR - substring search using regular expression;
    • CPU_LOAD - measurement of average CPU load for specified period of time;
    • LDAP_ATTR - a read of speified attribute of a current user from LDAP catalog.
  2. New context variables which are assigned to attributes of a user from LDAP.
  3. Some improvements in full text search engine.
  4. Added trace filter by user and client process and registering security incidents in operating system logs.
  5. Improved multifactor authentication:
    • support of security connection in JDBC;
    • a possibility to use trusted connection on the server.
  6. Lock table handling optimization.
  7. Port to Solaris SPARC.
  8. Config option "OptimizationStrategy" and syntax extention SELECT: OPTIMIZE FOR {FIRST | ALL} ROWS.
  9. Improved Nbackup utility:
    • speed up of incremental backup creation by using reading only headers of pages while searching changes;
    • a possibility to create incremental backup by using GUID;
    • a possibility to apply incremental backup on existing database.
  10. Support of synchronous replication of changes to one or several slave servers which allow to setup StandBy mode work.