This is an old revision of the document!
04. [10p] Administrating a database
Subtasks
- go to the Adminer interface on http://localhost:8080 (or see lab 3 if you are working on Play with Docker)
- log into the database using the following details:
- System: PostgreSQL
- Server: lab4-db
- Username: admin
- Password: admin
- Database: books
- check that you can observe a table called books and click on it
- click the Select data button to see the books already in the database (you should see the book you previously added)
- click the New item button and add a new book (you should only fill in the title and author text boxes and then press Save)
- using Postman, send a GET request and check that the backend also returns the book you added in Adminer
What to upload
- print screens from Adminer showing the books table and the new book you add
- print screens from Postman with the GET request showing the newly-added book
