Start here
FairCom documentation home page
Welcome to the FairCom online documentation for developers. Start here for an overview of FairCom product features, capabilities, and developer tools.
FairCom Edge includes FairCom MQ and FairCom DB

c-treeRTG includes FairCom DB

Product | Description |
---|---|
FairCom DB is the FairCom database engine optimized for easy development, exceptionally low total cost of ownership, and high performance. FairCom DBprovides multiple APIs for working with data including JSON, ISAM, and record buffer APIs. | |
FairCom Edge is a low-code integration platform optimized for no-code integration of industrial IoT data. No programming is needed to automatically bridge across protocols including MQTT, Modbus, OPC UA, ThingWorx, SQL, and JSON. FairCom Edgealso converts binary and tabular data to and from JSON. It reshapes and enriches JSON and delivers data to and from the edge to the cloud. | |
FairCom MQ is a full-featured MQTT broker for mission-critical messaging. It supports MQTT 3 and 5. Additional features can be purchased individually, such as automatically transforming messages or using database queries to access data stored in messages. | |
ACE APIs are part of FairCom’s Advanced Core Engineering (ACE) software development kit. These APIs are optimized for C and also work for C++, Java, and C#. They provide unprecedented control of the database engine allowing engineers to develop high performance solutions such as inserting millions of records per second on mid-level hardware, that cannot be achieved by any other data technology. | |
c-treeRTG is a modernization solution for COBOL and Btrieve applications. It breathes new life into legacy applications by transparently swapping out their built-in record management system with FairCom’s modern database engine for increased reliability, high availability, concurrent users, performance, durability, and automatic data backups. Without changing existing programs, it enables any modern system and programming language to read and write legacy data simultaneously with legacy applications. |
The General information section provides information that applies to all products.
Section | Description |
---|---|
Quick and advanced installation guides. | |
Complete list of FairCom error codes. | |
New features in the V12 release of FairCom DB. | |
New features in the V11.5 release of FairCom DB. |
FairCom Edgeprovides system integrators with the following features that can be licensed individually or as a bundle with a product.
Category | Features | ||||||
---|---|---|---|---|---|---|---|
JSON APIs |
| ||||||
Browser-based web applications |
| ||||||
Automatic protocol bridging with transforms | |||||||
Easy, fast, no-maintenance JSON database engine with SQL | |||||||
Full-featured, MQTT 3 & 5 broker for mission-critical messaging | |||||||
| |||||||
| |||||||
|
All FairCom products include the FairCom database engine. Developers can manage database data through various APIs, such as SQL, jsonAction, and ISAM APIs. Different APIs are optimized for different languages and use cases.
JSON DB API
The JSON DB APIis optimized for easy and fast development. It uses JSON for data, queries, database objects, API calls, and so forth. It runs over all major Internet protocols including HTTP, HTTPS, WS, WSS, MQTT, MQTTS
SQL
FairCom SQL is optimized for all programmers who want to use standard ANSI SQL to query and manage data.
ISAM API
FairCom's ISAM API is optimized for C programmers who want to control all aspects of the FairCom database engine.
API type | APIs |
---|---|
FairCom APIs | ACE APIs, CLI, JSON APIs, JSON, jsonAction, JSON Schema, SQL |
FairCom JSON APIs | JSON Admin API, JSON DB API, JSON Hub API, JSON MQ API, REST |
FairCom ACE APIs |
FairCom’s JSON DB APIis optimized for microservices and low-code development. It uses JSON to make database development easy and fast for all programming languages. Everything is represented as JSON: data, queries, database objects, API calls, and so forth. It supports all major Internet protocols including HTTP, HTTPS, WS, WSS, MQTT, and MQTTS.
Section | Description |
---|---|
jsonActionAPI for managing all database activities. | |
jsonActionAPI for managing data integration and transformation | |
jsonActionAPI for connecting to the server and performing administrative tasks. | |
Guide for creating and managing database replication. |
Section | Description |
---|---|
Tutorials for using FairCom's interactive SQL command line utility (iSQL). | |
Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. | |
FairCom DBSQL language reference guide. | |
Guide for using the full-text search. | |
Guide for using Java and C# to implement SQL stored procedures and triggers. | |
Tutorials for using FairCom's JDBC driver in Java. | |
Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database). | |
Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DBSQL. | |
Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. | |
Advanced FairCom SQL features, options, and utilities. | |
Complete list of SQL error codes. |
Java developers should first try FairCom’s JSON DB API, which is optimized for microservices and n-tier application development.
JSON APIs for Java
Section | Description |
---|---|
Guide for using the JSON DB API. | |
Reference guide to use the JSON DB API. | |
Core JSON API pattern that is used in FairCom APIs. | |
Complete list of FairCom error codes. |
SQL for Java
Section | Description |
---|---|
Tutorials for using FairCom's JDBC driver in Java. | |
Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database). | |
Tutorial for using Java to implement SQL stored procedures and triggers in . | |
Guide for using Java and C# to implement SQL stored procedures and triggers. | |
Language elements that are common to many FairCom DBSQL statements. | |
Guide for using the full-text search. | |
Tutorials for using FairCom's interactive SQL command line utility (iSQL). | |
Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. | |
Advanced FairCom SQL features, options, and utilities. | |
Complete list of SQL error codes. |
Advanced engineering APIs for Java
FairCom provides advanced APIs that allow low-level control over all aspects of data processing. You can build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DBserver.
Section | Description |
---|---|
Tutorials for working with record buffers using the JTDB API. | |
Reference guide for using the c-tree Database in Java — this API is called JTDB. | |
Tutorials for using the JPA and Hibernate to build Java applications using FairCom's JDTB API. | |
Guide for using the full-text search. | |
Answers to common problems. | |
Complete list of FairCom error codes. |
JSON APIs for Python
FairCom's JSON DB APIis optimized for easy development of microservices and n-tier applications.
Section | Description |
---|---|
Guide for using the JSON DB API. | |
Reference guide to use the JSON DB API. | |
Complete list of FairCom error codes. |
SQL for Python
FairCom's SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.
Section | Description |
---|---|
Tutorials for using SQL with FairCom DB. | |
Guide for using SQL with FairCom DB. | |
Language elements that are common to many FairCom DBSQL statements. | |
Guide for using the full-text search. | |
Tutorials for using FairCom's interactive SQL command line utility (iSQL). | |
Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. | |
Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. | |
Advanced FairCom SQL features, options, and utilities. | |
Complete list of SQL error codes. |
JSON APIs for C#
FairCom's JSON DB APIis optimized for easy development of microservices and n-tier applications.
Section | Description |
---|---|
Guide for using the JSON DB API. | |
Reference guide to use the JSON DB API. | |
Core JSON API pattern that is used in FairCom APIs. | |
Complete list of FairCom error codes. |
SQL for C#
FairCom’s SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.
Section | Description |
---|---|
Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DB. | |
Guide for using SQL with FairCom DB. | |
Language elements that are common to many FairCom DBSQL statements. | |
Guide for using the full text search. | |
Tutorial for using the C# to implement SQL stored procedures in FairCom DB. | |
Guide for using Java and C# to implement SQL stored procedures and triggers. | |
Tutorials for using FairCom's interactive SQL command line utility (iSQL). | |
Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. | |
Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. | |
Advanced FairCom SQL features, options, and utilities. | |
Complete list of SQL error codes. |
Advanced engineering APIs for C#
FairCom provides advanced APIs that control all aspects of data processing. They allow you to build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DB server.
Section | Description |
---|---|
Tutorials for working with record buffers using the JTDB API. | |
Guide for using the c-treeDB API in C#. | |
Guide for using the full text search. | |
Complete list of FairCom error codes. |
FairCom DB is an exceptional data management solution for C programmers. The APIs use record buffers, which is ideal for C applications and provides an unprecedented level of performance and control over all aspects of data management.
Advanced engineering APIs for C
FairCom provides advanced APIs that allow low-level control over all aspects of data processing. You can build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DBserver.
Section | Description |
---|---|
Tutorials for working with record buffers. | |
Developer guide to building high-speed C applications using FairCom DB. | |
Guide for the c-treeDB C API. | |
Guide for using the full-text search. | |
Guide for automating timestamps, aggregation, and purging. | |
Guide for intercepting and interacting with database change events. | |
Guide for detecting and managing conflict resolution, data transformation, data filtering, and replicating to another database. | |
Introduction and tutorial on accessing the FairCom DBat the lowest possible level. | |
Guide for creating a new Microsoft Visual Studio C project using the CTDB API. | |
Complete list of FairCom error codes. |
SQL for C
Section | Description |
---|---|
Guidelines for FairCom DBDirect SQL developers. | |
Language elements that are common to many FairCom DBSQL statements. | |
Guide for using the full text search. | |
Tutorials for using FairCom's interactive SQL command line utility (iSQL). | |
Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. | |
Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DB. | |
Guide for using an ODBC driver to connect to FairCom DB. | |
Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. | |
Advanced FairCom SQL features, options, and utilities. | |
Complete list of SQL error codes. |
FairCom DBis an excellent data management solution for C++ programmers. The APIs use record buffers, so they are ideal for C++ applications and provide an unprecedented level of performance and control over all aspects of data management.
Advanced engineering APIs for C++
FairCom provides advanced APIs that allow low-level control over all aspects of data processing. You can build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DBserver.
Section | Description |
---|---|
Tutorials for working with record buffers. | |
Guide for using the c-treeDB C++ API. | |
Guide for building C++ applications using FairCom's ISAM and low-level APIs. | |
Guide for using the full-text search. | |
Developer guide for embedding SQL in C and C++. | |
Guide for C++ programmers to automate FairCom's data replication engine. | |
Guide for creating a new Microsoft Visual Studio C++ project using the c-treeDB server. | |
Complete list of FairCom error codes. |
SQL for C++
FairCom’s SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.
Section | Description |
---|---|
Developer guide for embedding SQL in C and C++. | |
Language elements that are common to many FairCom DBSQL statements. | |
Guide for using the full text search. | |
Tutorials for using FairCom's interactive SQL command line utility (iSQL). | |
Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. | |
Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DB. | |
Guide for using an ODBC driver to connect to FairCom DB. | |
Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. | |
Advanced FairCom SQL features, options, and utilities. | |
Complete list of SQL error codes. |
SQL for PHP
Section | Description |
---|---|
Tutorials for using PHP PDO with FairCom DB. | |
Tutorials for using PHP SQL with FairCom DB. | |
Guide for using FairCom SQL with PHP applications using ODBC and PDO. | |
Complete list of SQL error codes. |
Section | Description |
---|---|
Tutorial for using the c-tree Database API in Visual Basic.NET. | |
Reference guide for using the c-tree Database API in .NET. | |
Guide for using the full text search. | |
Complete list of FairCom error codes. |
c-treeRTG is a modernization solution for COBOL and BTRIEVE applications. See Database developer guides that expose COBOL and BTRIEVE data through JSON, SQL, and ISAM APIs.
Section | Description |
---|---|
Solution guide to modernizing COBOL using c-treeRTG. | |
Solution guide to modernizing BTRIEVE using c-treeRTG. | |
Quick and advanced installation guides. | |
Complete list of FairCom error codes. | |
Guide for administering FairCom DB. | |
Highlights of the V3 release of c-treeRTG. | |
New features in the V3 release of c-treeRTG. | |
Release notes for the V3 release of c-treeRTG. |
The System administrator guides are useful for administrators who install, configure, manage, tune, and troubleshoot FairCom products.
Section | Description |
---|---|
Quick and advanced installation guides. | |
Complete list of FairCom error codes. | |
Guide for administering FairCom DB. | |
A complete list of all FairCom CLI tools for backing up, recovering, managing users, troubleshooting, and so forth. | |
A list of all browser-based and GUI applications for administering FairCom DB. | |
Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. | |
Advanced FairCom SQL features, options, and utilities. |
Section | Description |
---|---|
Guide for implementing high availability on Linux servers. | |
Guide for implementing high availability on Windows servers. | |
Guide for using replication in order to achieve high availability and scalability. |
Section | Description |
---|---|
Guide for implementing replication in FairCom DB. | |
Guide for using a GUI tool for managing data replication in FairCom DB. | |
Guide for the replication SDK, which allows C developers to extend data replication to manage conflict resolution, transform data, filter updates, and redirect updates. |
Section | Description |
---|---|
Overall guide to upgrading FairCom products. | |
Highlights to the V12 release of FairCom DB. | |
New features in the V12 release of FairCom DB. | |
Release notes for the V12 release of FairCom DB. | |
Update guide for c-treeACE V11.5. | |
Release notes for c-treeACE V11.5. | |
Update guide for c-treeACE V11.0. | |
Release notes for c-treeACE V11.0. | |
Update guide for c-treeACE V10.3. | |
Release notes for c-treeACE V10.3. | |
Update guide for c-treeACE V10.0. | |
Release notes for c-treeACE V10.0. | |
Update guide for c-treeRTGV2. | |
Release notes for c-treeRTGV2. |