C programmers

Overview for using FairCom products as a C programmer

FairCom DB is an exceptional data management solution for C programmers. The APIs use record buffers, which is ideal for C applications and provides an unprecedented level of performance and control over all aspects of data management.

Installation and error codes

The General information section provides information that applies to all products.

Section	Description
Install FairCom products	Quick and advanced installation guides.
Error codes	Complete list of FairCom error codes.

Record Buffer APIs for C

FairCom provides advanced APIs that allow low-level control over all aspects of data processing. You can build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DBserver.

Section	Description
Quick start	Tutorials for working with record buffers.
ISAM API	Developer guide to building high-speed C applications using FairCom DB.
CTDB API	Guide for the c-treeDB C API.
Full text search	Guide for using the full-text search.
Automation features	Guide for automating timestamps, aggregation, and purging.
Callback APIs	Guide for intercepting and interacting with database change events.
Data replication callback API	Guide for detecting and managing conflict resolution, data transformation, data filtering, and replicating to another database.
Low-level API tutorial	Introduction and tutorial on accessing the FairCom DBat the lowest possible level.
Microsoft Visual Studio tutorial	Guide for creating a new Microsoft Visual Studio C project using the CTDB API.

SQL for C

Section	Description
Direct SQL	Guidelines for FairCom DBDirect SQL developers.
SQL reference	Language elements that are common to many FairCom DBSQL statements.
Full text search	Guide for using the full text search.
ISQL quick start	Tutorials for using FairCom's interactive SQL command line utility (iSQL).
ISQL CLI	Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV.
ODBC quick start	Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DB.
ODBC developers guide	Guide for using an ODBC driver to connect to FairCom DB.
ODBC configuration	Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.
SQL operations	Advanced FairCom SQL features, options, and utilities.
SQL error codes	Complete list of SQL error codes.

FairCom's Record Buffer APIs provide low-level control over data processing, enabling high-performance solutions by directly interacting with the FairCom DB engine. These APIs efficiently retrieve record buffers from disk or cache, loading them into application memory for rapid execution. Record Buffer API Overview: Quick Start – Tutorials for efficiently handling record buffers. ISAM API – Guide for building high-speed C applications using FairCom DB. CTDB API – Documentation for the c-treeDB C API. Full-Text Search – Instructions for advanced search capabilities. Automation Features – Solutions for timestamps, aggregation, and data purging. Callback APIs – Methods for intercepting and responding to database events. Data Replication Callback API – Tools for conflict resolution, filtering, and multi-database replication. Low-Level API Tutorial – Direct access to FairCom DB at the lowest level. Microsoft Visual Studio Tutorial – Guide to creating a new C project using the CTDB API. SQL for C Developers: FairCom’s SQL engine is ANSI-standard, offering seamless data querying and modification. Direct SQL – Guidelines for FairCom DB Direct SQL developers. SQL Reference & Operations – Best practices for SQL commands, optimizations, and utilities. ISQL Quick Start & CLI – Tutorials for interactive SQL command-line utility. ODBC Support – Configuration and troubleshooting guides for Windows & Linux ODBC drivers. Full-Text Search & Error Codes – Detailed search methods and error resolution.

Record Buffer APIs: Low-level data access, direct database control, high-speed retrieval ISAM API: High-performance indexing, transactional processing, structured data management CTDB API: c-treeDB integration, advanced record handling Callback APIs: Event-driven interactions, real-time data processing Replication APIs: Conflict resolution, database synchronization, multi-database replication SQL for C: Direct SQL, ODBC connectivity, query optimization, stored procedures Automation Features: Timestamp handling, data aggregation, automated purging Development Tools: Microsoft Visual Studio integration, debugging techniques