Building a ToDo App with Streamlit & Python(Create,Read,Update,Delete)

In this tutorial we will build a simple todo app in streamlit that covers the concept of CRUD (create,read,update and delete) in 70mins.

Udemy Course : Building ML Web Apps

**TIMESTAMPS**
0:50 - Demo
3:00 Structure
8:55 CREATE(Adding Data)
12:21 Creating Database To Store Data(Sqlite3)
20:10 Adding Data To DB
21:25 READ(Viewing Data)
24:40 Convert Data into Pandas DataFrame
29:00 Adding Plots with Plotly
32:10 UPDATE(Editing Data)
43:00 Fetching Data and Repopulating to Text inputs
47:45 Update SQL Statement
56:20 DELETE(Removing Data)
1:07:00 Recap

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

[rgbesmedia]

Buenisimo! Lo desarrolle en flask y tkinter, al conocer streamlit pensé en desarrolarlo y ahora el algoritmo de YouTube me lo muestra ❤

[gamerinyourtown]

This helped me for my school you know I need to keep things organized

[ici]

You are a star guy ! Thanks a lot. This tutorial is was very useful to me.

[Bbb]

This is exactly what I wanted to create as a project, adding in my own NLP ML stream lit work and there we go 😉
Thanks for this

[youngnamhoso]

Thanks for the alternative usage of streamlit !!!! I really appreciate it.

It would be also nice to have tutorial of deploying this CRUD app(+ sqlite) on Heroku or other cloud :)

[cheyennehu]

Wonderful! I really appreciate your patience and clarification. Thank you!

[byunique]

Thank you! I learned a lot here and very clear explanations!

[immanuelsuleiman]

this is the best thing i have seen in a while
thank you happy new yer brother

[udeshsharma]

After deployment this error comes up while signup
"attempt to write a readonly database"

what to do?

[franciskunda]

Awesome, I really enjoyed the tutorial

[DstorytellersCorner]

when i run the code this is what show up
st.columns has graduated out of beta. On 2021-11-02, the beta_ version will be removed.

Before then, update your code from st.beta_columns to st.columns.

[nit]

What a helpful video! Thank you a lot dear.
I have a question. Let's say that I have 2 tables in my database: customers and orders. And I want to insert orders and clients' information to their respective tables. In each table I need CRUD. How do I have to change from your code in order to achieve that?
I need just the main ideas.
Thanks dear

[mrrobot]

hi there, can you show us how to build this further using an example with a primary and secondary key in another table? Great tutorial..learned a ton

[gabrielquinteros]

excellent video and code, thank you very much! There is only an error in the UPDATE, where the registry values are put in the titles and not in the objects.

[sopojarwo]

Can you sir make tutorial streamlit, sql database and fast API?

[SantoshKumar-jtef]

Pls guide me, how to do in nosql database?

[victornzemeke]

Thank you, this video was super useful.

[androidbox]

Can Stream it create database or database file ? 🙁

[AfricanRisingTechstars]

Great tutorial but am receiving error
Programming errors SQLite objects created thread

[senthilkumarpalanisamy]

Excellent!!! thanks for posting this :-)