Simple Streamlit App with Login & Sign Up Section

In this tutorial we will see how to add login and sign-up section to our streamlit app using python and sqlite3. We will be using it to restrict the usage to only those who have signed-up.

Udemy Course : Building ML Web Apps

==Written Tutorial and Code==

Get More Here - Building ML Web Apps(Mega Course)

If you liked the video don't forget to leave a like or subscribe.
If you need any help just message me in the comments, you never know it might help someone else too.
J-Secur1ty JCharisTech
Jesus Saves

==Get The Data Science Prime App==

==Need To Build A Data Science/ML App Check out this gig==

Follow

[ButchCassidyAndSundanceKid]

How do you implement a pin code login, ie. if you know the passcode is say "34647", it will ask you for the 2nd or 5th character. Is there a special Streamlit control for this or do I use a normal 1 character text box then use a random number to pick which one to ask the user. Thanks.

[ButchCassidyAndSundanceKid]

Why did you put create_usertable in lines 72 and 48 twice ? Surely when you sign up, the userstable would've created for you, then you do that again in line 48. What if this is a multi-user system (as you allow users to sign up). Wouldn't it be better if you create the table in advance, but to check the user if it's in the table, if it exists, then proceed, if not, create the new user.

[RougeSam]

You could use st.cache to keep the person logged in with st.button I believe. great video though. Do you know if you deploy to production if the usernames/passwords would be saved via heroku?

[zdxwu]

nice work! but why does the page show a blank page in my streamlit?

[sampathv]

hi bro,
After getting successfully login how to land or redirect to a new page directly

[amitmitra]

Superb work JCharis, can you please create videos on streamlit authentication by integrating social authentication provider like Google, Microsoft, FB, etc

[Dreaming-]

Man, I cannot understand what you say... but the content of your tutorial is very valuable

[shrshr]

Thank you for this awesome tutorial 🔥🔥

[PollynzDataTech]

Hi Jesse thank you for the tutorial, however I am getting this error streamlit operationalerror: attempt to write a readonly database traceback: can you please assist me?

[gingerdragon]

Sir may I ask if you can change checkbox to button in loggin while still using the sqlite3?

[munivinayk]

Hi i have two questions. Can you please guide me on mitigating them:
1. How to handle multiple users trying to connect to the app. I am looking to distinguish the users and if the user is not already logged in - route the user to the login page.
2. I am getting the thread error (you have created this thread but now connected to thread )- when i try to deploy and run the app in docker.

[vladimirbykov]

Excellent presentation! I enjoyed your Streamlit course on Udemy and this is truly great addition to it!

[sayonsai]

Looks like this is a hostage situation

[midhatahir]

Please make video of real face detection and classification app using video stream

[oriaburehopeeromhosele]

Can I used streamlit and Python to create a social network site?

[udayannath]

What is the code to store the user name into an excel file when someone run this streamlit code?

[theexposer]

Every login and user registration function should have function to change password, forget password and sending email for these actions. We can add email field at the time of new account setup but if you provide the required enhancement to this code it would become a full fledged application for handling Login, new user registrartion, change and forgot password functions. Forgot user name can also be added where user eneters his/her email and system sends the login associated with the email . Duplicate user account can also be controlled, possibily at sqlite table level. Great effort.

[dingding]

But this totally fails if you've got multiple pages/sections

[analpatel]

hey brother how to redirect another page after login .. Please let me know because its urgent for my submitting project

[srinithik]

will it be possible to use a interactive folium map plotting according to user selected states in drop down menu ??