We need a database design (MySQL) and a framework (Python or Ruby) that will provide access to the database via other code on the server (same language) as well as by accepting REST requests over HTTP and providing JSON responses.
The application will be used to store messages.? The database will need to store user accounts and group information.
All direct calls will need to be authenticated against the user accounts.? Remote calls will need additional authentication to ensure a valid client.
This project is for the database design, the framework design, the coding of the backend framework, and a demo application to demonstrate all features.