FairCom DB is the FairCom database server optimized for easy development, low total cost of ownership, and high performance. FairCom DB provides multiple APIs for working with data, including JSON, ISAM, and record buffer APIs. It also provides multiple database engines that you can embed in your software. It also can replicate data to other FairCom products and notify external systems of data change events.
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.
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 Action REST APIs | 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. |
| 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. |