In modern application development, integrating a robust relational database is essential. PostgreSQL, a powerful open-source RDBMS, is a popular choice among developers. This guide will walk you through the complete setup of Spring Boot and PostgreSQL integration, from dependencies to CRUD operations.
๐งฉ Why Choose PostgreSQL?
PostgreSQL offers advanced features such as:
- Full ACID compliance
- JSON and array support
- Custom data types and extensions
When paired with Spring Boot, it becomes easier to develop scalable, data-driven applications.
๐ฆ Project Setup
1. Create a Spring Boot Project
Use Spring Initializr with the following dependencies:
- Spring Web
- Spring Data JPA
- PostgreSQL Driver
2. Add Dependencies in pom.xml
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-data-jpa</artifactid> </dependency> <dependency> <groupid>org.postgresql</groupid> <artifactid>postgresql</artifactid> <scope>runtime</scope> </dependency> |
โ๏ธ PostgreSQL Configuration in application.yml
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
spring: datasource: url: jdbc:postgresql://localhost:5432/mydb username: myuser password: mypassword jpa: hibernate: ddl-auto: update show-sql: true database-platform: org.hibernate.dialect.PostgreSQLDialect |
This configuration completes the core part of Spring Boot PostgreSQL integration.
๐งพ Define the Entity Class
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
@Entity public class Book { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String title; private String author; // Getters and Setters } |
๐๏ธ Create a Repository Interface
|
1 2 3 4 5 |
public interface BookRepository extends JpaRepository<Book, Long> { List<Book> findByAuthor(String author); } |
๐ Create a REST Controller
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
@RestController @RequestMapping("/books") public class BookController { @Autowired private BookRepository bookRepository; @PostMapping public Book create(@RequestBody Book book) { return bookRepository.save(book); } @GetMapping public List<Book> getAll() { return bookRepository.findAll(); } } |
๐งช Testing the API
- Run your PostgreSQL instance (locally or via Docker).
- Start your Spring Boot application.
- Use Postman or
curlto test/booksendpoints.
Congratulations! You now have a fully working Spring Boot PostgreSQL integration with CRUD capabilities.
โ Best Practices
- Use environment-specific
application-*.ymlfor credentials - Set up connection pooling with HikariCP (default)
- Version control schema with Liquibase or Flyway
- Handle exceptions globally with
@ControllerAdvice
๐งฉ Conclusion
Integrating PostgreSQL into your Spring Boot application is a solid choice for enterprise-grade data management. By following this guide , you ensure your application has a stable and scalable database layer with minimal setup.