FairCom DB provides a full-featured database engine designed for efficient and cost-effective on-premises application development. Its multimodel architecture supports high-velocity transactions across JSON, SQL, and traditional record buffer APIs, allowing developers to work with various data models simultaneously over the same data. This versatility enables its use as a JSON database, a microservice database, or a traditional ISAM database, often at a lower total cost of ownership compared to competitors. The database simplifies data management, querying, and batch processing through intuitive JSON commands and offers features like a built-in API Explorer to accelerate development and reduce time-to-market. It is designed for sustainable scaling without requiring additional servers and minimizes DBA workload through self-tuning capabilities. FairCom DB ensures high performance and low latency, maintaining high throughput even in demanding, transaction-heavy environments, making it suitable for real-time data needs. It also includes robust features for high availability and disaster recovery, flexible replication, and real-time data synchronization via DB Notify, which integrates with messaging systems like MQTT, AMQP, and Kafka to eliminate data silos.

Features & Benefits

• Multimodel & Versatile Database
  • Offers JSON, SQL, key-value, ISAM, search, and time series capabilities over the same data within a single database server, eliminating the need for multiple database technologies.
• Easy Application Development
  • Facilitates quicker time-to-market by enabling simultaneous use of SQL and JSON over the same data, simplifying data management, querying, and batch processing with simple JSON commands, and providing an API Explorer for easy JSON action creation.
• Lower Total Cost of Ownership (TCO)
  • Reduces operational expenses through fewer licenses, easier deployment, minimal upkeep due to self-tuning, and sustainable scaling without additional server purchases, leading to a minimal DBA workload.
• High-Performance & Low-Latency
  • Optimized for predictable, consistent low-latency and high throughput, even in demanding, transaction-heavy environments, ensuring real-time data access with minimal delays.
• Advanced Query & Data Modeling
  • Supports cursor-based queries (forward/backward) in index order, JSON or standard SQL querying, and retrieval by ID. Enables JSON table creation, mixing strongly typed and flexible JSON fields, creating indexes using JSON, and embedding SQL scripts in JSON.
• Comprehensive API Support
  • Provides JSON, SQL, CTDB, and ISAM APIs that run over the same dataset, ensuring data consistency even with real-time updates.
• Enhanced Key-Value Capabilities
  • Extends basic key-value functionality with support for thousands of secondary indexes for efficient range queries and utilizes the ISAM API for record-buffer data processing.
• Optimized for Embedding
  • Delivers incredible query speeds for embedded applications, enhancing performance for batch processing, analytics, data warehousing, and machine learning workloads.
• Real-time Data Synchronization (DB Notify)
  • Publishes data change events as JSON messages with guaranteed, real-time delivery to unlimited subscribers, eliminating data silos through integration with MQTT, AMQP, and Kafka.
• Replication & High Availability/Disaster Recovery (HA/DR)
  • Maintains high availability and disaster recovery capabilities with flexible replication options supporting ACID compliance or eventual consistency, and allows designation of additional servers for reporting, analytics, and batch processing.