SQL Database Design

[tonic-ai]

SQL Database Design

[h0lybyte]

For schema generation and maintenance, I am using a combination of Drizzle and Diesel.

Main schema (drizzle) would be here -> https://github.com/Tonic-AI/kbve/blob/main/apps/api/src/db/schema.ts
Rust schema via Diesel would be here -> https://github.com/Tonic-AI/kbve/blob/main/packages/kbve/src/schema.rs

Actual SQL would then be placed in the migrations -> database folder.
https://github.com/Tonic-AI/kbve/tree/main/migrations/database

With Drizzle, you can export out to Zod as well, so that helps with front-end validation via React.
Diesel can help with raw SQLX for backend validation, also proto buffer validation, ect..

[linear]

QRE-15 SQL Database Design

[Josephrp]

the above is simply a GPT example, we need to align this with our use case and probably pass it more in taskweaver than in semantic-kernel

[Zochory]

https://linear.app/qredence/issue/QRE-15/sql-database-design#comment-c4e5f4f6
Let me know what you think !

[Josephrp]

so currently the schemas i guess ... dont exist , and we're meant to be processing and collating a lot of heterogeneous information, like client profiles and balance sheets, so i dont really know what you have in mind but i would rate this a very high priority high impact task @h0lybyte @GoldenWind8

[Josephrp]

WIP in Task Weaver Branches