Ask HN: Is MongoDB obsolote when Postgres and SQLite provide JSON types?

Building complex queries in MongoDB is a huge pain in the ass (aka aggregations). For all the same operations you need to figure out how to do, it&#x27;s significantly easier to do in Postgres. This is especially if you involve MongoDB subdocuments in your query.<p>Subdocuments in MongoDB are a footgun where I&#x27;ve seen it go wrong most of the time (as in the consequence is more complicated querying syntax is required) that having that data as a subdocument should have been in a collection instead.<p>The API for transactions in the Node.js drivers has around two variants of how transactions should work, and require very specific conditions to work correctly (for example, you can only create indices in a transaction if the collection is empty), and it&#x27;s hard to find documentation on a working transactional sample.<p>I would never recommend MongoDB to anyone, and if one wanted to, then use Postgres with JSON types.

Have used both. Depends how you use them.<p>If you use jsonb of postgres to just dump things you don&#x27;t query on, it&#x27;s fine. If you try to cheat and dump your mongo schema into a jsonb field, you&#x27;re gonna have a bad time.<p>JSON queries in postgres are, IMO, extremely nonobvious. It seems like any time we wanted to run some rather simple report that involved json fields, some poor dev had to spend ten or more minutes figuring out the correct syntax to do so. Mongo is an absolute breeze in comparison.<p>Person opinion? JSON doesn&#x27;t belong in the db, make a proper schema. If you don&#x27;t want to do that, or don&#x27;t like or want to learn SQL, just use Mongo or some equivalent.

MongoDB is distributed, PostGreSQL and SQlite are not.<p>However you have tools to use PostGreSQL and SQLite in a distributed way, like Citus or DQlite.<p>Do you want or need a distributed database ? If not, you can safely ignore MongoDB and similar databases. Non distributed databases are much simpler to administrate and use.

Isn&#x27;t the whole fuss around document based DBs all around good speed and less integrity, and most RDS more about integrity?<p>Things like storing logs -&gt; document DB.<p>Ecommerce schema with carts, orders, payments, addresses, products, etc -&gt; RDS<p>?

My background here is just a user of both, nothing too deep or profound. I guess I&#x27;ve also got a few nights on a project to make a mongodb compliant API for postgres jsonb in python.<p>Obsolete feels like a strong term. for a problem thats truly document oriented workloads mongodb still seems more efficient, if not in literal performance then in scope and understandability. the mongodb API is the defacto &quot;standard&quot; API for document dbs as far as I can tell, and realistically SQL is a notable barrier for application devs. Also, operationally, mongodb is easier to run, between Atlas and having more clustering capabilities available for &quot;easy&quot;. Those two things mean you _can_ move faster than with postgres (with the same relative amount of knowledge)<p>That said, for the aforementioned side project, a few nights got me the basic pieces of the API in place (next big step is the aggregation pipeline, which id argue is intermediate for mongodb and much less used), so it&#x27;s not hard to adapt a codebase to pg&#x2F;jsonb. And imo there aren&#x27;t that many hardcore document only problems at the small or even medium size. And once you&#x27;re at medium to large, the mongodb pain of transactions as a second class citizen, lack of data integrity options, schema fluidity, and overall less strict structuring makes Pg much more appealing. Pg&#x2F;jsonb is powerful, and if you have someone willing to be a db admin postgres is extremely powerful.<p>So, mongodb maybe not Obsolete (it&#x27;s popularity would attest otherwise if nothing else), but id take a better option if I were able. But if I needed a FE or mid-tier application dev to magically be an infra person, mongodb starts looking good again.

I may be talking out of my ass here, but the key decider is your ability to maintain the conceptual integrity of your data architecture. Mongo makes it easy to maintain document based data architecture, Postgres does not. But maybe you don&#x27;t really need a document based data architecture, you just think you do and it&#x27;s mainly not document based, only a little bit. Or maybe it&#x27;s just too damn hard to maintain your concepts in a SQL database. Maintaining conceptual data architecture is hard and sometimes too hard.

I understand that JSON supporting SQL databases struggle to index and search through JSON. I&#x27;ve had a much better time querying JSON objects from Mongo than Postgres.

It has been a long while, but I once used a master MongoDB node to store samples from a twitter stream, then used a couple of read replicas for analytics. Probably better ways to do that now.<p>Sorry for being off topic, but I used to be very enthusiastic about CouchDB and Big Couch.<p>Probably best to use the best tool for the job, but for many years I got in the habit of using Postgres for almost everything, and now I use SQLite for most of my personal projects.

I guess it depends what you&#x27;re doing? My girlfriend works as a data engineer and as far as I understand it&#x27;s used in that field as a first layer to pipe a bunch of different raw data sources into before analyzing and&#x2F;or moving it over to a more structured database like Postgres.

As a user of both and others (we have legacy couchdb applications for instance), I agree with some others here; Postgres is not handy for querying. Maybe some extension will be made for that in the future, but for now I see them for different use cases.

An older comment of mine but not much has changed: <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=23271085" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=23271085</a>

Yes. There hasn&#x27;t been a good reason to choose MongoDB for years now.<p>There are better NoSQL DBs than Mongo, but most people are better off with a hybrid like Postgres.

I don&#x27;t think so, I tried to mimic mongodb using sqlite, some operators can be difficult to do, for example $in

When you need high write throughput and you don&#x27;t care about transactions, basically.

Mongodb has a sales team. The stock values the company at a 25 billion dollar market cap. Sales will make it so your company may end up using it whether you think it’s obsolete or not.