FairCom Drivers and APIs

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

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
JSON NAV - Java Client	Simple API for FairCom JSON NAV Using Java Client	java.json.nav	Java JSON NAV
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

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

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

c-treeRTG 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.