search

TurkuForge / baby-project-server

The solution to remote work!
3 stars 1 forks source link

(Feature) Add JOOQ and Postgress to the project #9

Open dusan-turajlic opened 3 years ago

dusan-turajlic commented 3 years ago

Detailed Description

We need an easy and simple way to write SQL in Kotlin. Non of us are fans of ORMs so we want to take use of somthing that is bare bones SQL, in comes JOOQ. In order to add this and have any benefit of is we would aslo need to add Postgress and an inital startup SQL script. Please follow the rough DB schema below (discuss the schema in this issues comments if needed).

database schema exaple

Context

This is needed so we can start

  1. Adding users and user premissions
  2. Presistently store the channel data.

Possible Implementation

Not exacrtly a possible implementation but more documentation that could help. https://www.baeldung.com/jooq-with-spring and https://www.jooq.org/doc/3.14/manual/code-generation/codegen-advanced/codegen-config-generator/

dusan-turajlic commented 2 years ago

A cleaned-up and revised version of this has been created on dbdiagram.io