News for hackers. Stuff that matters.
Re:PostgreSQL is the worlds’ best database by me551ah on Friday April 03, 2020 @06:02AM (#22767713)
Having migrated a postgres database to dynamodb, I would say that I'm never going to use postgres again.

The problem with all SQL databases is that they are too easy to query and use. You add all kinds of select queries, joins and foreign keys and when traffic hits scramble to make it scale. NoSQL is hard to design but you can atleast be sure that once traffic hits, you don't have to redesign the schema to make it scale.

Re:PostgreSQL is the worlds’ best database by hnarn on Friday April 03, 2020 @06:10AM (#22767752)
> You add all kinds of select queries, joins and foreign keys and when traffic hits scramble to make it scale. NoSQL is hard to design but you can atleast be sure that once traffic hits, you don't have to redesign the schema to make it scale.

Surely this depends on how you set up your SQL database to begin with? I'm not familiar with NoSQL, so can you explain why "schemas" aren't necessary and scaling happens automatically?

Re:PostgreSQL is the worlds’ best database by me551ah on Friday April 03, 2020 @07:00AM (#22767975)
You could design a SQL database to be denormalized from the start, but then you are losing many of the advantages of a SQL database.

I never said that schemas aren't necessary, just that using a strict NoSQL database forces you to think about scaling constraints early. This avoids(atleast partially) a schema redesign later.

Re:PostgreSQL is the worlds’ best database by g4nt1 on Friday April 03, 2020 @04:38PM (#22773728)
Ah yes! Optimize early, that's what my teachers always told me to do. /s
Re:PostgreSQL is the worlds’ best database by lmm on Friday April 03, 2020 @06:54PM (#22774720)
Code is easy to change. Data schemata much less so, particularly in traditional SQL databases.
Re:PostgreSQL is the worlds’ best database by DeathArrow on Friday April 03, 2020 @07:51AM (#22768243)
You don't have joins in NoSQL so you have to keep data denormalized. That means data isn't consistent and you can have an will have (at a high enough data volume) errors if you aren't extremely cautious on how you update and add new data. That might matter or not in a particular business case.
Re:PostgreSQL is the worlds’ best database by GenericsMotors on Friday April 03, 2020 @06:00PM (#22774366)
I really hope the GP doesn't work on anything handling financial transactions.
Re:PostgreSQL is the worlds’ best database by DeathArrow on Saturday April 04, 2020 @04:29AM (#22776987)
If speed it's only thing that matters, he can use /dev/null for writes and /dev/urandom for reads. That's also very scalable.
Re:PostgreSQL is the worlds’ best database by 32gbsd on Friday April 03, 2020 @01:10PM (#22771606)
Some say that scaling is a edge case. what say you?