#Transition from Database Schema's to Java

1 messages · Page 1 of 1 (latest)

runic ledge
#

I have created a database schema for my webshop (schoolproject). And some things are not clear for me.

What are things I need to take into account when creating a database, regarding the implementation of the database into my API, because I first created the schema's before starting on my API.

Also, when creating new classes, I need to create a class for every entity in my database, is this right? Because if so, do I just copy the columns as attributes for every class/entity? And do I have to take care of the relationships?

I will be using Spring Boot as my backend framework

rich cloudBOT
#

<@&987246584574140416> please have a look, thanks.

#

You can use </chatgpt:1108714622413963314> to ask ChatGPT about your question while you wait for a human to respond.

violet hinge
#

It depends on how you're going to do it. JDBC/Spring Data (+hibernate?)/JOOQ/MyBatis.
And the classes you need to interact with should be reflected, and yes you need to take the FK into consideration.

runic ledge
#

I have not decided it yet

#

Could someone tell me when to choose which. Because I have never used any of them.

I have done a little research and on the first sight JOOQ seemed pretty nice

#

but I read from several online sources that people tend to use Hibernate and consider it to be the top dog

sacred eagle
#

there are certainly downsides to that

#

but its hard to properly qualify the upsides/downsides of any of those other options without that base experience as a reference

runic ledge
#

I will also be using Angular (requirement for the project). I have seen some online courses use Spring Data JPA. So will Angular have impact on the choice whether I use SpringD JPA or JDBC

sacred eagle
runic ledge
#

Or do they have to be in hand with eachother throughout the process

sacred eagle
#

"have" is a strong word

#

both ways can work but doing them hand in hand will lead to a better result

runic ledge
#

Okay that's good to know, but I honestly don't have general idea of how and where to start when creating the whole backend. I have only created a database schema. Is this something I will find out in the process?

sacred eagle
#

Is this something I will find out in the process?
Lets go with "potentially"

runic ledge
#

Okay than I will just seepeepo_strong