Database Integration
14 lessons in this section of the Spring Boot tutorial. Work through them in order, or jump to the one you need.
- 1.MySQL Integration
MySQL is the most widely used relational database in Spring Boot applications.
- 2.PostgreSQL Integration
PostgreSQL is the preferred relational database for Spring Boot applications requiring advanced SQL features — window functions, CTEs, JSONB, full-text search, array…
- 3.MongoDB Integration
MongoDB is a document-oriented NoSQL database that stores data as flexible JSON-like BSON documents.
- 4.Oracle DB Integration
Oracle Database is the dominant enterprise relational database in large organisations.
- 5.SQL Server Integration
Microsoft SQL Server is a widely used enterprise relational database, especially in .NET and Java shops running on Windows or Azure.
- 6.H2 Database
H2 is a lightweight, pure-Java relational database that runs embedded inside the JVM or as a standalone server.
- 7.Redis Integration
Spring Boot auto-configures Redis through spring-boot-starter-data-redis, providing RedisTemplate for low-level operations, Spring Cache abstraction for…
- 8.Cassandra Integration
Spring Boot integrates with Apache Cassandra through spring-boot-starter-data-cassandra, providing CassandraTemplate for low-level operations and Spring Data…
- 9.Elasticsearch Integration
Spring Boot integrates with Elasticsearch through spring-boot-starter-data-elasticsearch, providing ElasticsearchTemplate for low-level operations and Spring Data…
- 10.Flyway Migration
Flyway is a database migration tool that versions schema changes as SQL or Java migration scripts.
- 11.Liquibase Migration
Liquibase is a database migration tool that expresses schema changes as changesets in XML, YAML, JSON, or SQL.
- 12.Multiple Databases
Spring Boot supports connecting to multiple databases in a single application by defining separate DataSource, EntityManagerFactory, and TransactionManager beans for…
- 13.Connection Pooling
Connection pooling maintains a reusable set of pre-established database connections, eliminating the overhead of creating and tearing down a TCP connection and…
- 14.HikariCP
HikariCP is the fastest and most production-ready JDBC connection pool available for Java.