DolphinDB vs FairCom DB

DolphinDB is a real-time analytics and stream-processing platform built around a high-performance time-series database. Its storage engines cover time-series databases, OLAP and in-memory OLTP workloads, with more than 1,500 built-in analytical functions and more than 10 streaming engines. Batch and stream processing can use the same metric expression. Programming options include imperative, vectorized, functional and SQL paradigms. The distributed system supports horizontal scaling, load balancing, fault tolerance, distributed transactions and high availability across data nodes, controllers, streaming and API clients. Deployment options include cloud, on-premise and hybrid environments. Listed use cases span finance, energy, power, transportation, industrial manufacturing and scientific research. The Community Edition has a free perpetual license, limited to two nodes, each with two CPU cores and 8 GB RAM. A free Enterprise Trial supports high-availability clusters and includes expert technical support. Related components include Swordfish for embedded use, Shark for GPU workloads, Starfish for quantitative research workflows and Octopus for complex event processing. The product is available through API, extension, Linux, self-hosted, web and Windows options.

FairCom DB is a multimodel database for developing on-premises applications, combining JSON, key-value, SQL, and ISAM or record-buffer capabilities in one server. Applications can use different models over the same data, query with JSON or standard SQL, and receive query results as JSON. SQL connections are available through JDBC and ODBC, while the built-in API Explorer can help create JSON actions. The database can operate as a traditional server or be embedded in an application. Replication options address high availability and disaster recovery, with ACID compliance or eventual consistency. DB Notify publishes data-change events as JSON messages and integrates with MQTT, AMQP, and Kafka. FairCom DB v13 uses OpenSSL v3 for secure communications and supports X.509 client certificate authentication. File and user security are available only in the client/server operational model. A free Developer’s Edition is limited to development environments and has a three-hour timeout; production licensing requires contacting sales. A free trial is also available, and pricing is on request.