MongoDB Integration with ASP.NET MVC 5 and PostgreSQL

0

I am building an ASP.NET MVC 5 project with PostgreSQL database, in this database there is a history table that will grow by about 500,000 lines per month and we will have reports that will take data from periods of one year. So we thought about using MongoDb for this particular table and the rest of the database would be with PostgreSQL. Since we will perform much better on this table using MongoDb.

Is it worth using this kind 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?

    
asked by anonymous 20.03.2017 / 15:25

1 answer

2
  

Is it worth using this kind of architecture with PostgreSQL and MongoDb in the same project?

If your project really works with relational and non-relational data, it's worth a lot. And apparently, to its end, it's quite appropriate.

  

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

It looks like it will be your first contact with MongoDb, right? I recommend this introduction course to MongoDB . Helped me a lot on my first contact. And to recover the data, you can synchronize the data with ElasticSearch with Kibana.

  

If not, what is the most appropriate method?

It is always the software architect who must make these decisions. If you are the guy who is designing the system, you should decide. Play a bit 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 breaking of several paradigms.

    
22.03.2017 / 11:47