Skip to content

README.md

Latest commit

 

History

History
106 lines (63 loc) · 2.88 KB

README.md

File metadata and controls

106 lines (63 loc) · 2.88 KB

Python Web Application with MS SQL Server Integration

Professional Project Overview

This repository showcases a professional Python web application integrated with Microsoft SQL Server, developed to demonstrate solid skills in backend integration, database operations, and web-based user interfaces.

The project focuses on implementing reliable database connectivity and essential data operations through a clean and functional web interface, following good development practices suitable for real-world applications and technical portfolios.

Key Features

  • 🔗 Robust Database Connectivity Secure and configurable connection to Microsoft SQL Server using ODBC drivers.

  • 🗄️ Database Schema Management Ability to create database tables programmatically through the application.

  • ➕ Data Insertion Workflow User-friendly forms for inserting structured data into the database.

  • 📊 Data Visualization Retrieval and display of stored records in organized tabular views.

Technologies & Libraries

Core Technologies

  • Python (3.13.5) – Main programming language
  • Microsoft SQL Server – Relational database management system
  • Streamlit – Web application framework for rapid UI development
  • ODBC Driver for SQL Server – Database connectivity layer

Python Libraries

  • pyodbc Enables communication between Python and Microsoft SQL Server, supporting SQL execution and transaction handling.

  • streamlit Provides an interactive and responsive web interface, allowing users to interact with database operations seamlessly.

  • pandas Used for data manipulation and presentation of query results.

  • numpy Supports numerical operations and data processing tasks.

  • datetime Handles date and time management for database records and logging.

Setup & Execution

Prerequisites

  • Python 3.x
  • Microsoft SQL Server (local or remote instance)
  • ODBC Driver for SQL Server

Installation

Install the project dependencies:

pip install -r requirements.txt

Configuration

Configure the database connection by updating the connection string with:

  • Server address
  • Database name
  • Authentication credentials

Running the Application

streamlit run app.py

Access the web application using the local URL provided in the terminal.

Professional Objectives

This project was developed as part of a professional portfolio to demonstrate:

  • Practical experience with Python and relational databases
  • Ability to integrate backend services with a web interface
  • Understanding of fundamental database operations
  • Clean code organization and documentation practices

License

This project is available for demonstration, learning, and portfolio purposes.