Ask HN: Do you need a distributed transactional database?

7 points by newcloud ↗ HN
Gartner has recently published its 2023 marketshare analysis on DBMS worldwide and it seems that distributed transactional databases have gained strong traction in terms of marketshare. Do you need a distributed transactional database in your company? Why or why not?

8 comments

[ 3.4 ms ] story [ 30.7 ms ] thread
[flagged]
Please don’t post output from ChatGPT or other LLMs here.

Doing so lessens the value of HN. People who post here expect thoughtful responses from actual human beings. For those who want an LLM answer, they can simply go to ChatGPT and input their question there.

For a second, I was wondering why GP comment was downvoted ? On surface, it seemed informative and then after seeing your comment, I realized it was just copy/pasted from ChatGPT.

This is the danger we are in now with this stuff.

I’m curious how you can definitely say it came from a LLM
The first tell is the "here's a bunch of bullet points on the topic" format which is classic ChatGPT. The second tell is that it is a generic comment that doesn't actually answer OP's question about concrete uses of distributed DBs. The third tell is that this person keeps submitting clear LLM output despite getting called out multiple times on it.
Does the report name these databases? I am curious to know about popular and open source distributed transactional database
You only need a distributed OLTP database once you scale e.g. you have customers all over the world or if you are in a space the requires it like gaming, fin/tech, gambling, etc.... I think the reason they are gaining popularity is because the barrier to entry has been lowered both technically and financially. CockroachDB and Yugabyte for example are open sourced have a good entry point for their managed solutions and are mostly compatible with PostgreSQL. The large cloud providers are also offering solutions that let you incrementally scale to a distributed DB as you need it.

I have worked in Fintech where we needed a distributed database, as startup where we grew to the point of needing one, and am hoping to grow what I am currently working on to the point of needing one but we are not there yet.

really depends on the scale of your platform, data & transaction volume - such ACID distributed dbs would be handy for big fintech corporations. In my case, I just need a simple managed postgres for my launch platform (https://microlaunch.net), it's still transactional, but the platform isn't write intensive