> 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)

▲

giancarlostoro 2 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.

▲

VirusNewbie 3 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.

▲

giancarlostoro 2 hours ago | parent | 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.

▲

ewild 2 hours ago | parent | prev | next [-]

there are mountains of evidence that postgres does indeed scale if thoughfully designed.

▲

SamInTheShell 2 hours ago | parent | prev | next [-]

Migrate to yugabyte? It's a multi-raft fork of postgres.

▲

Imustaskforhelp 2 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)

	▲	atherton94027 an hour 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.

▲

cess11 an hour 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?