spring-projects / spring-projects/spring-data-relational

Add projection support (and fluent API) to `JdbcAggregateTemplate`

Open
#2,109 0 comments 2 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

type: enhancement
Dominant language
Java
Stars
827
Forks
394
PR merge metrics
No merged PRs in 30d

Description

It would be neat to have projection support, ideally through a fluent API (similar to R2DBC, Cassandra, and MongoDB) to apply projections much closer to the query and conversion instead of fetching and materializing entities and running DTO conversion afterwards.

See also #2098 and #1870 as triggers for this ticket.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by inspecting JdbcAggregateTemplate and comparing the referenced FluentR2dbcOperations API, along with the projection approaches in Cassandra and MongoDB. Define how a fluent API should apply projections during query and conversion, then verify that JdbcAggregateTemplate supports the requested projection behavior without post-fetch entity materialization.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, spring
Domain
database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.