Ask HN: Posgresql JSON or MongoDB?

Re:Ask HN: Posgresql JSON or MongoDB? by maerF0x0 on Tuesday May 09, 2017 @10:17PM (#14305469)

I'm also curious if anyone has tried JSON types in Amazon PG compatible Aurora or RDS?

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by e1g on Tuesday May 09, 2017 @11:15PM (#14305663)

We have been using JSON on RDS extensively since 9.5. Today probably 80%+ of PG JSON capabilities are used by the app in some way for some pretty complex use-cases (fintech). Never had any issues with this on RDS - everything just works (multi-as, read replicas, performance profiling etc) and we love it. Haven't tested Aurora yet.

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by maerF0x0 on Thursday May 11, 2017 @11:56PM (#14321326)

Ok you've been using postgres RDS? Im mostly interested in Aurora.

It seems cockroachdb, aurora and cosmos are targeting similar use cases.

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by e1g on Saturday May 13, 2017 @12:25AM (#14329525)

We use Aurora for MySQL apps and love it. The PG-compliant variety is not available in our regions, so can't put it through real testing by ghosting requests yet.

IMO RDS is perfect for most use-cases. I'd strongly encourage to try it out - it's highly performant and very reliable (uhhh... well...). Aurora has a significant edge under very significant loads (i.e. >300 concurrent clients), but can be slower under typical scenarios (0-100 concurrency).

[ Parent | on HN ]