DT
Drizzle Team5mo ago
k

Visualize database schema (ERM preferably) when using planetscale with out foreign keys

Anyone know a decent way to create an ERM diagram when using drizzle and planetscale? I tried mysql workbench but since the foreign keys are virtual theres no mapping between the tables. Apologies if this is more of a planet scale question but since the relations are mapped out by drizzle I figured I'd ask here. Any ideas are appreciated
9 Replies
rphlmr ⚡
rphlmr ⚡5mo ago
Do you mean something like that?
No description
k
kOP5mo ago
@Raphaël M (@rphlmr) ⚡ yes! What is that from?
k
kOP5mo ago
Very cool, looking forward to it I'll have a play around with it and see if I can get it working
rphlmr ⚡
rphlmr ⚡5mo ago
Do not hesitate to drop any feedback. It is not perfect and can miss some things 😬
k
kOP5mo ago
My schemas are seperated in quite a few files so might take a while to get it all into the browser
rphlmr ⚡
rphlmr ⚡5mo ago
Ah yes, Visualizer is not very convenient for that right now sorry. I am working on something better It would work, but nothing is saved once you close your browser, so it’s a big pain.
k
kOP5mo ago
@rphlmr ⚡ completely understandable as its a beta! Thanks for working on it, major pain point for me when I need to get the team up to speed on the database structure
Want results from more Discord servers?
Add your server