Checking the data on the database structure

The whole application structure is ready. Now, we can check the database to get our persisted data. There are many open source Postgres clients. We will use pgAdmin 3, as previously configured.

The first time you open the application, you will be asked about the credentials and host. We must put the same information as we configured on the application.yaml file. Then, we are able to make instructions in the database.

Before checking the database, we can use Swagger to create some categories in our CMS system. We can use the instructions provided in Chapter 2, Starting in the Spring World – The CMS Application, to create some data.

After that, we can execute the following SQL instruction in the database: ...

Get Spring 5.0 By Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.