Skip to main content
Share Your Experience: Take the 2024 Developer Survey
3 votes

How can I prevent race conditions in Cassandra?

And you now understand why the "read before write" approach is considered an anti-pattern in Cassandra. This is because, by the time you execute the write, the data you initially read could ...
Aaron's user avatar
  • 4,105
3 votes

How can I prevent race conditions in Cassandra?

This is a problem that will be solved soon when ACID transactions is added to Cassandra 5.0 (CEP-15). When it lands, a transaction would look something like this: BEGIN TRANSACTION LET fromBalance ...
Erick Ramirez's user avatar
2 votes
Accepted

How to index when the fields used in the query is unpredictable?

I am repeating myself: Review your database design, it is really bad - just believe it! Anyway, you say "Indexes are needed for a query on this collection." Yes, that's true but it does not ...
Wernfried Domscheit's user avatar
2 votes

How to index when the fields used in the query is unpredictable?

How to index when the fields used in the query is unpredictable? How do you shop for groceries when the meal being cooked is unpredictable? - You don't. Or you spend a ton of money buying every ...
J.D.'s user avatar
  • 37.8k
1 vote

Possible options for SQL and NoSQL combination for social media data

We are designing database schemas for a social media app with posts, groups, users and chats etc and it looks like we have a mix of structured and unstructured data... Having some data examples would ...
J.D.'s user avatar
  • 37.8k
1 vote
Accepted

Why use $group / group_by instead of multiple requests?

why perform a query involving $group which in principle processes each document sequentially This is not necessarily true. The database engine is designed to be optimized for such type of operations, ...
J.D.'s user avatar
  • 37.8k
1 vote

Solution to query that must examine all rows / documents in worst case

Again (or still) you have a wrong picture in front of you. Maybe for comparison and as an example, have a look at https://www.stayfriends.com/team/, it is a German social network, however with tools ...
Wernfried Domscheit's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible