this post was submitted on 25 Dec 2024
13 points (100.0% liked)

General Programming Discussion

8729 readers
5 users here now

A general programming discussion community.

Rules:

  1. Be civil.
  2. Please start discussions that spark conversation

Other communities

Systems

Functional Programming

Also related

founded 6 years ago
MODERATORS
top 3 comments
sorted by: hot top controversial new old
[–] 0x01@lemmy.ml 7 points 6 months ago (1 children)

Unlike PostgreSQL, ScyllaDB is not as general-purpose and covers fewer use cases due to its query limitations. It doesn’t have the luxury of rich query capabilities found in PostgreSQL, such as joins, aggregates, subqueries, geospatial queries, and more. Additionally, ScyllaDB does not fully support ACID properties, making it less ideal in terms of consistency and data integrity

This is the most important part of the article imo

[–] propter_hog@hexbear.net 1 points 6 months ago

Yeah, that is one hell of a caveat

[–] FuckBigTech347@lemmygrad.ml 3 points 6 months ago

I ran into the same issue a few weeks ago. In my case I didn't need real-time updates but I still needed to bulk insert data, which Postgres is terrible at (especially when dealing with tens of millions of rows). I just ended up using MariaDB (since that was my first exposure to SQL and I don't remember having issues with it) and turns out it can handle bulk inserts a lot better without slowing down much. I wish PostgreSQL was better.