Canvas Component

[androviperian]

I have recently started learning rust (a data analyst with R and python data library usage skills). I am looking to build a data / metrics catalog application, and SQLPage seems to be a great fit for non front-end / back-end people like me. My humble appreciation and kudos to this project's developers. For my background, this project seems to be an equivalent of R Shiny pakage.

I would like to render and display ERD diagrams and KPI relations (lead vs lag metrics etc). Is it possible to do this in SQLPage? Or can I embed another framework like svelte-flow or react-flow within a SQLPage widget to achieve the same? If so, what would be a compatible recommendation?

[androviperian]

I tried the attached code block (for using drawflow js library) and it rendered the script component as a blank widget
drawflow-example.docx

[lovasoa]

Hi @androviperian !

Great to hear that you are finding sqlpage helpful ! Making app creation accessible to data people is exactly what we are trying to do !

We have multiple built-in components that make it easy to visualize KPIs, such as

• https://sql-page.com/component.sql?component=big%5Fnumber
• https://sql-page.com/component.sql?component=datagrid
• https://sql-page.com/component.sql?component=columns

For ERD diagrams, we don't have built-in components. If you want to build it yourself using the libraries you mentioned, you can look at

• the custom component documentation on https://sql-page.com/custom_components.sql (especially the part about custom javascript)
• this example from the github repository: https://github.com/sqlpage/SQLPage/tree/main/examples/using%20react%20and%20other%20custom%20scripts%20and%20styles

If you want to focus more on the data part and let us build the UI components for you, that's also something we do ! Feel free to email my partner at [email protected].

By the way, if you need to share code snippets on github, the easiest is probably just to paste it inline here, surrounded by backticks

```sql
-- your code here
```

that will make it easier to view than docx files !

[androviperian]

Thanks @lovasoa I am doing this is as a personal project to learn rust. I hope to gain enough skill to eventually start contributing to SQLPage.