ActorDB vs SingleStore Helios

ActorDB is an open-source distributed relational SQL database from Biokoda that organizes data into independent actors. SQLite handles SQL queries and LMDB provides storage. Applications connect through the MySQL protocol or Thrift, and the FAQ recommends Thrift; default MySQL drivers also work. ActorDB uses Raft for distributed consensus and write replication, and describes itself as strongly consistent. Transactions can span multiple actors and are described as ACID compliant. It can also provide a sharded key-value store with structured values, multiple columns, and foreign tables. The maker says horizontal scaling can reach hundreds of nodes and petabytes when data is spread across actors. If a server fails, a follower can lead an actor while a cluster majority remains online. Recommended cluster sizes are 1, 3, or 5 nodes. Supported downloads include Windows, Mac OS X, CentOS, and Ubuntu, with version 0.10.29 dated 1 October 2019 shown as the latest stable release.

SingleStore Helios is a cloud database service available on AWS, Google Cloud, and Microsoft Azure. It handles transactional and analytical workloads in one database, with storage and compute scaled independently. Its data capabilities include relational records, JSON/BSON documents, vector and full-text search, time-series, geospatial, and key-value data. SingleStore Pipelines can ingest from sources such as Kafka, Amazon S3, and HDFS. For AI workloads, the service includes Jupyter notebooks, data integration services, and a compute service. Listed integrations include Datadog, Terraform, Apache Spark, AWS Glue, Azure Data Factory, dbt, and Fivetran. Helios is available through web and API platforms. The free Shared plan provides one workspace for evaluation, development, and non-production testing, with self-support. Standard is $0.99 a month for managed production workloads, with read replicas, database branching, 30-day monitoring, and support. Enterprise is $1.49 a month and adds online point-in-time recovery, Smart Disaster Recovery, audit logging, and customer-managed encryption keys. The listed availability commitments vary by configuration, reaching 99.99% across two availability zones on paid plans.