This might be useful for you.
Ask HN: Posgresql JSON or MongoDB?
21–26 of 26 posts
Re: Ask HN: Posgresql JSON or MongoDB?
#22I'm also curious if anyone has tried JSON types in Amazon PG compatible Aurora or RDS?
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.
Ok you've been using postgres RDS? Im mostly interested in Aurora.
It seems cockroachdb, aurora and cosmos are targeting similar use cases.
Re: Ask HN: Posgresql JSON or MongoDB?
#23Earlier quoted context omitted.
what about High Availability?
Just use Amazon RDS and let them deal with it. None of the theoretical scaling benefits of Mongo outweigh the clusterfuck of maintenance, data inconsistency, and other general problems that shitty, shitty piece of software has.
name checks out.
I didnt mind mongo in a couple of my previous jobs. We never noticed data issues and we did some crazy things like generating mongologs on one machine and moving them to another manually .
Re: Ask HN: Posgresql JSON or MongoDB?
#24in 2017, any db without horizontal scaling that is native is not really the best selection for large scale apps.
Re: Ask HN: Posgresql JSON or MongoDB?
#25Earlier quoted context omitted.
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.
Ok you've been using postgres RDS? Im mostly interested in Aurora. It seems cockroachdb, aurora and cosmos are targeting similar use cases.
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).
Re: Ask HN: Posgresql JSON or MongoDB?
#26I've been using CouchDB since 2009 or so and am pretty impressed by the jsonb functionality built into PostgreSQL (the RDBMS I generally use for everything). I'm building an application with an abstracted "store" and will be running benchmarks against both in the next few weeks but so far, it looks like PostgreSQL might be a bit slower when writing jsonb fields. For this application, the ease of using just PostgreSQL (versus a hybrid PostgreSQL/CouchDB back-end) is well worth that slight penalty.