News for hackers. Stuff that matters.
Re:Moving The New York Times Games Platform to Google App En... by karmakaze on Thursday August 24, 2017 @12:46AM (#15087653)
Why CloudSQL instead of Cloud Spanner? If for existing SQL workloads I can understand but for new services I'm admiring Spanner over DynamoDB
Re:Moving The New York Times Games Platform to Google App En... by themacguffinman on Thursday August 24, 2017 @02:13AM (#15087986)
Cloud Spanner is unnecessarily expensive if you don't have the kind of performance requirements it was designed for.
Re:Moving The New York Times Games Platform to Google App En... by vira28 on Thursday August 24, 2017 @12:55AM (#15087681)
Looks like Spanner is a relational database. DDB is just a key-value pair. So, is it fair to compare against them or am i missing something?
Re:Moving The New York Times Games Platform to Google App En... by ubernetes on Thursday August 24, 2017 @02:53AM (#15088164)
Why wouldn't it be "fair"?
Re:Moving The New York Times Games Platform to Google App En... by dullgiulio on Thursday August 24, 2017 @08:19AM (#15089449)
Because a key-value store is a foundamentally simpler data structure (it's an hash) than a relational database, which tracks the relations between different data types. If you make an advanced use of the key-value store, you have a lot of logic in the application (for example to key management, cascade operations between related data...) which a relational database should do for you. It's not fair because there is a development cost in using the key-value you are ignoring.
Re:Moving The New York Times Games Platform to Google App En... by ubernetes on Wednesday August 30, 2017 @01:17PM (#15133980)
Dynamo is not a k-v store.
Re:Moving The New York Times Games Platform to Google App En... by vira28 on Thursday August 24, 2017 @10:22AM (#15090316)
Apart from the points @dullgiulio mentioned.

DDB -> NoSQL, No Automatic backups, No support for ad-hoc querying, eventual consistency (though you can set to get consistency with few tradeoffs) Spanner DB -> RDBMS, Automatic backups, Enriched SQL, Strong consistency.

Let me if you still think its fair to compare these 2 databases.