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 FairCom RTG 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 FairCom RTG V3 Copyright Notice Index