- Docker (For postgres image)
- psql CLI tool (Accessing postgres database)
A Makefile has been created to handle setting up everything automatically, though you can still follow the instructions below to do it manually.
To build the project with the make file, run the command make from the repo. To clean run command, make clean
Creating a postgres database can be done with docker with the following command.
docker run --rm -p 5432:5432 --name postgres -e POSTGRES_PASSWORD=pass -d postgresThis setups an empty postgres database, that when stopped will remove all data. This example doesn't require data to persist so we can add it every time.
The schema is defined in the file ./setup/schema.sql To add schema run command, psql -U postgres -h localhost -f ./setup/schema.sql.
The data to add is in file ./setup/data.sql. To add this as well run command, psql -U postgres -h localhost -f ./setup/data.sql.
psql is a command line tool for accessing postgres databases. On Debian it can be installed with command sudo apt install postgresql-client
To access the postgres database use psql -U postgres -h localhost.
Some helpful commands with postgres are.
- \q - quit
- \l - list databases
- \c - switch database
- \du - list users, more info with \du+
- \dn - list schemas
- \dt - list tables
- \d \d+ <table name> - describe table name
More commands can be found with man psql or searching online, but the ones above are the most common I use.
Psql is a CLI tool for accessing
An Adminer image is added to the docker-compose file. Adminer provides a website shell for viewing, adding, or modifying the database data and schema. It can be accessed by going to localhost:8080 in an Internet Browser. Note that the server hostname is postgres as defined in docker-compose. Username and database are also postgres.
The satellite SQL database tracks thousands and thousands of satellites in orbit. This database is used by hundreds of clients to keep track of public records saying who has what in the sky. There is an issue though, some of the records are showing duplicates. These duplicates need to be removed, but a single entry needs to remain and which of the duplicates should be the one to remain?
View solution.md for walk through.