Mongodb integration with ASP.NET MVC 5 and Postgresql

Question

I am building a project in ASP.NET MVC 5 with Postgresql database, in this database there is a history table that will grow in about 500,000 lines per month and we will have reports that will gather data from one-year periods. So we thought we’d use Mongodb for this specific table and all the rest of the database would be with Postgresql. Since we will have a much higher performance in this table using Mongodb.

Is it worth using this type of architecture with Postgresql and Mongodb in the same project? If so, what is the best way to do it and what tools? If not, what is the most appropriate method?

Answer 1

It is worth using this type of architecture with Postgresql and Mongodb in the same project?

If your project really works with relational and non-relational data, it is well worth it. And apparently, for its purpose, it is quite appropriate.

If yes, what is the best way to do and what tools?

Looks like it’s your first contact with Mongodb, right? I recommend this one introduction course to Mongodb. It helped me a lot in my first contact. And to recover the data, you can synchronize the data with an Elasticsearch with Kibana.

If not, what is the most appropriate method?

It is always the architect of the software who should make these decisions. If you are the guy who is designing the system, it is up to you to decide. Play a little with Nosql bases like Mongodb, and you will discover a new world of possibilities and breaks of some limits, of course all this along with the break of several paradigms.