Full-stack project for working with a database storing market information.
This project is a full-fledged web application that allows you to work with a database of market information.
In essence, the project is a logical continuation of the project related to the development of a database to store market information. Database.
Implemented:
- CRUD for all tables in the database
- Calling functions and procedures in the database
- Import and export tables to csv
- Convenient web interface
- Authorization
- Query execution from various roles at the database level
- Proxy server
- Logging
What was used:
- Frontend -
JS + React - Backend -
Golang + Chi - Database -
PostgreSQL - Proxy -
Nginx
All components of the project are launched in separate docker containers and united in one layer using docker-compose. Accordingly, docker and docker-compose are required to run this application.
The application uses the following ports:
- 4500 - proxy (main)
- 3000 - frontend
- 8080 - backend
- 5432 - database
To run the make application to clear the docker containers cache make clean.
As noted, the application implements authorization and execution of queries to the database from various roles.
Role credits:
| Role | Logs | Password |
|---|---|---|
| admin | admin | admin |
| visitor | visitor | visitor |
Operations available for roles:
| Role | Tables | Views | Functions | Export | Import |
|---|---|---|---|---|---|
| admin | CRUD | -RU- | + | + | + |
| visitor | -R-- | -R-- | + | + | - |
Authorization
Table
Performance
Add to table
Removing from a table
