Skip to main content

FairCom DB

FairCom DB product

Abstract

FairCom DB product homepage

FairCom DB is an enterprise database server that can run as a traditional database server or be embedded in your application. FairCom provides several different embedding options, such as linking to the server and compiling the C source code into your application; FairCom also provides multiple embeddable engines, including the server engine, a multi-user direct read-write engine, and a single-user engine.

FairCom DB also provides various options for deploying the database server, giving you unmatched architectural options. An application can simultaneously do some or all of the following.

  • Applications, microservices, and desktop applications can embed the database server as a high-speed cache.

  • Multitenancy solutions can run multiple instances of the database server on the same computer for maximal hardware and software savings.

  • N-tier and client-server applications can connect to instances of the database server running on other computers.

  • Mobile applications can run the database locally and bidirectionally synchronize with database servers in the cloud or on-premise.

FairCom DB FairCom provides data replication between database servers for high availability and scalability. Data replication can be synchronous, asynchronous, uni-directional, or bi-directional. These replication options allow you to deliver solutions with any combination of ACID-compliant and eventually consistent data. Data replication makes it easy to scale out FairCom DB by adding read-only and read-write servers.

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 session actions are part of the JSON Admin API and used to log in and log out of the server, these actions are used by all FairCom APIs.

Databases

This section lists the JSON actions that manage databases. You can use these actions to create, delete, and list databases on a FairCom database server. These actions work for all FairCom products that include the FairCom database engine.

Tables

This section lists the JSON actions that manage tables in a FairCom database. You can use these actions to create, delete, alter, list, describe, and rebuild tables. These actions work for all FairCom products that include the FairCom database engine.

Indexes

This section lists the JSON actions that manage indexes in a FairCom database. You can use these actions to create, delete, list, and rebuild indexes. These actions work for all FairCom products that include the FairCom database engine.

Modify data

This section lists the JSON actions that modify data in a FairCom database. You can use these actions to insert, update, delete, truncate, and run SQL Data Manipulation Language (DML) statements. SQL DML statements can insert, update, and delete records conditionally. These actions work for all FairCom products that include the FairCom database engine.

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