Stop Duplicate Writes in Cassandra with Lightweight Transactions
Use Cassandra lightweight transactions with IF NOT EXISTS and SERIAL consistency to prevent duplicate inserts on a single partition.
Loading…
ReadMeFeed / Community knowledge
#cql
Real questions. Useful conversations. Find the people who know your stack.
cassandraCassandra Lightweight Transactions: Paxos-Based Compare-and-Set in Practice
Learn how Cassandra Lightweight Transactions use Paxos to provide linearizable compare-and-set on a single partition, with a concrete UPDATE example, latency numbers, common pitfalls, and verification steps you can run on a 3‑node cluster.
Automating Confluence Stale‑Page Audits with CQL and REST v2
Use CQL and Confluence REST v2 to find pages not updated in a year, flag them with labels, and handle rate limits safely. The post walks through query syntax, body‑format choices, a Python example, and trade‑offs.
When to Use Cassandra Lightweight Transactions for Compare‑and‑Set
Learn how Cassandra Lightweight Transactions provide compare‑and‑set semantics, see a concrete cqlsh example, and understand when their extra latency is worth the guarantee.
Paginating Confluence Content Search with CQL: A Reliable Bulk‑Fetch Pattern
Learn how to paginate Confluence’s CQL search endpoint safely: a concrete Bash loop, handling of 429 throttling, sort‑stability concerns, and eventual‑consistency limits.
Using Cassandra Lightweight Transactions for Safe Compare‑and‑Set Operations
Cassandra Lightweight Transactions give linearizable compare‑and‑set semantics for unique writes like username reservation, at the cost of higher latency; see how to use, verify, and limit them.
Choosing between offset and cursor pagination for Confluence content search
Goal To reliably iterate over thousands of Confluence pages via the REST API while minimizing duplicated or missing items caused by concurrent content changes. Constraints Confluence Cloud v2 uses cursor‑based pagination; Data Center and legacy v1 endpoints use numeric offsets. Offset pagination can skip or duplicate items if pages are added or removed betwe