[BACK] Add pagination and sorting using Spring Data JPA to main page

[ArielMAJ]

Type of feature

🍕 Feature

Current behavior

The app currently loads the full transaction history, which can eventually amount to a high memory usage, once the user starts accumulating transactions and eventually lead to a server crash due to memory usage limits.

Suggested solution

Implement pagination/sorting (together with filtering) with Spring Data JPA to main page.
Docs and suggested readings:

• https://docs.spring.io/spring-data/rest/reference/paging-and-sorting.html
• https://www.baeldung.com/spring-data-jpa-pagination-sorting
• https://www.baeldung.com/jpa-pagination

Additional context

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

Contributing Docs

• I agree to follow this project's Contribution Docs