New database events schema in python

[imrenagi]

Hi, I just checked on adk-python events table that it only uses single events column for storing jsonb of the event now. On the other hand, adk-go still uses separate column to store events information on different columns. Is there any plan to make adk-go using similar schema?

Currently Im trying to implement Gemini Live support for adk-go in #567, however im not able to store information about input and output transcription to the events table since there is no column for that. I am considering it cant be stored on the content column. Any suggestion?

Thanks!

[verdverm]

I support simplifying the table, will need a path for migration / backwards compat. It also seems necessary if you have multiple SDKs accessing the same database. For reference

• https://github.com/google/adk-python/blob/main/src/google/adk/sessions/schemas/v1.py#L153
• https://github.com/google/adk-go/blob/main/session/database/storage_session.go

Currently live in my database:

CREATE TABLE `events` (
  `id` text, 
  `app_name` text, 
  `user_id` text, 
  `session_id` text, 
  `invocation_id` text, 
  `author` text, 
  `actions` blob, 
  `long_running_tool_ids_json` text, 
  `branch` text, 
  `timestamp` datetime, 
  `content` text, 
  `grounding_metadata` text, 
  `custom_metadata` text, 
  `usage_metadata` text, 
  `citation_metadata` text, 
  `partial` numeric, 
  `turn_complete` numeric, 
  `error_code` text, 
  `error_message` text, 
  `interrupted` numeric, 
  PRIMARY KEY (
    `id`, `app_name`, `user_id`, `session_id`
  ), 
  CONSTRAINT `fk_sessions_events` FOREIGN KEY (
    `app_name`, `user_id`, `session_id`
  ) REFERENCES `sessions`(`app_name`, `user_id`, `id`)
);