CRUD Operations with MySQL and Streamlit

This project demonstrates how to create a simple web application using Streamlit that performs CRUD (Create, Read, Update, Delete) operations on a MySQL database. The application allows users to manage records in a users table by providing an intuitive interface for interacting with the data.

Table of Contents

• Features
• Installation
• Usage
• Technologies Used
• Customization
• Contributing
• License

Features

• Create: Add new records to the users table.
• Read: View all records stored in the users table.
• Update: Modify existing records.
• Delete: Remove records from the database.
• User-Friendly Interface: Simple and intuitive interface for performing CRUD operations.
• Real-time Feedback: Immediate feedback on CRUD operations via success messages.

Installation

Prerequisites

• Python 3.x
• MySQL Server
• Streamlit

Usage

1. Open the application in your web browser.
2. Use the sidebar to select a CRUD operation.
3. Enter the required details and click the button to perform the operation.
4. View success messages or results on the main screen.

Technologies Used

• Python: Programming language used for developing the application.
• Streamlit: Framework for building interactive web applications.
• MySQL: Relational database management system used to store and manage data.

Customization

You can customize this application to suit your needs. Here are some ideas:

• Add User Authentication: Secure the application by adding user authentication.
• Implement Data Visualization: Include charts and graphs to visualize the data.
• Add Advanced Filtering: Provide options to filter and search records in the database.

Steps

1. Clone the Repository:

   git clone https://github.com/ayushai/crud-operations-using-streamlit.git
   cd crud-with-mysql-and-streamlit