Product Documentation

FairCom Drivers and APIs

Next Topic

FairCom DB Interfaces

FairCom Database Engine is a unified, multimodel engine with four types of API: Low-Level, ISAM, Navigational "NAV", and SQL. Multiple applications, using any combination of these APIs, can interact simultaneously with the FairCom DB database engine.

Select your desired interface technology from the links below. You will be directed to a focused tutorial for that particular interface, and experience results in no time.

These tutorials follow best practices, so feel free to copy and paste the code into your own program!

Note: The ReadMe files reference win32 by default. We offer a full range of platforms for Windows x32, x64, and many Unix and Linux platforms. Please replace the reference of win32 to your platform choice when locating any tutorial directories.

High-Velocity Binary Data Structures

High-speed interfaces for maximum control—and maximum performance:

API

Language

Notes

Drivers Folder

(V12 location)

ISAM

C / C++

Record-level NoSQL (ISAM) C API.

c.isam

Low-Level

C / C++

Low-Level C API.

c.lowlevel

Replication

C / C++

Replication C and C++ API

cpp.replication

Fast Relational Data and Productivity

NAV API is a record-oriented navigational interface that provides an excellent balance of performance and simplicity.

Navigational record-oriented interfaces:

Language

Notes

Drivers Folder

(V12 location)

Nickname

C

Record-oriented C API

c.nav

ctdb

C++

Record-oriented C++ API

cpp.nav

ctpp

C#

Record-oriented Microsoft C# .NET API

csharp.nav

 

Java

Record-oriented Java API

java.nav

jtdb

JPA Hibernate

Java

java.jpa.nav

ctree.isam.jpa

Node.js JavaScript - NAV

Record-oriented API for JavaScript

nodejs.nav

c-tree Node.js Module

Python FairCom NAV

Record-oriented API for Python

python.nav

Python NAV

Visual Basic

Record-oriented API for Microsoft Visual Basic .NET

vb.nav

vtdb

VCL

Record-oriented API for VCL data components for Embarcadero Delphi

(available from FairCom)

dtdb

Productivity through SQL Interfaces

SQL interfaces for relational access:

API

Language

Notes

Drivers Folder

(V12 location)

ODBC

n/a

Open Database Connectivity: industry-standard SQL API.

sql.odbc

ADO.NET

.NET

Relational data provider for the .NET framework.

csharp.sql.ado.net

Direct SQL

C / C++

Direct SQL: FairCom's API providing direct SQL access.

c.sql.direct

JDBC

Java

Java Database Connectivity: industry-standard SQL driver.

sql.jdbc

Java Persistence Layer (Hibernate)

Java

Instantly convert applications that use industry-standard Java Hibernate.

java.sql.hibernate

Node.js JavaScript - SQL

JavaScript

SQL API for JavaScript

nodejs.sql

FairCom REST API for Node.js

JavaScript

REST API for JavaScript

nodejs.rest.crud

FairCom REST API for Node-RED

JavaScript

REST API for JavaScript

node-red.rest.crud

PHP

PHP

SQL API for PHP

php.sql

PHP PDO

PHP

PHP Data Objects (PDO) support.

php.sql.pdo

Python

Python

Python SQL Database API.

python.sql

ISQL

Command-Line

Interactive SQL: FairCom's interactive command-line SQL utility.

sql.cli

SQLAlchemy for Python

Python

Developer tutorials for Python using SQLAlchemy

python.sql.sqlalchemy

Java REST API for JSON RPC

Java

REST API for JSON RPC

java.rpc.replication

Java Stored Procedures

Java

FairCom's server-side SQL stored procedures, user-defined functions, and triggers (Note: Stored Procedures require a suitable Java Development Kit, as explained in the ReadMe).

java.sql.storedprocs

.NET Stored Procedures

C# .NET

FairCom's server-side SQL stored procedures, user-defined functions, and triggers (Note: Stored Procedures require a suitable .NET Development Kit, as explained in the ReadMe).

csharp.sql.storedprocs

Node-RED

JavaScript

SQL API for JavaScript

node-red.sql

FairCom DB

ReadMes and Documentation for FairCom DB:

Title

Notes

Drivers Folder

(V12 location)

Callbacks

Custom functions developers can write to extend the power of FairCom DB

ctree.callbacks

Drivers

Quick Start Guide for FairCom Shared Driver Libraries

ctree.drivers

FairCom EDGE

ReadMes and Documentation for FairCom EDGE:

Title

Notes

Drivers Folder

(V12 location)

ThingWorx AlwaysOn

Quick Start Guide for FairCom Connector for ThingWorx

thingworx.always-on

MQTT Client for C - Quick Start Guide

Quick Start Guide and tutorials for the MQTT Client for C

c.mqtt

FairCom RTG COBOL and Btrieve Modernization

FairCom has developed another product line that brings the power of the full-featured, FairCom Database Engine to COBOL and Btrieve applications. These products give you all the benefits of this technology, including SQL and NAV API access, ACID transaction processing, and robust scalability. This makes the FairCom Database Engine “ready to go” (R-T-G) right out of the box for COBOL and Btrieve applications.

TOCIndex