How to create a Restful web service in .Net Using MySQL?

What would be the name of this software architecture? and Do you see any immediate flaws in the design?

• I am in the planning stage of a median web application, this app is a social network for organizations such as a corporate social network, used by the staff internally, but with not much features, only the basics like as chat, real time posts, comments, etc. Here is the brief plan (a 4-tier architecture, I think so) : |---- Database (MySQL or PostgreSQL) --------| |---- Django for render the first HTML, and serve the RESTful API --------| |---- Node.js and socket.io for the real time  --------| |---- RabbitMQ for communicate between Django and Node.js  --------| |---- Backbone.js for structure the javasript code in the frontend, and HTML5/CSS3 for the UI --------| I will have a instance of Django for render html, and serve RESTful API through DjangoRestFramework, I use Django because the models and the DRF are really good for web and api development, and I have a good time working with this, but I think that this part could be replaced for another node.js instance using mongodb and mongoose instead mysql for better performance maybe. a instance of Node.js and socket.io for the real time communication with clients. RabbitMQ will allow django talk to nodejs for notify when update the clients through socket.io Backbone.js will talk to django via RESTful API, and will manage the whole frontend In a simple flow: A user enter on the app, django render only the plain html; all content like posts, comments, images, etc, are loaded by backbonejs using the RESTful API provided by django, when the user publish a post, this information will be syncronized through the RESTful API with backbonejs, django will receive the data, then will save the data, and will notify to nodejs (through rabbitmq) whose clients must be updated in real time (maybe the followers of the user), then the post will appear (in real time) using backbonejs (or only jquery maybe), but using socket.io this time not the RESTful API obviously (because is a server to client communication). I don't know very much about software architecture, which is why I've read some papers and books on this subject. The name of my proposal architecture worries me because, before developing it, I have to do the theoretical part of the project, since I have investigate and support the concepts. So not sure If my proposal is a SOA architecture, or Event-driven (for the nodejs part) or MVC (for the django part, althought I don't use the templates system in django, and only use the models and using django like as RESTful API, so I don't think that could be a MVC architecture), or ROA (resource-oriented architecture, I read this in the book: "service-oriented desing with ruby and rails") or maybe a dual MVC (MVC in frontend backbonejs, MVC in Backend django) or maybe a mixture of SOA and Publish/Subscribe message pattern and kind of MVC, or just a Service-Oriented Design. If you had any idea of ​​the name or type of architecture I describe, I'd appreciate it. And the others questions. Do you see any immediate flaws in the design? maybe other stack of technologies?, maybe some technology would be replace for better one? Bear in mind that this application is for medium organization, so the number of users won't be more than 1000  or 10 000 as maximum, and is for these that I don't thinks about horizontal scaling, denormalization, or use NoSQL databases, or many instances of the django and nodejs servers, or using proxy server such nginx for load balance (but this could be good using). Thanks for your time :)

• Answer:

  While there is nothing wrong in the individual components you have chosen, they are just too many stacks to manage for an application. You can significantly minimize the number of components by choosing javascript as your language for the client (via Backbone or Ember or Angular) and a NodeJS framework like Express for the application server that also lets you add realtime functionality. And depending on your application's data storage requirements you can pick between MongoDB or Postgres.