google / google/adk-java

Implement Database-Backed Session Storage (DatabaseSessionService) for ADK Java

Offen
#665 3 Kommentare 0 Reaktionen 1 zugewiesene Person Beansprucht von @hemasekhar-p Auf GitHub ansehen
contrib needs review
Vorherrschende Sprache
Java
Sterne
1.7k
Forks
420
Ø Merge
4 T. 12 Std.
Gemergte PRs (30 T.)
31

Beschreibung

ADK Java currently provides only in-memory session storage, which is not suitable for production environments that require durable, consistent, and queryable session/state/event storage.

Projects building on ADK often need:

- Persistent session storage across restarts
- Reliable event logging and retrieval
- Concurrency-safe updates
- Support for standard relational databases
- Schema versioning for continuous delivery

## Describe the solution you'd like

Introduce a production-ready database-backed session service (`DatabaseSessionService`) that provides durable storage for sessions, events, and state.

### Key characteristics:

- **Pure JDBC implementation** with zero ORM dependencies
- **HikariCP** connection pooling for high performance
- **Flyway** migrations for schema versioning and zero-downtime deployments
- **Multi-database support**: PostgreSQL, MySQL, H2, Cloud Spanner (SQLite not supported)
- **3-tier state storage**: Separate tables for app-level, user-level, and session-level state
- **Pessimistic locking** for safe concurrent updates
- **Dialect-aware JSON handling** (JSONB for PostgreSQL, JSON for MySQL, CLOB for others)
- **Reactive API** with RxJava 3 (Single/Maybe/Completable)
- **Event filtering and pagination**
- **Comprehensive test coverage** using H2 and integration tests on actual databases (PostgreSQL, MySQL, Spanner) running in Docker

This service offers a robust, scalable alternative to the current in-memory session implementation without introducing heavy ORM dependencies.

## Describe alternatives you've considered

**Providing this as an external extension/library**
- Persistent sessions are commonly required; shipping this in-core provides a better out-of-the-box experience.

**Continuing with in-memory storage only**
- Not viable for production deployments requiring durability or concurrency guarantees.

**Using Hibernate/JPA**
- Adds significant dependency overhead and complexity; pure JDBC provides better control and performance.

## Additional context

The Python ADK includes a production-grade `DatabaseSessionService` that is widely used in real-world workloads (including GKE deployments). Adding equivalent persistent session storage to ADK Java would
provide consistency across ADK environments and reduce the need for custom user-built solutions.

An implementation is available in PR: https://github.com/google/adk-java/pull/700

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.