Learning Postgres

The purpose of this repository is to practice acquired knowledge in build web services with TypeScript as well as your ecosystem

The purpose of this branch is to find out the best setup and usage of the specified stack. Each branch at this repo has a unique stack, take a look at all branches.

Stack

The server is based on

• TypeScript
• Node.js
• Express
• PostgreSQL
• Swagger

The client is based on

• TypeScript
• React.js
• SWR

The server implement the Relay Cursor Connections Specification to handle paginated list

Development

Server

You can start the server in development mode executing the command below

docker compose up server

To add sample data to feed the application

docker compose run --rm database_seed

To run test in development mode

docker compose run --rm server npm run test:dev

Client

To run the client in development mode execute the command below

docker compose up client

References

Some links that have somehow helped to develop this project or influence my decisions

Docs

• The TypeScript Handbook
• Swagger OpenAPI Guide
• SWR Getting Started
• Postgres - Don't Do This

Articles

• Five ways to paginate in Postgres, from the basic to the exotic