Data Persistence with PostgreSQL
By this point in the book, the frontend for our application has 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 will get rid of our JSON file and introduce a PostgreSQL database to store our data. We will do this by setting up a database development environment using Docker. We will also investigate how to monitor the Docker database container. We will then create migrations to build the schema for our database and then build data models in Rust to interact with the database. We will 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
- Configuring our application
- Managing a database connection pool...
