Building a complete RESTful server with database access and web client interface
In the previous recipe, we saw how to build a RESTful server. Our path is not yet complete; there are two basic elements to make sure that our server is complete:
- Database access
- Web interface for data viewing and manipulation
In the previous RESTful server we built, the data was managed through the use of an objects list. Now, we will see how to integrate a database access in order to give it an appropriate place. With regard to the visualization and manipulation of data, it is necessary to create a web interface to guarantee an adequate user experience for the described operations.
Getting ready
This recipe is an evolution of the previous one, so you can proceed by directly editing the code already written, or clone the previous one in another path and start with this new one.
The first thing we have to do is define our database. For this recipe, we will use MySQL—one of the most popular open source relational database...