upvote

points

by giancarlostoro6 hours ago |
comments
upvoteby lukaszkorecki5 hours ago|
[-]
> you can go kinda sorta relational about it.

and reinvent half of a SQL engine inside your backend logic, badly.

(source: for the 3rd time, I'm working on a system that uses Mongo extensively, the goal is to move to Postgres as soon as that's viable)

reply
upvoteby giancarlostoro4 hours ago|
parent|
next
[-]
Yeah, I wouldnt recommend doing MongoDB for EVERYTHING, but when you're using it for very specific things, you dont have to throw away everything you're already familiar with is all I was saying.
reply
upvoteby VirusNewbie5 hours ago|
parent|
prev|
[-]
Postgres does not scale. I have extensive experience in some of the largest databases ever built, postgres doesn't even come close.
reply
upvoteby Thaxll2 hours ago|
parent|
next
[-]
It's not that it does not scale but it does not scale out of the box.
reply
upvoteby giancarlostoro4 hours ago|
parent|
prev|
next
[-]
Please elaborate more instead of just "trust me" it would be nice to understand where this comes from. I'm sure back some years people would have said the same about MySQL, yet YouTube used the heck out of MySQL, they made an entire Go based runtime on top of it to scale MySQL.

You can scale nearly anything if you know what you're doing.

reply
upvoteby ewild4 hours ago|
parent|
prev|
next
[-]
there are mountains of evidence that postgres does indeed scale if thoughfully designed.
reply
upvoteby SamInTheShell4 hours ago|
parent|
prev|
next
[-]
Migrate to yugabyte? It's a multi-raft fork of postgres.
reply
upvoteby Imustaskforhelp4 hours ago|
parent|
prev|
next
[-]
Curious to know what does actually scale according to your opinion (if not postgres) and what is the scale that we are talking about when mentioning some of the largest databases ever built (I hope you can talk more about it!)

There seems to be many many options at attempting/trying to scale postgresql, what are your opinions of them?

Also It is my sort of opinion that you really have a good problem if postgresql isn't working you because of the problem of scale and that, evaluation of other problems become much easier but in general, its easier to start with postgresql.

(Personally, I use sqlite + golang static binaries on a 500mb/1gb ram server, so I can't comment too much on the scale part as I am focused much more on simplicity yet I admire how aside from sqlite (which is also more scalable than people think!) postgresql is almost always good enough in my opinion though I can be wrong and I usually am)

reply
upvoteby atherton940274 hours ago|
parent|
[-]
People do hate on it but MySQL is what I would reach for when needing tons of scale. Its correctness issues about type conversions are super well documented at this point and Innodb is really good at ingesting tons of data. There's also a lot of talent you can hire if you need exotic setup.
reply
upvoteby cess114 hours ago|
parent|
prev|
[-]
It would be nice if you could substantiate this a bit.

Like, what kind of measurement is "largest"? Most bytes on disk?

reply