5 ms·
MongoDB is distributed, PostGreSQL and SQlite are not. However you have tools to use PostGreSQL and SQLite in a distributed way, like Citus or DQlite. Do you
by speedgoose 5y ago
MongoDB is distributed, PostGreSQL and SQlite are not.
However you have tools to use PostGreSQL and SQLite in a distributed way, like Citus or DQlite.
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.
- snorkel 5y agoGood point. MongoDB scales horizontally (add more servers) PostgreSQL scales vertically (get a bigger server) which is the least desirable way to scale, in addition to be being reliant on fewer servers makes it less fault tolerant. MongoDB is also schema-less which is convenient for developers and makes change management easier , but the cost is your app has an undocumented and unrestricted data model that only your core devs can partially explain, and your business analysts absolutely hate anything that isn’t standard SQL. So the story with MongoDB is core app devs still love it, operations is OK with it, and for everyone else you better copy that biz data into something that speaks standard SQL or the analysts will riot.
- rad_gruchalski 5y ago> MongoDB is distributed, PostGreSQL and SQlite are not. YugabyteDB is distributed and Postgres 11.2 compatible. AFAIK it will be 13.x compatible soon.
- canterburry 5y agoStill an excellent comparison https://youtu.be/b2F-DItXtZs https://youtu.be/b2F-DItXtZs