From Node to Ruby on Rails

Re:From Node to Ruby on Rails by sam0x17 on Thursday December 16, 2021 @11:10AM (#29579678)

DB-wise we utilize the usual postgresql cluster setup with read clones in several regions. We could easily partition by course or by org if we had to but honestly we could probably scale up to series C+ before needing to do that.

[ Parent | on HN ]

Re:From Node to Ruby on Rails by gregplaysguitar on Thursday December 16, 2021 @07:41PM (#29586138)

Out of interest, have you considered moving to a "serverless" db like Aurora Postgres or even DynamoDb, to avoid the cost of unused database capacity at idle times?

[ Parent | on HN ]

Re:From Node to Ruby on Rails by sam0x17 on Friday December 17, 2021 @01:42PM (#29596414)

I'd love to, but when I've tried to set up Aurora, it seems impossible to do multi-regional with postgresql (not multi-zonal, but multi-regional). Would love to hear how to do this if anyone has got it working. Last time I tried was about 2 years ago.

[ Parent | on HN ]

Re:From Node to Ruby on Rails by gregplaysguitar on Friday December 17, 2021 @04:16PM (#29598451)

Ah ok, interesting - I haven't tried Aurora, my company uses a mixture of RDS postgres and Dynamo. Cockroachdb and Yugabyte also seem like good options but a harder sell for us not being AWS native.

More generally though, all of these "newsql" offerings feel a little too good to be true for me, I can't see how you could really have all the relational integrity of postgres with the elastic scalability of a distributed DB without trading something off. Am I too cynical?

[ Parent | on HN ]