Datomic VS Graphcool

• Immutability
  Datomic employs an append-only data model where data is never overwritten but instead appended, ensuring historical data is always available and providing strong consistency.
• Time Travel Queries
  Datomic allows you to query the database as of any point in time, facilitating auditing and debugging by allowing easy access to historical data states.
• Rich Data Model
  Supports complex data types like maps and sets directly within its schema, providing a flexible way to represent data.
• ACID Transactions
  Datomic supports fully ACID-compliant transactions, ensuring reliable and predictable database operations.
• Scalability
  Separates storage and compute, allowing for horizontal scaling of read operations, making it suitable for handling large datasets.
• Query Flexibility
  Offers a powerful query language that supports recursive queries, making it suitable for complex data retrieval needs.

Possible disadvantages

• Complexity
  The architecture of Datomic can be complex to understand and implement, particularly for teams unfamiliar with its design principles.
• Cost
  Can be expensive to operate, especially in a cloud environment, where costs increase with the amount of data stored and the compute resources required.
• Limited Write Throughput
  Due to its append-only design, Datomic can have limited write throughput, which may not be suitable for applications with heavy write requirements.
• Closed Source
  Datomic is a proprietary database system, which may not appeal to organizations that prefer open-source solutions.
• Learning Curve
  Requires a learning curve as its conceptual model and query language are different from traditional databases, potentially requiring additional training.
• Dependency on AWS
  Relying on AWS ecosystem for the storage backend can limit choices for deployment environments, impacting flexibility.

• Rapid Development
  Graphcool offers a serverless GraphQL backend which allows developers to quickly set up and deploy applications without worrying about infrastructure management.
• Scalability
  Because it's serverless, Graphcool can easily scale to handle increased load, providing reliable performance even as your application grows.
• Real-time Capabilities
  Graphcool provides real-time GraphQL subscriptions that allow developers to easily implement features that require real-time data updates.
• Automated Backups
  Advanced backup features are offered, ensuring that your data is safe and can be restored when needed, enhancing data security and reliability.

Possible disadvantages

• Vendor Lock-in
  Relying heavily on Graphcool may lead to vendor lock-in, restricting flexibility if you wish to migrate to another platform in the future.
• Limited Customization
  Being a managed service, there might be limitations on customizing the backend to suit very specific use cases which aren't supported out-of-the-box.
• Learning Curve
  While there are benefits, new users might face a learning curve to fully utilize the features of Graphcool, especially those unfamiliar with GraphQL.
• Pricing
  As with many managed services, pricing can become a concern, especially for startups or projects with limited budgets as the service scales.

KotlinConf 2018 - Datomic: The Most Innovative DB You've Never Heard Of by August Lilleaas

More videos

Review: Graphcool - GraphQL backend as a service

More videos