Tag: sql

Cassandra

Ten Questions to Consider Before Choosing Cassandra

  1. Do you know what your queries will look like ? In traditional SQL you design your data model to represent your business objects. Your queries can then evolve over time and can be ad-hoc. You can even create views, materialized or otherwise, to facilitate even more complex analytical queries. Cassandra does not offer the flexibility of traditional SQL. While your data model can … Continue reading Ten Questions to Consider Before Choosing Cassandra

OD2 Comments
AWS, Cassandra, DynamoDB, PostgreSQL

Ordered Sets and Logs in Cassandra vs SQL

I’ve written before that Cassandra’s achilles’ heel is devops: Storage, redundancy and performance are expanded by adding more nodes. This can happen during normal business hours as long as consistency parameters are met. Same applies to node replacements. As the number of servers grows be prepared to hire a devops army or look for a managed solution. Datastax offering helps but still not enough. Even … Continue reading Ordered Sets and Logs in Cassandra vs SQL

OD2 Comments