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