Some hosts CPU lack AVX support required to run Mongo. In this case, user must use either Postgres or SQLite.
In other case, user has already figured out Postgres backup solution. In this case, users will likely prefer to use Postgres again in order to re-use the same backup solution.
Those two are the most important factors. If neither apply to you, then go ahead and use Mongo, as it achieves marginally better performance without overhead of FerretDB translation layer.
@mbecker20 commented on GitHub (Jan 5, 2025):
Some hosts CPU lack AVX support required to run Mongo. In this case, user must use either Postgres or SQLite.
In other case, user has already figured out Postgres backup solution. In this case, users will likely prefer to use Postgres again in order to re-use the same backup solution.
Those two are the most important factors. If neither apply to you, then go ahead and use Mongo, as it achieves marginally better performance without overhead of FerretDB translation layer.
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Originally created by @lordraiden on GitHub (Jan 5, 2025).
What is the recommended database? Any advantage to use mongodb or postgres?
@mbecker20 commented on GitHub (Jan 5, 2025):
Some hosts CPU lack AVX support required to run Mongo. In this case, user must use either Postgres or SQLite.
In other case, user has already figured out Postgres backup solution. In this case, users will likely prefer to use Postgres again in order to re-use the same backup solution.
Those two are the most important factors. If neither apply to you, then go ahead and use Mongo, as it achieves marginally better performance without overhead of FerretDB translation layer.