Datomic VS Simple Spreadsheet

• 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.

• Lightweight
  Simple Spreadsheet is a lightweight application, making it easy to install and run efficiently on older hardware.
• Open Source
  Being open source, users can modify and customize the software according to their needs and contribute to its development.
• Simplicity
  The application offers a simple, no-frills interface, which is suitable for users who need basic spreadsheet functionality without the complexity of more advanced tools.
• Cross-Platform
  Simple Spreadsheet can be run on various operating systems, providing flexibility for users who work in different environments.

Possible disadvantages

• Limited Features
  Compared to more comprehensive spreadsheet tools, it lacks advanced features like complex data analysis and visualization.
• Sparse Documentation
  Documentation and user guides are limited, which can make it challenging for new users to learn and utilize the full potential of the application.
• Community Support
  Being a niche product, there is a smaller community which could mean less community support and fewer third-party resources or extensions.
• UI/UX Design
  The user interface might not be as polished or modern as other more popular spreadsheet applications, potentially affecting user experience.

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

More videos

No Simple Spreadsheet videos yet. You could help us improve this page by suggesting one.