lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.ophir.dev
MIT License
881 stars 62 forks source link

dash or plotly integration #292

Open vks2 opened 2 months ago

vks2 commented 2 months ago

hello is there any plans to plotly or dash integration? there'sv some js wrappers around

thanks much

lovasoa commented 2 months ago

Hello ! This is not on my roadmap, but I'll consider it if you open a pull request !

What are you missing in the chart component ?

vks2 commented 2 months ago

datascientists afaik have a lot of plotly setups not easy to reassign to another drawing library. most of them is multichars that consists of 3-4 components, when you look at dataset from different point of views.

but if it's a great headache, and lot of work apex will be OK. guess we may somehow speed up plotting capabilities and tune up hoverability,

lovasoa commented 2 months ago

If you already have visualisations in python and are porting them to sqlpage, you will have to rewrite them anyway, even if the underlying library were the same, won't you ?

vks2 commented 2 months ago

yes and no. datalayer should be written from scratch (like your code for x and y in charts examples), but with formatting plotly supports a powerful json parameterization that you inject into the engine. so one can build effective charts and do not depend on current code version or coding language. here's an example, hope you enjoy the idea behind: https://plotly.com/python-api-reference/generated/plotly.io.read_json.html indeed params could be very sophisticated изображение

vks2 commented 2 months ago

may I follow this example to integrate plotly? https://github.com/lovasoa/SQLpage/tree/main/examples/using%20react%20and%20other%20custom%20scripts%20and%20styles

lovasoa commented 2 months ago

Hello ! Yes, this example is still relevant !

vks2 commented 2 months ago

looks pretty cool. will give it a try