- Spring Data Native Query to DTO
Let’s show how you can map a native SQL query to a DTO directly. Using AliasToBeanResultTransformer All the fields in the DTO, in this case UserFullDto, must have the same names as the result set returned from the query. If a query field name is not found in the dto then it will through an […]
- Postgres – Aggregation and GROUP BY
count, sum, avg, min, max, and the rule that decides what may appear in the SELECT list. WHERE versus HAVING and why the order matters for speed, count(*) versus count(column) on nullable data, FILTER for counting several things in one pass, string_agg and array_agg, and GROUPING SETS for a subtotal row without a second query.
- Spring Data Custom Select Query with Join
In this tutorial, I am going to show you how to use JOIN in custom spring JPA queries. The join is always on the id column. Multiple Joins
- Git merge
The merge command is used to bring together changes from two branches. For example, if you have a feature branch that is branched off of the master branch. When you are done with that feature branch you can use the merge command to merge it back to master. We will assume receiving-branch to be […]
- Git rebase
The rebase command is used to bring changes from another branch, usually a branch from which the current branch migrated from. It is basically putting the changes on the base and not on top. You can always rebase from master which is the source of truth. # 1 – pull latest code from master […]