Chapter 6: Data Persistence with PostgreSQL

The frontend has now been defined, and our app is working at face value. However, we know that our app is reading and writing from a JSON file.

In this chapter, we get rid of our JSON file and introduce a PostgreSQL database to store our data. We do this by setting up a database development environment using Docker. We also look into how to monitor the Docker database container. We then create migrations in order to build the schema for our database, and then build data models in Rust to interact with the database. We then refactor our app so that the create, edit, and delete endpoints interact with the database instead of the JSON file.

In this chapter, we will cover the following topics:

• Building our PostgreSQL database
• Connecting to PostgreSQL with Diesel
• Connecting our application to PostgreSQL
• Creating our data models and migrations
• Getting data from the database
• Inserting data into the database
...