4 ms·
I'm also curious if anyone has tried JSON types in Amazon PG compatible Aurora or RDS?
by maerF0x0 10y ago
I'm also curious if anyone has tried JSON types in Amazon PG compatible Aurora or RDS?
- e1g 10y agoWe 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.
- maerF0x0 10y agoOk you've been using postgres RDS? Im mostly interested in Aurora. It seems cockroachdb, aurora and cosmos are targeting similar use cases.
- e1g 10y agoWe 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).