Creating the database for dashboard app

Dash Python
1

Hello Guys,
Hope you are doing great!
I have created a Dashboard which is working fine.T he database for that is currently a google sheet which is connected to the app through url so my spreadsheet is public the app is hosted on render.
Now I want better solution for that like maybe sql database which is also protected and the main thing is I have to update(write) that database daily bases but the data will ultimately come from excel sheet. I have never created a sql database and don’t even know will it be better with current spreadsheet method.
Also how to host that database what are cost efficient methods available.
Can I automate that database write entry from excel sheets.

Thanks!

2

Hi! I’ll be more than glad to collaborate with your project, because currently I’m enhancing my ‘MySQL knowledge’, so it would be nice working with you in setting up the ground on MySQL Server and handling read and write opps.
Let me know if you’re interested, and we can discuss the details! Cheers! :slightly_smiling_face:

2 Likes
3

I would love some help doing this too.

4

Hi JuanG
Thanks for your response I would be happy to collaborate but this is not a open project.
Anyway I found this amazing channel for Plotly related tutorials even he also have videos on database setup.
Charming data
Thanks!