Reactive Todo List with PostgreSQL and Spring Data R2DBC

This project aims to explain how to build a fully reactive application with Spring Boot, Spring Webflux, Angular, PostgreSQL and Spring Data R2DBC. It demonstrates how to deal with concurrent modifications using optimistic locking, PostgreSQL Listen/Notify and Server Sent Events.

Project structure

Local environment

Build the application

In order to build the application you need to have the following softwares installed:

• open JDK or oracle JDK >= 8
• docker & docker compose
• npm

$ build.sh

Start the application

$ start.sh

Once the application is started you can access it using the following links :

If you only want to start postgres, execute the following command

$ start.sh -postgres-only

Configure PgAdmin (PostgreSQL web Client)

Login to PgAdmin: http://localhost:5050/

• Login: [email protected]
• Password: password

Create a connection

• Server: postgres
• Database name: todolist
• User: admin
• Password: password

Stop the application

$ stop.sh

Production environment

Build the application

You need to have docker installed to build the application.

Ensure that the URL of the application has been correctly configured in the following file.

todo-list-ui/src/app/environments/environment.prod.ts

Then build the application in production mode.

$ mvnw clean install -Pprod