How to Add a User Authentication Service (Login Form) in Streamlit + Database

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Introduction
00:52 – Set up the database
06:28 – Hiding the project key
08:22 – Database helper file
09:22 – Connect streamlit with our database
10:56 – Config var values in Heroku
11:24 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[muhammadnaqiuddinkamilmohd]

Please make more videos on Streamlit Dashboard with different examples. Your tutorials on streamlit is by far the easiest to follow and understand. Thank you.

[CodingIsFun]

🚨 IMPORTANT 🚨
Shortly after releasing the video, the streamlit-authenticator package got updated. The new version is incompatible with the syntax I have shown in the video.
If you want to follow along with the video, please use version 0.1.5 : *pip install


*Happy Streamlit-ing!* 🎉

[ricardo.alves.campos]

Awesome as always, perfectly explained great stuff! Thank you!

[andfanilo]

Very nice tutorial! Always wanted to see Deta in action, did not know they had a Python API 😀

[florianroeseler]

Very easy to understand, great content!

[hakimdz]

You are the best because you provide very valuable lessons for free😘

[canhtung.n]

Your tutorial very very useful. Thanks a lot !

[sholay]

God bless you for the tutorials sir. I really want to be a professional in programming languages someday

[stefanwiesinger]

Fantastic video!
I noticed that since you uploaded this video, Deta has undergone some significant upgrades. I'm curious if you could elaborate on how these changes impact the workflow you covered in the video?
Thanks again for sharing such valuable insights!

[FRUXT]

You are by far the best streamlit teacher ! I learnt so many things thanks to you ^^
Would it be possible to use Stripe then to give access only to users who paid it ? I think the video would be hugely successfull ^^

[simenandreasknudsen]

This is awesome! But it goes a little bit over my head. Let me know if you create a more in-depth course on the topic. I love your way of teaching! :) Cheers

[PinkPixelRabbit]

Thanks for making this tutorial, Sven, your have offered us a good option of choosing database. But I have a question, is Deta suitable for production use? Any limitations or potential risks behind?

[da]

Hello everyone, is it possible to change the field name (username and password), for example, instead of those: email and secret key. Thanks!

[yinshin]

Hi. May i know if streamlit able to connect to Azure sql database ? As i saw from documentation, active directories are not ready yet for streamlit to connect with azure. :(

[NickoReese]

Thank you for the amazing tutorial Sven. I've been having this problem and reading all the realated community notes. No matter what I do, I can't get the authentication to return True for authentication status. I've followed every step multiple times and debugged the code. I'm using the dictionary format in the new verion. Is there anything I might be doing wrong?

[laszlosebestyen]

Thanks the video, everything works good. But i have a problem, when i enter the data in the form.... the login form disappears very slowly, do you have any idea what i can do to make it disappear from the screen immediately?

[knowledgegetter]

How to implement this for Olympic data visualisation project-to add login and db

[praveenv]

Hi, this is great video. Do we have any references that can integrate with Aws cognito?

[ragesilver]

Just one question. When I do import database as db it shows as an error. I already installed it yet it doesn’t work. Did it update or did the code change? Any idea what may have happened? Please lmk😊

[Eden-Ifrah]

Your videos are very helpfull, Thank you about it!
Did you have example how can i connect to postgreSQL DataBase instead using Data cloud?