Database Connection Setup

Reference (initial setup):

https://chatgpt.com/s/t_686dbcc0980c8191900cf62f892652d3

1. Add Required Dependencies

Add the following dependencies to your pom.xml to enable JPA and PostgreSQL support:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
</dependency>

2. Configure Database in application.properties

Add the PostgreSQL and JPA configuration in application.properties:

# Database configuration
spring.datasource.url=jdbc:postgresql://localhost:5432/kanban_db
spring.datasource.username=postgres
spring.datasource.password=anurag17

spring.datasource.driver-class-name=org.postgresql.Driver

# JPA / Hibernate configuration
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect