Working with the Database

In this lesson, we develop a Go package for working with the PostgreSQL database that supports the functionality of the RESTful server. The package is named restdb and is stored in https://github.com/Educative-Content/restdb. Due to the use of Go modules, its development can take place anywhere we want in our filesystem—in this case, in the ~/code/restdb folder. So, we run go mod init github.com/Educative-Content/restdb to enable Go modules for the restdb package during its development.

Note: The RESTful server itself knows nothing about the PostgreSQL server. All related functionality is kept in the restdb package, which means that if we change the database, the handler functions do not have to know about it.

Running the database

To make things easier for the readers, the database is going to run using Docker and with a configuration that can be found in docker-compose.yml, inside the restdb GitHub repository, ...