How to create pie chart using queries from sqlite3 database

📊 Plotly Python
1

I want to create a piechart for data that I have stored in an SQLite database. The data in the database is being streamed in real time. How can i create a piechart for this streamed data based on SQL queries.

2 Likes
2

hi @ginfin371
welcome to the community.

One way to do this is to use the dcc.Interval() to retrieve the data from the SQLite database into your app every x amount of time. Then, take the data and create a pie chart that you can assign to the figure property of the dcc.Graph()

2 Likes