jabrena / spring-boot-relational-database-poc

A POC to review different ways to implement the data access layer for a relational database.
https://jabrena.github.io/spring-boot-relational-database-poc/spy_data/index.html
Apache License 2.0
3 stars 3 forks source link

Review other comparisons #60

Open jabrena opened 1 year ago

jabrena commented 1 year ago

Scenarios analized:

Fetch single entity based on primary key
Fetch list of entities based on condition
Save new single entity and return primary key
Batch insert multiple entities of the same type and return generated keys
Update single existing entity - update all fields of entity at once
Fetch many-to-one relation (Company for Department)
Fetch one-to-many relation (Departments for Company)
Update entities one-to-many relation (Departments in Company) - add two items, update two items and delete one item - all at once
Complex select - construct select where conditions based on some boolean conditions + throw in some JOINs
Call stored procedure/function and process results
Execute query using JDBC simple Statement (not PreparedStatement)
Remove single entity based on primary key
jabrena commented 1 year ago

Interesting ideas: