16 docs tagged with "databases"

Why connection pooling is essential, how HikariCP works, and how to configure it correctly in Spring Boot applications.

Hands-on Spring Boot HikariCP configuration examples, pool monitoring, leak detection, and Kubernetes multi-pod sizing.

Consolidated interview Q&A for the Databases domain — SQL, indexes, transactions, connection pooling, NoSQL, and schema migration — beginner through advanced.

Quick-reference summary of SQL, indexes, transactions, connection pooling, NoSQL trade-offs, and schema migration for Java backend engineers.

Step-by-step runnable examples for MySQL vs PostgreSQL vs H2 — UUID primary keys, H2 compatibility mode, profile-based datasource switching, and Testcontainers.

How database indexes work, when to add them, how to read EXPLAIN plans, and common indexing pitfalls that hurt performance.

Hands-on examples covering index creation, composite indexes, covering indexes, and reading EXPLAIN plans in PostgreSQL.

Practical guide to MySQL, PostgreSQL, and H2 for Java developers — architecture differences, UUID handling, H2 for development, and migration paths to production databases.

CAP theorem, BASE properties, and when to choose Redis, MongoDB, Cassandra, or Elasticsearch over a relational database.

Hands-on Spring Boot examples for Redis caching, MongoDB document CRUD, and Spring Cache abstraction.

Step-by-step Flyway and Liquibase migration examples in Spring Boot — from first migration to rollback-safe production patterns.

How to manage database schema evolution safely in Spring Boot using versioned migrations with Flyway and Liquibase.

Core SQL syntax and concepts — SELECT, JOIN types, GROUP BY, window functions, and subqueries — with Spring Boot JDBC context.

Hands-on SQL examples covering JOINs, GROUP BY, window functions, and subqueries in a Spring Boot JDBC context.

Database transactions, the four ACID properties, isolation levels, and how deadlocks occur — with Spring @Transactional context.

Hands-on examples of Spring @Transactional — propagation, isolation levels, deadlock handling, and common pitfalls.