FairCom DB V12 Updates

 
Welcome to FairCom DB V12
FairCom DB V12 Highlights
Go Bigger
Millions of Records per Transaction
Millions of Open Files
128 TB SQL Temp Tables
4GB Transaction Log Space
64K SQL CHAR Fields
2500 Columns per Table
Go Faster
Up to 3x Faster Overall Performance
Up to 4X Faster Indexes with Smaller Indexes Using Variable-Length Compressed Key Storage
Option to Automatically Enable c-tree Key Compression When Creating an Index
c-treeDB API Compression
ISAM API Compression
Utilities to Confirm Index Compression Modes
Faster Indexing from Locking, Node Pruning, and Sorting Optimizations
Up to 15 Percent Faster with Increased Default Index Page Size
More Batch Operations Improve Network Traversal Performance
Field Mask Support Added to c-treeDB
Parallel Data Processing Scales Performance
Faster File Open and Close under High Concurrency
Improved Performance Reassigning Transaction-Controlled File's ID
Windows File System Compression Support
Faster Connections and App Communication
More Concurrency with Less Lock Contention
OpenSSL Now Provides Default Faster AES Encryption
Experience Extreme Speed with an In-Process Database
SQL
Dynamically "SQLize" ISAM and COBOL Files
Auto Import Callback
Auto Import: Tables that are missing on disk will now be Auto Purged
Preserve Imported Data Files upon SQL DROP
Identify "Bad" Records from Legacy Data Linked to SQL
FairCom DB SQL Import and c-treeRTG Sqlize No Longer Require Exclusive Access to Tables
Run a SQL Query across Multiple Databases
Parameter Marks Now Available in Scalar Functions and CASE Statements
Assign Values to Auto-Increment Fields in INSERT
Insert Multiple Value Sets
Insert Statements with Scalar Values and Subqueries Now Supported
Use Row Value Constructors with Comparisons in Query
Easier Full-Text Search (FTS) MATCH Operator Syntax
Diagnostic Logging Now in Enhanced JSON Format
Extensive SQL Statement Logging for Auditing
SYSLOG SQL_STATEMENTS Configuration Keyword
LVARCHAR Fields Allowed in Stored Procedure Code
Throw Custom Error Message on Stored Procedure or UDF Exception
Dynamically Disable Triggers
Goal: Zero Administration
Browser-Based Web Tools
Automatic System Timestamps
Automatic Data Aggregation
Automatic Data Purging
Automatically Alert on Low Disk Space
Automatic Sizing and Purging of Log Files
Diagnose Easier
Track I/O Statistics per Connection
File Operations Counters
Debug Heap Options for Detection of Memory Corruption
Backup and Restore
Back Up Direct to STDOUT and Gain OS Compression and Encryption Support (ctdump)
Restore Backups Direct from STDIN (ctrdmp)
Wildcards Exclude and Include Files in Backups
Dynamic Dump Script !DELAY Option Allows Abandoning Dump
Faster Restores from Large Backups
High Availability (Beta)
Synchronous Replication for High Availability
Client Failover Notifications
Data Replication
Advanced Replication Keeps Your Data World in Sync
Dynamically Set Replication Node ID (REPL_NODEID) at Runtime
Enhanced Security
OpenSSL Now Provides Default Faster AES Encryption
Master Key Storage Integration with Amazon AWS Secrets Manager
Support for Using AWS Secrets Manager as External Encryption key Store
DLL for FairCom Server to Access AWS Secrets Manager
Visual Prompt Utility for AWS Credentials
Encrypted Data Master Key Library
Ability to Validate against Advanced Encryption Master Password
Automatically Enforce Password Strength
SYSLOG Recording of SQL User Logon and Logoff Events
Function to Return User Account and Password Expiration Times
Read-Only Server - Perfect for Reporting and Several HA (High Availability) and DR (Disaster Recovery) Scenarios
Advanced SSL Certificate Options
OpenSSL Support is Now Extended to Linux Platforms
Perform LDAP_GROUP_CHECK in Context of LDAP Application ID if Specified
LDAP Authentication Diagnostic Logging
.NET FairCom.Isam Updated for Security Features
V12 Changes
Develop Easier
100+ New and Enhanced Development Features
New and Enhanced APIs and Drivers
JSON
Query JSON from SQL
Use JSON in Your c-treeDB Applications
Using JSON Data Types in Your ISAM Applications
JSON Data Type Support
JSON Supported in REST API
MQTT Persistence API Can Map Nested JSON Structures to Multiple Tables
REST API
REST API Support for Auto-Purge
REST API autosystemtime for Automatic System Time
MQTT
MQTT Using Auto Timestamp
MQTT - Option for Replication Enable/Disable
Node.js
Automatic System Time Field Definition
Python
JDBC Conformance Updated to JDBC 4.3
PHP PDO SSL Security Added
ODBC
Millisecond Timestamps
High-Resolution Timestamp Support Added
Millisecond Time Format Added as hh:mm:ss:ttt
Store UTF-8 in String Types
Use Plug-ins and Run Anything Server-Side
c-tree Server Can Load Plug-In On-Demand after Server Has Started
Web Plug-In - Default linked_ace_server
Tag, Find, Move, and Cache Data Files More Easily
c-treeDB Database Dictionary Support for Table Marks
ctdbMoveTable() Function to Rename Table and Change Path
c-treeDB - Added Support for Session and Database Dictionary in Regular, Non-Superfiles
Allow Opening a Data File Even if its Record Update Callback Resource DLL Cannot Be Loaded
Process All Files Forward and Backward
New APIs to Control Replication
ISAM Lock Functions Exposed in Java and .Net
New Platforms
Functions
c-treeDB Functions
ISAM Functions
Low-Level Functions
System Functions
SQL Functions
Direct SQL Functions
Configuration
New ctsrvr.cfg Location and Default Additions
Server Configuration Defaults - PAGE_SIZE 32768 and LOG_SPACE 1 GB
Core
SQL
COMPATIBILITY
DIAGNOSTIC
Utilities
Data Replication
Backup and Restore
Data and Index File Management
Caching
Security
Logging and Recovery
SQL Import
Diagnostic Session Recording
FairComConfig Utility Moved
Callbacks for Custom Behaviors
Upgrading and Application Building
Steps to Upgrade FairCom Server
Compiling Your Application
Increased PAGE_SIZE for Improved Performance
Upgrade & Compatibility
V12 Changes
Compatibility Notes
Upgrade and New Default Folder Layout
ctsrvr.cfg Moved to New config Folder
Increased PAGE_SIZE for Improved Performance
Support Opening More Than 32,767 Files Affects Compatibility
Max Replication and Deferred Index Logs Raised
Improved IFIL Path Handling
Configuration Option to Disable IFIL Path Improvements
Programming Option to Disable IFIL Path Improvements
Shared Memory Performance Enhancement for all Unix Platforms
Increased Log Space Requirements
Deprecated FairCom DB Configurations
Sort Module Error Code Changes
Default to IPv6 in Windows when TCP/IP is Selected
ctsqlGet*() Returns CTSQL_NULLRESULT when a NULL Value Is Present
SQL Stored Procedures - Close cursors that were left open
Better Error Reporting when Exceeding the Maximum Length of VARCHAR Fields
Disk Full Monitoring Keywords Added to Default ctsrvr.cfg
SQL Statement Diagnostic Logging Keyword Added to Default Server Config
Updated ctMAX_KEY_SEG Default from 16 to 32
MAX_REPL_LOGS and MAX_DFRIDX_LOGS Default Values Increased to 100
Windows Drive-Relative Paths Deprecated
Ports
More FairCom Products
FairCom Edge V3
c-treeRTG V3
Copyright Notice
Index