What's a good way of getting started with utilizing databases in Java for desktop apps?

[paper jungle]

Hi, I am getting started on a database java course in a few weeks and I want to get started with playing around with some personal app projects. What's a good way of getting started, and what should my focus be on?

For now, I want to just make desktop apps that utilize databases, and not web-based apps.

Thanks in advance!

[rapid pagoda]

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

[rapid pagoda]

While you are waiting for getting help, here are some tips to improve your experience:

Code is much easier to read if posted with syntax highlighting and proper formatting.

If nobody is calling back, that usually means that your question was not well asked and hence nobody feels confident enough answering. Try to use your time to elaborate, provide details, context, more code, examples and maybe some screenshots. With enough info, someone knows the answer for sure.

Don't forget to close your thread using the command </help-thread close:1027500463647621170> when your question has been answered, thanks.

[hollow flower]

I think it depends on if you are comfortable with sql or not? You could just go through some in memory databases which are easy to setup such as h2 database and just play around with JDBC

There are some quality of life things such as flyaway or JOOQ you can look into

But to get a good grasp, I’d recommend just connecting a basic Java app with an in memory database and messing around with query statements to get a feel for what’s happening

If you want to get a little fancier though, I would recommend looking into JOOQ since it’s incredibly nice. It auto generates java classes based on your schema and is type safe which is convenient

[paper jungle]

@hollow flower what about getting started with setting up a server? would mongodb be a good option, or are there better options out there?

I have plenty of available system resources for whatever server options are out there, I'd like to host whatever myself if possible.

[hollow flower]

Mongodb would be considered a non relational database. If you want to go that route, it’s quite easy to setup

If you want a relational database, you could lean towards postgres

Both are easy to host, it really depends on if you want sql or nosql

I think for learning purposes, it’s nice to start with sql

[paper jungle]

@hollow flower thanks for the help. I was able to get a google cloud postgresql server setup and was able to get connected to it on my ide.