Easton Harvey
easton.harvey@faircom.com
Articles by Easton
-
-
Working with Unicode
191 views Updated May 29th, 2026 -
mtPro
173 views Updated May 19th, 2026 -
Working with Records
336 views Updated May 29th, 2026 -
Data change message in FairCom DB Notify
JSON format of data change messages
260 views Updated June 12th, 2026 -
Error codes 4000 - 4199
FairCom DB error codes 4000 - 4199
291 views Updated May 20th, 2026 -
FairCom Typographical Conventions
184 views Updated May 14th, 2026 -
CTCurrency Class
107 views Updated May 28th, 2026 -
CTBlob Class
118 views Updated May 27th, 2026 -
Working with Databases
328 views Updated May 27th, 2026 -
ACE API concepts
FairCom's ACE APIs provide low-level control over all aspects of data processing in order to build solutions that are unrivaled in capability and performance.
1089 views Updated June 24th, 2026 -
Working with Sessions
282 views Updated May 29th, 2026 -
CTBase Class
128 views Updated May 29th, 2026 -
c-treeDB API Definitions
235 views Updated May 29th, 2026 -
Use TLS with FairCom's ISAM, CTDB, and SQL client drivers
FairCom client driver settings to connect securely to FairCom's ISAM, CTDB, and SQL APIs
290 views Updated June 12th, 2026 -
CTFullTextIndexDictionary Class
170 views Updated May 29th, 2026 -
CTDate Class
115 views Updated May 29th, 2026 -
JavaScript transform tutorials
Tutorials for the JavaScript transform method
243 views Updated March 10th, 2026 -
CTTable Class
191 views Updated May 29th, 2026 -
CTBigint Class
120 views Updated May 27th, 2026 -
CTSegment Class
111 views Updated May 29th, 2026 -
CTDatabase Class
149 views Updated May 29th, 2026 -
CTDateTime Class
114 views Updated May 29th, 2026 -
Compatibility with other c-tree API Technologies
209 views Updated May 29th, 2026 -
CTResource Class
123 views Updated May 29th, 2026 -
CTException Class
113 views Updated May 28th, 2026 -
CTNumber Class
114 views Updated May 28th, 2026 -
FairCom DB Architectural Concepts
182 views Updated May 14th, 2026 -
CTFullTextIndex Class
203 views Updated May 29th, 2026 -
Troubleshooting and Debugging
510 views Updated June 2nd, 2026 -
FairCom DB API, ISAM, and Low-Level Integration
119 views Updated May 29th, 2026 -
Working with Tables
419 views Updated May 27th, 2026 -
Function Name Cross Reference
237 views Updated June 2nd, 2026 -
Operating System Specific Tips
275 views Updated June 2nd, 2026 -
Monitoring Performance
318 views Updated June 1st, 2026 -
CTIndex Class
119 views Updated May 29th, 2026 -
FairCom Server DLL
175 views Updated May 19th, 2026 -
CTField Class
187 views Updated May 29th, 2026 -
FairCom JDBC overview
159 views Updated May 19th, 2026 -
CTMoney Class
110 views Updated May 28th, 2026 -
CTRecord Class
230 views Updated May 29th, 2026 -
Configuration and Tuning
286 views Updated June 1st, 2026 -
CTString Class
113 views Updated May 28th, 2026 -
OLTP Solutions
192 views Updated May 14th, 2026 -
Helpful Examples
258 views Updated June 1st, 2026 -
Fields to JSON API reference
API reference for the fields/table to JSON transform method
270 views Updated June 9th, 2026 -
JSON to different table API reference
API reference for the JSON to different table transform method
279 views Updated June 9th, 2026 -
Best Practices
322 views Updated June 1st, 2026 -
TLS in Node-RED for MQTT
Use TLS in Node-RED for MQTT
252 views Updated June 12th, 2026 -
MQTT system topics
FairCom MQ automatically publishes system messages to three topics
477 views Updated June 2nd, 2026 -
CTSession Class
112 views Updated May 29th, 2026 -
certinfo.py
Display information in a certificate file using the certinfo.py script in FairCom Certificate Manager
413 views Updated June 12th, 2026 -
FairCom DB SQL Troubleshooting
283 views Updated June 2nd, 2026 -
Tutorial: Forward to and from HiveMQ
Configure FairCom's MQTT broker to forward and subscribe to messages from a HiveMQ broker
377 views Updated June 9th, 2026 -
CTBase Class
215 views Updated May 27th, 2026 -
FairCom Java Stored Procedures - Quick Start Guide
299 views Updated May 19th, 2026 -
CTFullTextIndexDictionary Class
213 views Updated January 14th, 2026 -
Overview
FairCom DB documentation overview
436 views Updated May 13th, 2026 -
FairCom DB Full-Text Search
Fast, efficient access to textual data.
507 views Updated May 15th, 2026 -
ctrepd
Replication transaction log utility
294 views Updated June 12th, 2026 -
CTDB C tutorial
CTDB quick start tutorial for C programmers
533 views Updated June 10th, 2026 -
CTResource
190 views Updated January 14th, 2026 -
JDBC tutorial
JDBC quick start tutorial for Java programmers
821 views Updated June 10th, 2026 -
DSQL C tutorial
Direct SQL quick start tutorial for C programmers
285 views Updated June 10th, 2026 -
CLI utilities
Use TLS with FairCom's CLI utilities
391 views Updated January 20th, 2026 -
SQL for PHP PDO tutorial
SQL quick start tutorial for PHP programmers with the PDO extension
530 views Updated June 10th, 2026 -
SQLAlchemy Python tutorial
SQLAlchemy quick start tutorial for Python programmers
380 views Updated June 10th, 2026 -
FairCom SQL for PHP - Quick Start Guide
376 views Updated May 19th, 2026 -
JavaScript transform concepts
Concepts for the JavaScript transform method
227 views Updated January 14th, 2026 -
Working with Tables
312 views Updated May 29th, 2026 -
SQL connector
FairCom Edge SQL connector for databases, software, and ETL tools
275 views Updated January 28th, 2026 -
Error codes 17100 - 17199
FairCom SQL error codes 17100 - 17199
211 views Updated January 16th, 2026 -
HA, DR, and Scalability Tutorials
Tutorials for High Availability, Disaster Recovery, and Scalability
286 views Updated October 17th, 2025 -
Allen-Bradley connector
Connect FairCom Edge to Allen-Bradley devices using EtherNet/IP and PCCC over DF1 protocols
255 views Updated October 9th, 2025 -
CTFullTextIndex Class
185 views Updated May 27th, 2026 -
FairCom MQ Tutorials
FairCom MQ tutorials for software developers
262 views Updated February 5th, 2026 -
Import a CA certificate into MacOS
Import a CA certificate into the MacOS KeyChain Access application
400 views Updated June 12th, 2026 -
Data Types
334 views Updated May 29th, 2026 -
CTTable Class
215 views Updated May 27th, 2026 -
Error codes 200 - 399: internal errors
FairCom DB error codes 200 - 399: internal errors
260 views Updated January 16th, 2026 -
Error codes 400 - 499
FairCom DB error codes 400 - 499
282 views Updated February 9th, 2026 -
Event streaming concepts
Concepts for event streaming and messaging with the MQ API
258 views Updated June 9th, 2026 -
MQ Explorer
MQ Explorer UI tutorials
307 views Updated June 15th, 2026 -
CTField Class
208 views Updated January 14th, 2026 -
Concepts
340 views Updated June 12th, 2026 -
Troubleshoot the replication agent
Fix common issues with the data replication agent
312 views Updated February 11th, 2026 -
Startup configuration
Enable the FairCom Siemens S7 connector service (plugin)
373 views Updated October 10th, 2025 -
Error codes 17700 - 17799
FairCom SQL error codes 17700 - 17799
217 views Updated January 16th, 2026 -
Error codes 600 - 799
FairCom DB error codes 600 - 799
279 views Updated February 9th, 2026 -
Selectively return JSON properties
Selectively return JSON properties in the JSON DB
256 views Updated June 9th, 2026 -
FairCom Edge Node-RED concepts
Connect FairCom Edge to Node-RED to deliver data to protocols not supported by Node-RED
391 views Updated October 10th, 2025 -
ThingWorx connector
Connect FairCom Edge to ThingWorx for codeless querying
247 views Updated January 28th, 2026 -
CTBlob Class
205 views Updated May 27th, 2026 -
Data Explorer SQL tutorials
SQL tutorials for FairCom DB
269 views Updated June 10th, 2026 -
FairCom Edge tutorials
Tutorials for FairCom Edge
523 views Updated July 9th, 2026 -
REST startup configuration
Enable the connection between REST and FairCom Edge
420 views Updated October 10th, 2025 -
REST API Support for Auto-Purge
337 views Updated January 14th, 2026 -
Error codes 13000 - 13999
FairCom SQL error codes 13000 - 13999
224 views Updated January 16th, 2026 -
FairCom DB Notify tutorial
FairCom DB Notify and FairCom MQ non-secure and secure communications - tutorial
356 views Updated June 12th, 2026 -
Working with Resources
220 views Updated December 17th, 2025 -
TLS in Python for JSON DB API
Use TLS in Python for JSON DB API
418 views Updated June 12th, 2026 -
"options" (instance)
The options property can change the behavior of the current replutil run
255 views Updated June 12th, 2026 -
Use cases
Use cases for the JSON to fields transform method
243 views Updated October 12th, 2025 -
"engine"
The engine object contains actions that can be used to interact with the database engines managed by the specified replication instance
277 views Updated June 12th, 2026 -
Import a certificate into Windows
Import a CA certificate into the certificate keystore of a Windows machine
416 views Updated June 12th, 2026 -
TLS in Python for MQTT
Use TLS in Python for MQTT
397 views Updated June 12th, 2026 -
Use cases
Use cases for the table to JSON transform method
237 views Updated October 12th, 2025 -
"publication"
The publication object is used to create, delete, and list publications
246 views Updated June 12th, 2026 -
Working With Sessions
316 views Updated May 27th, 2026 -
Common Functionality
212 views Updated May 29th, 2026 -
Enable server-side TLS logging
Enable server-side TLS logging for the FairCom wire protocols
374 views Updated January 20th, 2026 -
Configuring data aggregation
Configure data to aggregate automatically
266 views Updated June 10th, 2026 -
FairCom DB API, ISAM, and Low-Level Integration
215 views Updated December 18th, 2025 -
Selectively return fields
Selectively return fields in the JSON DB
241 views Updated June 9th, 2026 -
Installation
605 views Updated February 23rd, 2026 -
Working with Databases
293 views Updated May 29th, 2026 -
Error codes 500 - 599
FairCom DB error codes 500 - 599
277 views Updated February 9th, 2026 -
Configure the replication agent
Use ctreplagent.cfg to configure FairCom's replication agent
328 views Updated June 12th, 2026 -
Replication agent
Manually configure data replication between FairCom servers using Replication Agent
363 views Updated June 12th, 2026 -
CTException Class
196 views Updated January 14th, 2026 -
Class CTBigint
198 views Updated January 14th, 2026 -
CTDateTime Class
196 views Updated May 27th, 2026 -
JSON types
JSON types for FairCom DB
433 views Updated June 9th, 2026 -
Using Auto-Purge
Purge data automatically to avoid storage issues
240 views Updated June 10th, 2026 -
Error codes 12000 - 12999
FairCom SQL error codes 12000 - 12999
249 views Updated May 27th, 2026 -
Replication network recommendations
Network and port standards for data replication
270 views Updated February 11th, 2026 -
Data Integrity
289 views Updated May 27th, 2026 -
CTCurrency Class
200 views Updated January 14th, 2026 -
"options"
This options property applies to a specific target
252 views Updated June 15th, 2026 -
"manager"
The manager property contains operations that can be used to interact with the replication manager options and information
258 views Updated June 12th, 2026 -
HA, DR, and Scalability concepts
Remain available during system outages using High Availability, Disaster Recovery, and Scalability
539 views Updated January 16th, 2026 -
Low Level Development Concepts
226 views Updated December 9th, 2025 -
createclientcert.py
Create a client certificate using the createclientcert.py script in FairCom Certificate Manager
483 views Updated June 12th, 2026 -
Variant concepts
Concepts about the variant data type and object
249 views Updated June 9th, 2026 -
Enable client certificate authentication
Enable client certificate authentication on a FairCom server
381 views Updated February 10th, 2026 -
Concepts
Concepts for certificate management
515 views Updated June 12th, 2026 -
Working with Multiple Files (FILESET)
299 views Updated May 22nd, 2026 -
Use cases (JSON to table transform)
Use cases for the JSON to different table transform method
243 views Updated March 13th, 2026 -
Error codes 17600 - 17699
FairCom SQL error codes 17600 - 17699
225 views Updated January 16th, 2026 -
Connect client software to FairCom's JSON and MQTT APIs
Use TLS to connect client software to FairCom's JSON and MQTT APIs
383 views Updated May 13th, 2026 -
Determine TLS connections
Determine TLS connections in FairCom's CLI utilities and Monitor App
379 views Updated January 20th, 2026 -
More information about upgrading
241 views Updated June 10th, 2026 -
Error codes 0 - 199
FairCom DB error codes 0 - 199
692 views Updated February 9th, 2026 -
Working With Records
299 views Updated May 27th, 2026 -
setuptls.py
Use setuptls.py to complete all setup steps to active TLS secure communications
278 views Updated June 12th, 2026 -
Replication Agent loses connection
How to recover Replication Agent connection to FairCom DB servers
271 views Updated June 15th, 2026 -
Common Functionality
220 views Updated May 27th, 2026 -
c-treeDB C API Definitions
440 views Updated May 22nd, 2026 -
AWS IoT Core bridge tutorials
Connect FairCom Edge to AWS IoT Core bridge
269 views Updated June 8th, 2026 -
Tutorial: MQTT client for Node.js
Use the Node.js MQTT client with FairCom's MQTT broker engine
444 views Updated June 9th, 2026 -
CTString Class
211 views Updated May 28th, 2026 -
JSON API connector concepts
294 views Updated January 28th, 2026 -
TLS for JSON APIs, MQTT, and browser-based apps
Configure a FairCom server to use TLS for JSON APIs, MQTT, and browser-based apps
405 views Updated June 12th, 2026 -
TLS Concepts
Overview of TLS concepts and how they apply to FairCom products
330 views Updated June 12th, 2026 -
SIMPLE tokenizer
Example SQL full-text searches using SIMPLE tokenizer
244 views Updated January 14th, 2026 -
Errors
List of FairCom error codes for all FairCom products
793 views Updated February 9th, 2026 -
renewcerts.py
Renew certificates that are about to expire using the renewcerts.py script in FairCom Certificate Manager
412 views Updated June 12th, 2026 -
CTIndex Class
209 views Updated May 27th, 2026 -
Simple Replication Agent tutorial
Simple tutorial to replicate data between two FairCom servers running on the same computer
327 views Updated April 10th, 2026 -
Error codes 17500 - 17599
FairCom SQL error codes 17500 - 17599
224 views Updated January 16th, 2026 -
Count and paginate records
JSON DB API: Count and paginate records
304 views Updated June 10th, 2026 -
Number types
Number types
244 views Updated June 9th, 2026 -
CTMoney Class
209 views Updated January 14th, 2026 -
Error codes 22000 - 23999
FairCom SQL error codes 22000 - 23999
226 views Updated January 16th, 2026 -
Modbus emulator
The Modbus Emulator software simulates running a machine communicating over the Modbus protocol
396 views Updated April 15th, 2026 -
MQTT connector
Use FairCom Edge as an MQTT connector to deliver device data to MQTT clients, other MQTT brokers, and other messaging systems, such as AMQP brokers, Kafka, IBM MQ, etc.
491 views Updated January 28th, 2026 -
Date & Time types
JSON DB date and time types use ISO 8601 and ISO 8604 format while FairCom's other APIs use other conventions
231 views Updated June 9th, 2026 -
Tutorial: MQTT client for C
Use the C MQTT client with FairCom's MQTT broker engine
389 views Updated June 9th, 2026 -
Data Integrity
309 views Updated May 29th, 2026 -
REST connector
Connect FairCom Edge to enterprise APIs by posting JSON to REST services.
243 views Updated June 8th, 2026 -
Tutorial: MQTT client for Java
Use the Java MQTT client with FairCom's MQTT broker engine
538 views Updated June 9th, 2026 -
OPC UA tutorials
FairCom Edge tutorials detailing ways to interact with an OPC UA simulator
403 views Updated April 15th, 2026 -
Transform methods
FairCom Edge transform method documentation for developers to transform, enrich, and reshape incoming data before FairCom Edge delivers it to devices and software
259 views Updated June 9th, 2026 -
Node-RED tutorials
Node-RED tutorials for FairCom DB
260 views Updated June 9th, 2026 -
CTSegment Class
193 views Updated May 27th, 2026 -
Configuration
ThingWorx configuration for FairCom Edge
413 views Updated June 8th, 2026 -
Error codes 20000 - 20399
FairCom SQL error codes 20000 - 20399
270 views Updated May 13th, 2026 -
Use transactions
Use transactions in JSON DB
408 views Updated June 9th, 2026 -
SQL Python tutorial
SQL quick start tutorial for Python programmers
547 views Updated June 10th, 2026 -
Working with Sessions
433 views Updated May 27th, 2026 -
Compatibility
301 views Updated December 23rd, 2025 -
CTRecord Class
292 views Updated May 27th, 2026 -
FairCom MQ overview
FairCom MQ documentation home
417 views Updated February 5th, 2026 -
FairCom ISAM
FairCom ISAM documentation home
331 views Updated April 15th, 2026 -
Broker forwarding
Forward MQTT messages from FairCom MQ to another messaging system, such as MQTT Brokers, AMQP Brokers, Kafka, AWS IoT Core, Microsoft Azure IoT Hub, and IBM MQ
338 views Updated February 5th, 2026 -
FairCom Edge Overview
FairCom Edge documentation home
467 views Updated January 28th, 2026 -
TLS in Java for MQTT
Use TLS in Java for MQTT
389 views Updated June 12th, 2026 -
JSON DB API tutorials
Tutorials for the JSON DB API using the athlete table in the API Explorer user interface
332 views Updated June 10th, 2026 -
JSON DB API tutorial
FairCom's JSON DB API can be used to query MQTT data captured from IoT devices
400 views Updated June 8th, 2026 -
FairCom DB API .NET Definitions
306 views Updated May 27th, 2026 -
Upgrade notes for developers
498 views Updated June 10th, 2026 -
"group"
The replication "group" object manages availability groups
263 views Updated June 15th, 2026 -
Manage certificate warnings in Google Chrome
Manage certificate security warnings in Google Chrome
554 views Updated June 12th, 2026 -
Data aggregation tutorials
Tutorials for automatic data aggregation
235 views Updated February 2nd, 2026 -
Concepts (Fields to JSON transform)
Concepts for the table to JSON transform method
236 views Updated March 13th, 2026 -
Programmer's Reference Overview
337 views Updated May 27th, 2026 -
Configure TLS for a server
Configure a FairCom server to use a TLS server certificate
494 views Updated June 12th, 2026 -
JavaScript Transform tutorial
Use the "integrationTableTransform" code package to transform data as it comes into the database
405 views Updated June 8th, 2026 -
Concepts (JSON to table transform)
Concepts for using the JSON to different table transform method
241 views Updated March 13th, 2026 -
Error codes 14000 - 14999
FairCom Plugin error codes 14000 - 14999
234 views Updated January 16th, 2026 -
Compatibility with other c-tree API Technologies
196 views Updated December 18th, 2025 -
Data Explorer
Data Explorer UI tutorials
480 views Updated February 11th, 2026 -
FairCom DB Notify Concepts
FairCom DB Notify Concepts
296 views Updated June 12th, 2026 -
HA, DR, and Scalability use cases
Data replication delivers data to multiple servers for high availability, read scalability, and disaster recovery
326 views Updated June 12th, 2026 -
Error codes 10000 - 11999
FairCom SQL error codes 10000 - 11999
279 views Updated January 16th, 2026 -
Error codes 15000 - 15999
FairCom Flatfile error codes 15000 - 15999
218 views Updated January 16th, 2026 -
CTTime Class
191 views Updated May 27th, 2026 -
Error codes 26000 - 50999
FairCom SQL error codes 26000 - 50999
217 views Updated January 16th, 2026 -
Connection and startup issues
Troubleshoot common problems with data replication connection and startup
284 views Updated February 11th, 2026 -
Tutorial: MQTT client for Python
Use the Python MQTT client with FairCom's MQTT broker engine
613 views Updated June 9th, 2026 -
Error codes 1000 - 1299
FairCom DB error codes 1000 - 1299
270 views Updated January 16th, 2026 -
Configure TLS ciphers
Configure a FairCom server to use specific Transport Layer Security ciphers
273 views Updated June 12th, 2026 -
FairCom RTG COBOL User Guide
459 views Updated April 8th, 2026 -
SDKs
List of FairCom DB software development kits organized by programming language, including tutorials, guides, client libraries, and drivers
374 views Updated June 10th, 2026 -
ThingWorx tutorials
ThingWorx connector tutorials for FairCom Edge
458 views Updated June 8th, 2026 -
MTConnect Tutorials
FairCom Edge tutorials for Windows detailing ways to interact with an MTConnect simulator
259 views Updated October 10th, 2025 -
createcacert.py
Create a Certificate Authority certificate using the createcacert.py script in FairCom Certificate Manager
440 views Updated June 12th, 2026 -
Error codes 21000 - 21999
FairCom SQL error codes 21000 - 21999
225 views Updated January 16th, 2026 -
MQTT concepts
MQTT concepts for developers and administrators
572 views Updated February 5th, 2026 -
Replication C++ tutorial
Replication quick start tutorial for C++ programmers
426 views Updated June 10th, 2026 -
FairCom ISAM User Guide
342 views Updated April 15th, 2026 -
Error codes 7000 - 7499
FairCom DB error codes 7000 - 7499
243 views Updated January 16th, 2026 -
Startup configuration
Enable the FairCom EtherNet/IP connector service (plugin)
421 views Updated April 1st, 2026 -
Certificate Manager
FairCom Certificate Manager is a scripting solution that manages a company's internal certificates
451 views Updated May 13th, 2026 -
Overview
423 views Updated May 27th, 2026 -
Administration
FairCom MQ admin home page with links to server admin tasks
397 views Updated April 14th, 2026 -
CTDatabase Class
204 views Updated May 27th, 2026 -
Chrome certificate peculiarities
284 views Updated May 13th, 2026 -
Import a CA certificate into OS
Import CA certificates into an OS keystore
405 views Updated January 20th, 2026 -
C API to customize replication
C API to extend the FairCom replication agent to detect conflicts, transform replicated data, filter replicated data, and deliver data to other systems
406 views Updated June 12th, 2026 -
Modbus connector
Connect FairCom Edge to Modbus devices
346 views Updated April 15th, 2026 -
Replication agent extension tutorial
Tutorial for extending the replication agent to log replication events
281 views Updated February 11th, 2026 -
Modbus Tutorials
Modbus tutorials for FairCom Edge
281 views Updated April 15th, 2026 -
Negative error codes
FairCom DB negative error codes
269 views Updated January 16th, 2026 -
Linux Pacemaker replication tutorial
Build a Highly Available Cluster on Linux for FairCom DB
489 views Updated June 12th, 2026 -
JavaScript transform use cases
Use cases for the JavaScript transform method
244 views Updated January 14th, 2026 -
Connectors
The FairCom Edge connector documentation for software developers to collect tags from devices and send data to devices and software.
559 views Updated June 8th, 2026 -
Use table filters
Use the table filters with JSON DB
410 views Updated June 9th, 2026 -
TLS with ISQL
Use TLS with ISQL
377 views Updated January 20th, 2026 -
CTDate Class
200 views Updated May 27th, 2026 -
JSON DB API tutorial
Use the FairCom Java driver for the JSON DB API to process data in the FairCom database engine
467 views Updated June 9th, 2026 -
Client certificate authentication on ISAM API
Use client certificate authentication with FairCom's ISAM API
378 views Updated January 20th, 2026 -
Binary types
Binary types
219 views Updated June 9th, 2026 -
FairCom RTG overview
FairCom RTG documentation home
342 views Updated April 15th, 2026 -
Configure TLS for ISAM and SQL APIs
Configure a FairCom server to use TLS for ISAM and SQL APIs
383 views Updated May 13th, 2026 -
REST API for Automatic System Time
293 views Updated October 15th, 2025 -
Edge Explorer
Use Edge Explorer to visually navigate your Edge information
312 views Updated February 11th, 2026 -
Concepts (JSON to fields transform)
Concepts for the JSON to fields transform method
245 views Updated March 13th, 2026 -
Client authentication in a CLI tool
Use client authentication in a FairCom CLI tool
381 views Updated May 13th, 2026 -
Working with Unicode
317 views Updated May 22nd, 2026 -
Error codes 25000 - 25999
FairCom SQL error codes 25000 - 25999
217 views Updated January 16th, 2026 -
Let existing ISAM applications co-exist with SQL
411 views Updated June 10th, 2026 -
Node-RED connector
FairCom Edge Node-RED connector
299 views Updated January 28th, 2026 -
Orphaned Replication Agent
Correctly terminate orphaned Replication Agent source and target server connections
282 views Updated February 11th, 2026 -
Boolean type
Boolean type
229 views Updated June 9th, 2026 -
Steps to upgrade FairCom server
393 views Updated June 10th, 2026 -
CTNumber Class
208 views Updated January 14th, 2026 -
Modbus startup configuration
214 views Updated January 13th, 2026 -
Create a server certificate
Create a server key and server certificate
419 views Updated June 12th, 2026 -
TLS in Browser-based apps running in Google Chrome
Use TLS with FairCom's browser-based apps running in Google Chrome
383 views Updated June 12th, 2026 -
Configure connection
Configure the connection from FairCom DB Notify to FairCom MQ using the /config/dbnotifyconnections.json file.
272 views Updated February 11th, 2026 -
Manage data using Node.js
Manage data using Node.js and the JSON DB API tutorial
368 views Updated June 9th, 2026 -
"plan"
The plan object specifies actions performed within replication plans
247 views Updated June 15th, 2026 -
Working with Multi-Record Virtual Tables
441 views Updated May 22nd, 2026 -
OPC UA connector
Connect FairCom Edge to OPC UA devices
234 views Updated April 15th, 2026 -
Data Types
340 views Updated May 22nd, 2026 -
Overview
228 views Updated May 27th, 2026 -
Error codes 800 - 999
FairCom DB error codes 800 - 999
266 views Updated June 24th, 2026 -
Variant data type tutorials
Use the following tutorials to use the variant data type effectively
233 views Updated June 9th, 2026 -
Tutorials
Siemens S7 connector tutorials
297 views Updated April 15th, 2026 -
Concepts
Concepts about the FairCom database engine
566 views Updated June 10th, 2026 -
ISQL tutorial
FairCom Interactive SQL - quick start tutorial
441 views Updated June 10th, 2026 -
Security terms
Explanations of Transport Layer Security (TLS) terminology and concepts
721 views Updated June 11th, 2026 -
cttctx
Performance test utility
288 views Updated February 11th, 2026 -
Siemens S7 connector
Connect FairCom Edge to Siemens PLCs and devices using the Siemens S7 protocol
339 views Updated April 15th, 2026 -
Error codes 17001 - 17099
FairCom SQL error codes 17001 - 17099
228 views Updated January 16th, 2026 -
FairCom DB API .NET Error and Return Values
220 views Updated January 13th, 2026 -
Most effective ways to return data from the JSON DB API
How best to return query results one page at a time or all at once
475 views Updated June 9th, 2026 -
Certificate best practices for FairCom customers
311 views Updated June 12th, 2026 -
JSON to fields API reference
API reference for the JSON to fields transform method
282 views Updated June 9th, 2026 -
Set maximum active partitions for auto-purge
289 views Updated June 10th, 2026 -
Using automatic timestamps
Track timestamps automatically using Automatic System Time
250 views Updated June 10th, 2026 -
Configure tables for FairCom DB Notify
Configure tables to track data changes
429 views Updated June 12th, 2026 -
Tutorial: Forward to and from Mosquitto
Configure FairCom's MQTT broker to forward and subscribe to messages from a Mosquitto broker
371 views Updated June 9th, 2026 -
Error codes 17900 - 17999
FairCom SQL error codes 17900 - 17999
212 views Updated January 16th, 2026 -
AWS IoT Core Concepts
1086 views Updated June 30th, 2026 -
Implementation
Implement the FairCom Edge API actions for REST connectors
265 views Updated June 8th, 2026 -
Tutorial: Secure FairCom's MQTT broker with client certificates
Configure FairCom servers to use secure MQTT connections with CA, server, and client certificates
389 views Updated June 9th, 2026 -
Advanced Configuration
566 views Updated June 5th, 2026 -
SQL connector concepts
SQL connector concepts for FairCom Edge
409 views Updated January 14th, 2026 -
JSON API connector
Connect FairCom Edge to JSON API
282 views Updated January 28th, 2026 -
repadm
Replication Agent administrator utility
344 views Updated June 12th, 2026 -
Monitor
FairCom's Monitor UI can be used to view configurations, performance statistics, and monitor live data.
319 views Updated February 11th, 2026 -
Administration
FairCom Edge administration home page contains links to server administration tasks
654 views Updated May 12th, 2026 -
importcert.py
Register a CA certificate with an operating system using the importcert.py script in FairCom Certificate Manager
460 views Updated June 12th, 2026 -
CTSession Class
282 views Updated May 27th, 2026 -
Error codes 17300 - 17499
FairCom SQL error codes 17300 - 17499
215 views Updated January 16th, 2026 -
Startup configuration
Configure the FairCom OPC UA service plugin
393 views Updated January 14th, 2026 -
Data Types
305 views Updated February 26th, 2026 -
Node-RED tutorials
Node-RED tutorials for FairCom Edge
417 views Updated June 8th, 2026 -
Upgrade notes for administrators
264 views Updated June 10th, 2026 -
Data Integrity
352 views Updated May 22nd, 2026 -
ThingWorx Concepts
409 views Updated June 8th, 2026 -
Security administration utility
Use sa_admin to manage users, groups, and file permissions
287 views Updated June 12th, 2026 -
Data types
Field types for FairCom DB
540 views Updated June 9th, 2026 -
Import a certificate into Linux
Import a CA certificate into the certificate keystore of a Linux machine
382 views Updated June 12th, 2026 -
Troubleshoot FairCom DB Notify
Use CTSTATUS.FCS to troubleshoot FairCom DB Notify
274 views Updated October 17th, 2025 -
Working with Resources
204 views Updated May 29th, 2026 -
ISAM C tutorial
ISAM quick start tutorial for C programmers
538 views Updated June 10th, 2026 -
CTTime Class
204 views Updated May 29th, 2026 -
Transform method concepts
FairCom Edge data transformation concepts that make factory data more useful
265 views Updated October 11th, 2025 -
Record lock error
Retries and diagnostics for record lock error
316 views Updated February 11th, 2026 -
Working with Callbacks
304 views Updated May 22nd, 2026 -
DIAGNOSTICS REPLICATE
Use DIAGNOSTICS REPLICATE to identify replication failures
264 views Updated February 11th, 2026 -
Query techniques
Concepts for the JSON DB get data actions
418 views Updated June 9th, 2026 -
JSON DB concepts
Using the JSON DB API in applications, web services, and automation scripts
319 views Updated February 4th, 2026 -
PORTER English stemming tokenizer
Example SQL full-text searches using PORTER English stemming tokenizer
240 views Updated January 14th, 2026 -
C support for partitions and auto-purge
286 views Updated June 10th, 2026 -
Working With Tables
311 views Updated May 27th, 2026 -
Error codes 18000 - 18999
FairCom SQL error codes 18000 - 18999
233 views Updated January 16th, 2026 -
Error codes 16000 - 16999
FairCom SQL error codes 16000 - 16999
470 views Updated November 16th, 2025 -
Enable client-side TLS logging
Enable client-side TLS logging for applications using mtclient
370 views Updated January 20th, 2026 -
Converting DB V4.1F-V4.3C applications
244 views Updated June 10th, 2026 -
Use client authentication in client software
Use client authentication in client software
391 views Updated June 12th, 2026 -
API Explorer
API Explorer UI tutorials
559 views Updated June 15th, 2026 -
RTG and ISAM errors
FairCom RTG and ISAM error codes
258 views Updated November 17th, 2025 -
FairCom DB Error Code Reference
255 views Updated May 27th, 2026 -
SQL Tutorials
SQL for databases and ETL tools tutorials
388 views Updated January 28th, 2026 -
MTConnect connector
Connect FairCom Edge to MTConnect agents
222 views Updated April 15th, 2026 -
TLS in Java for JSON DB API
Use TLS in Java for JSON DB API
461 views Updated June 12th, 2026 -
Differentiating features
FairCom MQ features that differentiate it from other MQTT brokers
227 views Updated October 12th, 2025 -
Working With Databases
210 views Updated December 24th, 2025 -
PAGE_SIZE conversions
322 views Updated June 10th, 2026 -
Working with Records
333 views Updated June 11th, 2026 -
Edge releases & breaking changes
Explore FairCom Edge releases, featuring enhancements and new capabilities.
399 views Updated June 4th, 2026 -
Replication Agent errors
Troubleshoot Replication Agent exceptions and errors
363 views Updated June 15th, 2026 -
Variant type
438 views Updated June 9th, 2026 -
"getRecordsTransform" code package
Transform data as it is read from the database
419 views Updated June 9th, 2026 -
String types
String types
230 views Updated June 9th, 2026 -
API quick start tutorials
Tutorials to help developers quickly start using FairCom APIs
445 views Updated February 9th, 2026 -
Object owner
439 views Updated June 9th, 2026 -
FairCom Edge concepts
FairCom Edge's architecture and internals described for engineers
454 views Updated October 10th, 2025 -
JSON DB Python tutorial
JSON DB API quick start tutorial for Python programmers
402 views Updated June 10th, 2026 -
Error codes 10000 - 50999
FairCom other error codes 10000 - 50999
294 views Updated January 16th, 2026 -
Sort results
Sort results in the JSON DB
239 views Updated February 4th, 2026 -
Error codes 17800 - 17899
FairCom SQL error codes 17800 - 17899
222 views Updated January 16th, 2026 -
Athlete tutorial
Explore the JSON DB API using the Data Explorer and API Explorer web apps
478 views Updated June 10th, 2026 -
ODBC tutorial
ODBC quick start tutorial for C programmers
628 views Updated June 10th, 2026 -
SQL APIs
List of FairCom SQL APIs and guides for developers, programming languages, and environments
468 views Updated June 10th, 2026 -
FairCom DB API for C Overview
294 views Updated May 27th, 2026 -
Working With Resources
215 views Updated December 23rd, 2025 -
TLS Tutorials
499 views Updated June 12th, 2026