Skip to content

README.md

Latest commit

 

History

History
53 lines (42 loc) · 1.98 KB

README.md

File metadata and controls

53 lines (42 loc) · 1.98 KB

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

  • 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