Describe the bug
In the following documentation for the DatabaseSessionService, a synchronous implementation is shown for the SQLite example. However, the internal implementation of the service (built on top of SQLAlchemy) does not allow using SQLite in a synchronous approach, which causes the code to crash. This can be misleading for users.
To Reproduce
Steps to reproduce the behavior:
- Go to https://google.github.io/adk-docs/sessions/session/#sessionservice-implementations
- Navigate to the
DatabaseSessionService section
- Copy and paste the example code into your IDE
- Run the code
Expected behavior
The code should run successfully without major issues and create the SQLite database.
Screenshots
Image extracted from the following issue: google/adk-python#3916
Versions
- OS: Arch Linux
- ADK version: 1.21.0
- Python version: CPython 3.11
Additional context
I tested the same scenario as the issue creator on my device and encountered the same problem. After switching to the async driver, it worked without major issues.
Describe the bug
In the following documentation for the
DatabaseSessionService, a synchronous implementation is shown for the SQLite example. However, the internal implementation of the service (built on top of SQLAlchemy) does not allow using SQLite in a synchronous approach, which causes the code to crash. This can be misleading for users.To Reproduce
Steps to reproduce the behavior:
DatabaseSessionServicesectionExpected behavior
The code should run successfully without major issues and create the SQLite database.
Screenshots
Image extracted from the following issue: google/adk-python#3916
Versions
Additional context
I tested the same scenario as the issue creator on my device and encountered the same problem. After switching to the async driver, it worked without major issues.