JavaScript developers
FairCom’s JSON DB APIis optimized for client-server, microservices, and low-code development. It uses JSON to make database development easy and fast for all programming languages. Everything is represented as JSON: data, queries, database objects, API calls, and so forth. It supports all major Internet protocols, including HTTP, HTTPS, WS, and WSS. See JSON Action REST API for more details.
SQL developers
| Section | Description |
|---|---|
| ISQL tutorial | 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. |
| SQL reference | FairCom DBSQL language reference guide. |
| Full text search | Guide for using the full-text search. |
| SQL stored procedures | Guide for using Java and C# to implement SQL stored procedures and triggers. |
| JDBC quick start | Tutorials for using FairCom's JDBC driver in Java. |
| JDBC developer guide | Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database). |
| ODBC quick start | Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DBSQL. |
| 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. |
Java developers
Java developers should first try FairCom’s JSON DB API, which is optimized for microservices and n-tier application development.
JSON APIs for Java
| Section | Description |
|---|---|
|
Features |
Object-oriented driver for using the JSON DB API. |
|
JSON DB concepts |
Guide for using the JSON DB API. |
|
JSON DB API |
Reference guide to use the JSON DB API. |
| jsonAction API | Core JSON API pattern that is used in FairCom APIs. |
|
Error codes |
Complete list of FairCom error codes. |
SQL for Java
| Section | Description |
|---|---|
| JDBC quick start | Tutorials for using FairCom's JDBC driver in Java. |
| JDBC developer guide | Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database). |
| Java stored procedures | Tutorial for using Java to implement SQL stored procedures and triggers in . |
| SQL stored procedures | Guide for using Java and C# to implement SQL stored procedures and triggers. |
| SQL language elements | Language elements that are common to many FairCom DBSQL statements. |
| Full text search | Guide for using the full-text search. |
| ISQL tutorial | 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. |
| SQL operations | Advanced FairCom SQL features, options, and utilities. |
| SQL error codes | Complete list of SQL error codes. |
Record Buffer APIs for Java
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 |
|---|---|
| Java CTDB quick start | Tutorials for working with record buffers using the JTDB API. |
| Java CTDB API | Reference guide for using the c-tree Database in Java — this API is called JTDB. |
| Full text search | Guide for using the full-text search. |
| Error codes | Complete list of FairCom error codes. |
Python developers
JSON APIs for Python
FairCom's JSON DB APIis optimized for easy development of microservices and n-tier applications.
| Section | Description |
|---|---|
| JSON DB concepts | Guide for using the JSON DB API. |
| JSON DB API | Reference guide to use the JSON DB API. |
| Error codes | Complete list of FairCom error codes. |
SQL for Python
FairCom's SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.
| Section | Description |
|---|---|
| SQL Python tutorial | Tutorials for using SQL with FairCom DB. |
| SQLAlchemy API | Guide for using SQL with FairCom DB. |
| SQL language elements | Language elements that are common to many FairCom DBSQL statements. |
| Full text search | Guide for using the full-text search. |
| ISQL tutorial | 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 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. |
C# developers
JSON APIs for C#
FairCom's JSON DB APIis optimized for easy management of all data processing for microservices and n-tier applications.
| Section | Description |
|---|---|
| JSON DB concepts | Guide for using the JSON DB API. |
| JSON DB API | Reference guide to use the JSON DB API. |
| jsonAction API | Core JSON API pattern that is used in FairCom APIs. |
| Error codes | Complete list of FairCom error codes. |
SQL for C#
FairCom’s SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.
| Section | Description |
|---|---|
| ODBC quick start | Tutorials for using FairCom's Windows and Linux (Unix) ODBC driver with FairCom DB. |
| ADO.NET API | Guide for using SQL with FairCom DB. |
| SQL language elements | Language elements that are common to many FairCom DBSQL statements. |
| Full text search | Guide for using the full text search. |
| SQL stored procedures | Guide for using Java and C# to implement SQL stored procedures and triggers. |
| ISQL tutorial | 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 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. |
Record Buffer APIs for C#
FairCom provides advanced APIs that control all aspects of data processing. They allow you to 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 DB server.
| Section | Description |
|---|---|
| C# CTDB API | Guide for using the FairCom DB API in C#. |
| Full text search | Guide for using the full text search. |
| Error codes | Complete list of FairCom error codes. |
C programmers
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.
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. |
| Low-level API tutorial | Introduction and tutorial on accessing the FairCom DBat the lowest possible level. |
| Error codes | Complete list of FairCom error codes. |
SQL for C
| Section | Description |
|---|---|
| Direct SQL | Guidelines for FairCom DBDirect SQL developers. |
| SQL language elements | Language elements that are common to many FairCom DBSQL statements. |
| Full text search | Guide for using the full text search. |
| ISQL tutorial | 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 (Unix) ODBC driver with 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. |
C++ programmers
FairCom DBis an excellent data management solution for C++ programmers. The APIs use record buffers, so they are ideal for C++ applications and provide an unprecedented level of performance and control over all aspects of data management.
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 |
|---|---|
| CPP quick start | Tutorials for working with record buffers. |
| CPP API | Guide for using the c-treeDB C++ API. |
| ISAM API | Guide for building C++ applications using FairCom's ISAM and low-level APIs. |
| Full text search | Guide for using the full-text search. |
| Direct SQL | Developer guide for embedding SQL in C and C++. |
| C++ replication tutorial | Guide for C++ programmers to automate FairCom's data replication engine. |
| Error codes | Complete list of FairCom error codes. |
SQL for C++
FairCom’s SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.
| Section | Description |
|---|---|
| Direct SQL | Developer guide for embedding SQL in C and C++. |
| 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 (Unix) 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. |
PHP developers
SQL for PHP
| Section | Description |
|---|---|
| PDO quick start | Tutorials for using PHP PDO with FairCom DB. |
| PHP SQL guide | Guide for using FairCom SQL with PHP applications using ODBC and PDO. |
| SQL error codes | Complete list of SQL error codes. |
Visual Basic developers
| Section | Description |
|---|---|
| VB CTDB tutorial | Tutorial for using the c-tree Database API in Visual Basic.NET. |
| VB CTDB API | Reference guide for using the c-tree Database API in .NET. |
| Full text search | Guide for using the full text search. |
| Error codes | Complete list of FairCom error codes. |