Product Documentation

FairCom RTG V3 Update Guide

Previous Topic

Next Topic

More APIs, SDKs, and Drivers for Extended Development Options

FairCom RTG V3 includes more SDKs and drivers in the development package. Although not required for integration with COBOL or Btrieve applications, they allow you to access your application's live data from other applications developed within supported languages and frameworks. Below is a list of APIs included with this release. The first part of each reference below is the directory name you will find in the "drivers" directory.

C

c.isam – ISAM API for C – Processes native binary C structures with exceptional control and speed

c.lowlevel – Low-Level API for C – Gives the programmer total control over indexes and data files for extreme performance and customizability but with potential incompatibility with other APIs and SQL

c.nav – c-treeDB API for C – The c-tree database API is easier to program than ISAM with slightly less control and speed

c.sql.direct – Direct SQL for C – Embeds SQL directly in C code

C++

cpp.nav – c-treeDB API for C++ – The object-oriented c-tree database API is easy to program and processes data quickly

cpp.replication – Replication API for C++ – Use the C++ Replication API to interface with Replication Manager to define, monitor and manage replication

C#

csharp.nav – c-treeDB API for C# – The object-oriented c-tree database API is easy to program and processes data quickly

csharp.sql.ado.net – SQL for ADO.NET and Tutorial in C# – Uses ADO.NET to work with the FairCom Database Engine like any other SQL database

csharp.sql.storedprocs – SQL Stored Procedure API for C# – Creates database stored procedures written in C#

Visual Basic

vb.nav – c-treeDB API for Visual Basic .NET – The object-oriented c-tree database API is easy to program and processes data quickly

C / C++ Callbacks

ctree.callbacks – Callback APIs for C and C++ – Allows C and C++ to create callbacks to process a wide-variety of database events

Java

java.jpa.nav – c-treeDB API for Java JPA– Uses Java, JPA, and the c-treeDB API for Java

java.nav – c-treeDB API for Java – The object-oriented c-tree database API is easy to program and processes data quickly

java.rest.replication – Replication API for Java is a tutorial in Java that uses the JSON RPC Replication API to replicate data between databases

java.sql.hibernate – SQL for Java Hibernate – Uses Hibernate and SQL to manage database records

java.sql.storedprocs – SQL Stored Procedure API for Java – Creates database stored procedures written in Java

JSON RPC

JSON RPC API is a Remote Procedure Control API that uses JSON over HTTP to allow all programming languages to remotely control the FairCom Database Engine for replication, SQL, and monitoring

MQTT

Message Queuing Telemetry Transport – MQTT is an industry-standard message queue protocol for sharing data and commands

MQTT Data Persistence API can create data persistence plans that automatically transform and persist JSON data sent to MQTT topics

Node.js

nodejs.nav – c-treeDB API for Node.js – Currently uses the C-style c-treeDB API

nodejs.rest.crud – REST API for Node.js – Allows Node.js to use the REST API to create databases, tables and indexes as well as query, retrieve, insert, update, and delete records

nodejs.sql – SQL for Node.js – Uses SQL to process relational data

Node-RED

node-red.rest.crud – REST API for Node-RED – Allows Node-RED to use the REST API to create databases, tables and indexes as well as query, retrieve, insert, update, and delete records

node-red.sql – SQL for nodeRED – Uses Node-RED and SQL to process database records

PHP

php.sql – SQL for PHP – Uses SQL to process relational data

php.sql.pdo – SQL for PHP PDO – Uses PDO to work with FairCom DB like any other SQL database

Python

python.nav – NAV API for Python – The NAV API is a new object-oriented navigational API that makes processing data very easy and fast

python.sql – SQL for Python – Uses SQL to process relational data

python.sql.sqlalchemy – SQLAlchemy for Python – Uses SQLAlchemy to work with FairCom DB like any other SQL database

REST

REST API makes it easy for any programming language to create databases, tables and indexes as well as query, retrieve, insert, update, and delete records

SQL

sql.cli – SQL for ISQL – Uses FairCom’s Interactive SQL Utility (ISQL), which is a Command Line Interface (CLI)

sql.jdbc – JDBC – Provides a JDBC connection to Java programs and SQL tools to process relational data

sql.odbc – ODBC – Provides an ODBC connection to SQL tools and programs to process relational data

ThingWorx

thingworx.always-on – IoT Connector for ThingWorx – Uses FairCom’s Always On Connector to ThingWorx to load data into ThingWorx

TOCIndex