I have used MongoDB as the main database for many small/mid-size web projects and found it to be very flexible compared to MySQL/Postgres:
- No manual database/user creation needed
- No manual table creation needed
- No schema migrations needed
- No nested relations needed, because typical web app data structures fit well as dictionaries/lists
- No extra caching layer needed because of previous point
So basically, your app is simpler, and when you give it to a co-developer who has MongoDB installed, he can just start using it. And when you develop further, you don't have to mess with the schema migrations either with co-workers or when deploying to the server.
- No manual database/user creation needed
- No manual table creation needed
- No schema migrations needed
- No nested relations needed, because typical web app data structures fit well as dictionaries/lists
- No extra caching layer needed because of previous point
So basically, your app is simpler, and when you give it to a co-developer who has MongoDB installed, he can just start using it. And when you develop further, you don't have to mess with the schema migrations either with co-workers or when deploying to the server.