Skip to main content

All Questions

Tagged with
3 votes
2 answers
427 views

What to do when putting logic into the database seems to be the only option?

I am currently working on an application that models a complex business process that consists of many steps, each having a 1:n relationship with subsequent steps. The software is written Java using ...
xgb84j's user avatar
  • 149
0 votes
1 answer
454 views

In new project where you have ability to define DB and write app code, what is seen as best practice?

Good day When starting a new project and you have access to the db as well as writing the code. In this specific case it is PostgreSQL and Java EE with JPA and Hibernate. Should one: Aim to ...
Letholdrus's user avatar
9 votes
5 answers
8k views

How to design a complex REST API considering DB performance?

I've been following some tutorials on how to design REST APIs, but I still have some big questions marks. All these tutorials show resources with relatively simple hierarchies, and I would like to ...
user3748908's user avatar
  • 1,657
2 votes
1 answer
1k views

How, in Three Tier Architecture is Database Access Achieved

So I am attempting to make an application based on the architecture proposed by this image; (source: ibm.com) [1] However, I am getting very confused with how data access is achieved between the data ...
FinalFind's user avatar
6 votes
1 answer
2k views

Is this database design good? What JPA Entities should I create for this design?

I am trying my hands on JPA. For this I am thinking of using the example of a student admission process as shown in the diagram below. Is this design good ? Any suggestions for improvement are more ...
Nils's user avatar
  • 207
2 votes
2 answers
2k views

Using Hibernate Criteria framework for complex queries vs. just making views in DB

I like using Hibernate for regular simple CRUD operations. However, I am trying to understand why anyone would resort to its Criteria framework to assemble complex recordset criteria as opposed to ...
amphibient's user avatar
  • 1,591