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