Hey Streamlit Community!
I’ve just created a video tutorial showing how to build a simple but complete web application for database CRUD operations using Streamlit and SQLModel. While the video itself is in Spanish, I’ve made this post to explain the core concepts and encourage you to check it out, even if you don’t speak Spanish. The code is clear and the visual nature of Streamlit makes it easy to follow along.
The tutorial covers:
-
Setting up SQLModel: Defining data models and connecting to a database (SQLite in the example).
-
Building the UI with Streamlit: Creating forms, tables, and buttons for user interaction.
-
Implementing CRUD operations: Creating, reading, updating, and deleting database records using SQLModel.
-
Handling data selection: Selecting rows in a table to edit or delete specific records.
-
Dynamic UI updates: Refreshing the Streamlit interface after each CRUD operation.
Why should you check it out, even if it’s in Spanish?
-
Visual Learning: Streamlit’s visual nature makes it easy to understand what’s happening, even without understanding the spoken explanation.
-
Code Clarity: The Python code used is well-commented and follows best practices, making it relatively easy to understand.
-
Valuable Concepts: The tutorial demonstrates valuable concepts applicable regardless of language, such as structuring a Streamlit app, integrating with a database ORM, and handling user interactions.
I’ve also included the full code in the video description and you can also enable subtitles translation.
Here’s the link: [Video Link]
I’d love for you to give it a watch and try to follow along. Feel free to ask any questions here, and I’ll do my best to answer them. Even if you don’t understand Spanish, I believe you can still gain a lot from this tutorial. Let me know what you think!
