Java & PostgreSQL - using them together?
Hi,
I can understand Java and PostgreSQL in isolation. However, I struggle with understanding how I can combine the two. Both the basics of how to do it (I heard something called JDBC, and also Doobie but perhaps thats only Scala, but didn't learn it so far), but also how to know WHEN to use the SQL and when to write Java code.
For example, I might want to connect my Java program to a database that stores all the users of a bank account. I would like to be able to fetch the users balance at a given date, but it would be horribly slow if all of it was done in Java, so we would have to create some kind of database in PostgreSQL.
This is an easy example, but in other cases I don't have any real guidestick (syntactically, algorithmatically, and architecture/system design wise) to know when to write Java code and when to write PostgreSQL code, and how to combine them.
Any course or material is appreciated. For example if you know a good udemy course that teaches this or something else (perhaps neetcode? but maybe he doesnt teach postgreSQL).
I can understand Java and PostgreSQL in isolation. However, I struggle with understanding how I can combine the two. Both the basics of how to do it (I heard something called JDBC, and also Doobie but perhaps thats only Scala, but didn't learn it so far), but also how to know WHEN to use the SQL and when to write Java code.
For example, I might want to connect my Java program to a database that stores all the users of a bank account. I would like to be able to fetch the users balance at a given date, but it would be horribly slow if all of it was done in Java, so we would have to create some kind of database in PostgreSQL.
This is an easy example, but in other cases I don't have any real guidestick (syntactically, algorithmatically, and architecture/system design wise) to know when to write Java code and when to write PostgreSQL code, and how to combine them.
Any course or material is appreciated. For example if you know a good udemy course that teaches this or something else (perhaps neetcode? but maybe he doesnt teach postgreSQL).
