Video

Glad it helped! Hmm I should make a new, more modern version of this video 🙃

I’d say learn both 🙃

@@andfanilo Have you heard the term's "Choose a language and you are married to it rest of your life. So choose wisely". I have wasted my life so many hours and days just looking for some shortcut and learning any new frameworks or library but at the end of everything I came back to Django and JavaScript.

Thanks for the support! At this time it's not possible to get a callback from HTML to Python with st.html, you have to build a bidirectional component BUT you don't have to use the usual react template or react-less template from github.com/streamlit/component-template You can use discuss.streamlit.io/t/code-snippet-create-components-without-any-frontend-tooling-no-react-babel-webpack-etc/13064 instead Also I think there's this st-clickable-image discuss.streamlit.io/t/custom-component-to-display-clickable-images/21604 you can maybe get inspired from its code

Thank you for the kind words 🙂 hope to see you on the next video!

Thanks for watching! If didn’t yet, check out my latest video too, it is another way of doing Google sheets Streamlit dashboard but in the same video style 😁

Thanks for watching, see you on the next one :)

Thanks for sharing! Yeah I saw this trick while browsing through the Google Workspace for Developers and thought there were so many ways to interact with Google APIs eheh. Do you know if it's possible to bake authentication into this webpage, just so not everyone who discovers the link has access to it?

Actually it's just VSCode and a web browser side-by-side, but I configured VSCode margins so the topbar for both windows match for the screen recording ( gist.github.com/andfanilo/ae99aed9c454a46c1dbfe6a0b9fa0012 to check my config)

Thanks for watching, see you on the next one :)

It was a long ride! Hope you enjoyed it :) see you on the next one!

Thanks for watching, see you on the next one :)

Thanks for watching, see you on the next one :)

Hello, thanks for watching! It was probably ElevenLabs for this video 🤔 ( elevenlabs.io/ )

Thanks for watching! See you on the next one :)

Yeah, I find this service account creation demanding for new users 😅 that could be automated maybe, like with Terraform or a command to paste into Google Shell Sparklines ftw, I initially wanted to use the st-aggrid ones but they require an enterprise license so yay for Streamlit Sparklines! Thanks for watching :)

Credits to arnaudmiribel.github.io/streamlit-extras/extras/stylable_container/ for the initial idea, plus st.html makes it a little easier! And I did already tell you your dashboard was the initial trigger to this video? So thanks for building/sharing it 😊 looking for your next dashboard!

@@andfanilo I couldn't feel more proud, thank you for your support, I have learned a lot from your videos, I'm really glad to be useful for you and to give something back.

💪 let's hope so! thanks for the support :)

Well thank you for the support I'm very grateful :) I hope you watch more then, I even just released a new video!

Thanks for watching, see you on the next one!

Eheh, this is actually a customized version of arnaudmiribel.github.io/streamlit-extras/extras/stylable_container/ made simpler with st.html. I figured it would be better to explain it so people get to learn CSS (sometimes I think my channel will be rebranded "CSS for data scientists"!) Until one day we get custom classes on widgets maybe one day 🙃

gsheets-connection is an official st.connection ( docs.streamlit.io/develop/api-reference/connections/st.connection ) wrapper around GSpread to connect to GSheets. The library puts the connection and data in Streamlit cache for you so you only have to query it. It's a Streamlit-specific solution. Pyairbyte is a Python library for Airbyte ( airbyte.com/ ) that manages the connection and data download to a lot of different databases like MySQL, GSheets (which I use in the video) or BigQuery. It comes with more features than gsheets-connection like caching data in DuckDB, or fetching datasets already managed in a Cloud instance of Airbyte. If you work in a company that uses Airbyte to connect and manage multiple data sources, chances are you can directly download or refresh data from their self-hosted Airbyte platform. It's a popular solution amongst data engineers, not just specifically Streamlit. What I did in this tutorial is basically recreate a st.connection gsheet pyairbyte, without explicitly calling it st pyairbyte gsheet connection...

Ahh i see. Thank you for the comprehensive explanation

Ahah you're the first :D congrats!

😆 Aren't my videos too "exciting" to get you to sleep?! Thanks for the support as always, very appreciated :) also there's a new one coming tomorrow eheh

@@andfanilo Very good videos, I was just looking at the backgrounds and how to make something more personalized, thanks man

I haven't tried stlite in a while but from github.com/whitphx/stlite/tree/main/packages/desktop there are some new configurations options to add to point to the entrypoiny.. But the honest best way would be to head to github.com/whitphx/stlite/issues if it still doesn't work, the author is very helpful there!