DEV Community

Tasnem Islam Prome
Tasnem Islam Prome

Posted on

I Built an IT Help Desk Ticket System Using Python, Streamlit, and SQLite

I wanted to practise building a practical application based on everyday IT support workflows.

My IT Help Desk Ticket System is a Python portfolio project for managing support requests.

Features

The local application supports:

  • Creating and assigning tickets
  • Tracking open, in-progress, resolved, and closed requests
  • Searching and filtering tickets
  • Editing and deleting records
  • Dashboard charts and CSV exports
  • SQLite persistence

Public demo

The public Streamlit version is read-only by default and displays five fictional sample tickets.

This prevents visitors from modifying shared data.

Limitations

The project is a single-user demonstration. It does not yet include authentication, role-based permissions, audit logs, or production security controls.

Future improvements include SLA tracking, notifications, and user management.

GitHub repository: https://github.com/tasnem-tech/it-helpdesk-ticket-system

Building this project helped me explore the relationship between IT support processes, databases, and user interfaces.

Top comments (0)