please make the SQL tables that are generated - in at least the JdbcChatMemory and the PgVectorStore implementations - consistent.

[joshlong]

please make the SQL tables that are generated - in at least the JdbcChatMemory and the PgVectorStore implementations - consistent.

AI_CHAT_MEMORY
SPRING_AI_VECTORS

Maybe SPRING_AI_CHAT_MEMORY as a useful default?

[markpollack]

moreover the schema needs to be customizable.

[joshlong]

Yah. Customization is good. The schema for the existing supported databases aren’t easily overridden. Schema for unsupported databases however are easy to provide: just add a .sql file in the class the sql initializer would look for it /src/man/resources/org/springframework/ai/blah/schema-oracle.sql

The initialiser substitutes the platform name in the file name. That already ‘just works’

I don’t know (I’m afk) if there’s a way to tell our various JDBC-backed things to back off for the databases we do support. I’d be surprised if we didn’t. Don’t we have initialize-schema=true or something ?

[quaff]

Don’t we have initialize-schema=true or something ?

FYI, Spring Boot use enum DatabaseInitializationMode instead of boolean, and default to EMBEDDED, I'm trying to create PR to align with Boot.

[quaff]

Don’t we have initialize-schema=true or something ?

FYI, Spring Boot use enum DatabaseInitializationMode instead of boolean, and default to EMBEDDED, I'm trying to create PR to align with Boot.

Created #3010.

[markpollack]

closing as this PR #3055 address the issue and we have a few issues on this topic.