News for hackers. Stuff that matters.
Re:Using Postgres for Everything by dangoodmanUT on Monday May 20, 2024 @03:52PM (#40419505)
On the other hand, this is backing companies into corners that are dangerously hard to get out of.
Re:Using Postgres for Everything by whateveracct on Monday May 20, 2024 @04:22PM (#40419846)
100s of engineers all coding against the same Postgres database becomes a pain. Lack of decentralization leads to silly outages due to people sharing resources they really shouldn't.
Re:Using Postgres for Everything by vrosas on Monday May 20, 2024 @04:34PM (#40419998)
In my experience it's really hard to prevent issues like this. RDBMS's kind of push you to keeping everything in the same database to take advantage of foreign keys and other features when in reality different data types will need their own source of record. I consider myself more experienced than most and I still fell into this trap in recent memory, failing to expect the scaling requirements for one of my tables until it was too late.
Re:Using Postgres for Everything by schainks on Monday May 20, 2024 @04:36PM (#40420023)
Can you say more about this? Seems like an organizational / communication problem than a technical one.
Re:Using Postgres for Everything by dboreham on Monday May 20, 2024 @08:22PM (#40422434)
Not the parent but I've seen this scenario a few times. Essentially what you get is random groups of devs (often you never even knew they existed or were messing with your DB) who mount a DoS attack (not their intention but that's the result). Long lived transactions, unindexed queries, unexpected deadlocks, etc etc. Worst thing is their reaction is that your database sucks. So no amount of education will fix the problem. They think you're the problem. So you end up with a defensive architecture where the blast radius for any single act of stupidity is limited.
Re:Using Postgres for Everything by simonw on Monday May 20, 2024 @04:51PM (#40420212)
That's a great problem to hold off on tackling until you have hundreds of engineers.
Re:Using Postgres for Everything by smt88 on Monday May 20, 2024 @04:17PM (#40419789)
Postgres is the only RDBMS that is not backing companies into corners because so many products are forks of it or "speak" Postgres. You can completely swap out your database without changing any of your code. There is no other database that lets you shop around (or upgrade to a more specialized product) like that.
Re:Using Postgres for Everything by vrosas on Monday May 20, 2024 @04:30PM (#40419943)
> You can completely swap out your database without changing any of your code

Uhhhh in theory... maybe... not really. Switching PG out from under our relatively toy-ish SaaS product would be a huge undertaking.

Re:Using Postgres for Everything by smt88 on Monday May 20, 2024 @06:04PM (#40420996)
Assuming you're tolerant of downtime, why would it be a huge undertaking? You could write the code to do it in 10 minutes.
Re:Using Postgres for Everything by dangoodmanUT on Monday May 20, 2024 @03:53PM (#40419521)
And on the third hand, Timescale is not advised to be your production OLTP if you're using Timescale cloud, so it's a strange double-standard that they are communicating here since they cluster totally differently than normal OLTP postgres workloads? Or maybe I skimmed it to fast and haven't used Timescale in a while
Re:Using Postgres for Everything by akulkarni on Monday May 20, 2024 @04:45PM (#40420125)
(Timescale co-founder)

We actually have 100s of customers who use Timescale for their production time-series _and_ OLTP workloads :-)

Re:Using Postgres for Everything by monero-xmr on Monday May 20, 2024 @04:03PM (#40419650)
I don’t know about timescale specifically but using Postgres for everything is the safest thing you can possibly do as a startup.
Re:Using Postgres for Everything by sophacles on Monday May 20, 2024 @03:58PM (#40419569)
Which corners, and what dangers?
Re:Using Postgres for Everything by VeejayRampay on Monday May 20, 2024 @04:13PM (#40419741)
those corners do not exist, but people love yo create artificial needs to justify unneeded complexity
Re:Using Postgres for Everything by from-nibly on Monday May 20, 2024 @04:23PM (#40419866)
Not any more dangerous than any other technical choice.
Re:Using Postgres for Everything by ZitchDog on Monday May 20, 2024 @04:24PM (#40419876)
I would much rather inherit and optimize someone's postgres DB with specific scaling challenges than a prematurely optimized multi-database solution built for "web scale".