3 ms·
My biggest complaint about C: SQL-like interface. These seems like a terrible decision to me. If you are used to relational databases and SQL, it's a real stru
by garyrichardson 10y ago
My biggest complaint about C: SQL-like interface. These seems like a terrible decision to me.
If you are used to relational databases and SQL, it's a real struggle to get your head in the right place. Some of the gotchas:
Cell level vs row level consistency/locking (as stated in this article)
* Grouping / counting isn't really a thing.
* WHERE statements are actually used for identifying the key/value pair you want and not for filtering the rows.
* Indexes aren't really indexes. They are definitions of partitions and sort order.
- sargun 10y agoThat's actually my favourite part of C*. I think the CQL interface makes programming against it extremely easy, and I dare might say enjoyable. It makes getting standard, and understanding what's going on a breeze.