NikitaShkaruba/orbs.io

Integrate PostgreSQL

Closed this issue · 7 comments

NikitaShkaruba commented

After we will follow through all the tutorial steps, our app will still not have any db connections So your job is to integrate PostgreSQL.
List of JPA technologies i know:

  • Spring DAO
  • Spring JDBC
  • Spring ORM
  • Spring-data(current version)

You got to find out the best one for our needs.

Vergir commented

I hosted our database on Heroku.
There is a tutorial (JDBC) for when we will actually need to integrate it.

Issue is gonig to stay open for a moment being for we are yet to integrate this db with our app

NikitaShkaruba commented

Why heroku if we have VPSs? You don't want to run local db-server on your machine?
At least, with your idea of remote db, we can set two(develop and production) databases up on our remote vps. But with that we will have full ssh access.

Tutorial is ok.

Vergir commented

@SigmaOne Elaborate on our VPS please? As for second question, I can't keep my laptop running 24/7 with internet connection just in case someone wants to debug in 01:00 AM

NikitaShkaruba commented

@Vergir, wait, what? Vps stands for Virtual Private Server - remote machine with ssh access for some users.
I have one in Amsterdam, and i asked you today 😅 to get yourself one, have you forgot?

I'll gather ssh public keys from every team member so you guys will have access to vps too.

Vergir commented

@SigmaOne Oh really? I thought VPS stands for Vape Power Supply. Thanks for claryfying! And so kind of you to tell me what it is also :):):):):)))))
I did what you ask, and in our conversation there was not a single word about Github Student Pack having a VPS service, but I guess I should have looked that up.

NikitaShkaruba commented

Update:
Please start integrating PostgreSQL with our simple employee entity.

NikitaShkaruba commented

We refused the idea of using database, because right now, we don't have registration features.