How exactly are you supposed to handle counts in Scylla?

ScyllaDB
,
1

For example, views_count, likes_count, etc. These are all common counts you need to keep track of but I can’t find a clear answer. 2 options seem clear to me.

A separate counter table.
Everybody says a counter is archaic and unreliable to use to keep track of counts. Something about it uses Paxos currently and will use Raft soon? Also it requires an additional query so N+1 problem

A bigint count that you increment directly in the table.
Requires 3 steps. A read to get the initial value, a write to write the new value, a read to get the final value.

So what exactly are you supposed to do here?

2

Everybody says a counter is archaic and unreliable to use to keep track of counts.

Who said it? What is exactly the problem you want to solve? If its just count’ing and you do not require idempotency, you should be all set.

The alternative really would be to cluster all “likes” “views” for a given entity(key) and then count() on them.