Skip to main content

FairCom DB

Navigating data is FairCom DB's unique capability, making it easy and fast to find a matching record and use it as a starting point to walk filtered records forward or backward in table or index order.

FairCom-DB-Marketecture2c.svg

Quick links

Section

Description

Installation

Install, configure, start, stop, and troubleshoot all FairCom products.

Concepts

Learn about the FairCom DB features.

Get data concepts

This section describes the concepts of the get-data actions.

Tutorials

Get started using FairCom DB.

JSON DB API

The JSON DB API manages the FairCom database, providing actions to manage databases, tables, indexes, and records.

ACE APIs

These APIs retrieve record buffers from disk or cache and directly load them into application memory.

SQL APIs

This section provides a complete listing of SQL APIs for C programmers, C++ programmers, Java, C#, Visual Basic, Python, and PHP developers.

Message pattern

The JSON DB API uses a request-response pattern that works over any communications protocol.

Sessions

The sessions actions are part of the JSON Admin APII and used to log in and log out of the server, these actions are used by all FairCom APIs.

Databases

This section provides actions to list, create, and delete databases.

Tables

This section covers the actions used to list, create, alter, delete, describe, list, and rebuild tables.

Indexes

This section provides actions to create, list, rebuild, and delete indexes.

Modify data

This section covers the actions used to modify data including inserting, updating, truncating, and deleting records as well as updating fields.

Administration

The System administrator guides are useful for administrators who install, configure, manage, tune, and troubleshoot FairCom products.

Error codes

Complete list of FairCom error codes.

Helpful links