Skip to content

The application provides a modern, theme-aware UI, real-time syntax highlighting, progress tracking, status animations, and custom message dialogs, delivering a smooth and polished user experience.

Notifications You must be signed in to change notification settings

devloperltd/MySQL2SQLite-Converter-PySide6-GUI-Application

Repository files navigation

🛠️ MySQL2SQLite Converter — PySide6 GUI Application By Laroussi Boulanouar

2025-10-28_140957

🚀 Overview:

MySQL2SQLite is a professional desktop tool built with PySide6 (Qt for Python) that allows developers and database administrators to convert MySQL dump files (.sql) into SQLite database files (.db) or cleaned SQL scripts with just a few clicks.

The application provides a modern, theme-aware UI, real-time syntax highlighting, progress tracking, status animations, and custom message dialogs, delivering a smooth and polished user experience.

🌟 Key Features:

🧩 Conversion & Validation

  • Convert MySQL dumps (.sql) directly into SQLite databases (.db) or cleaned SQL files.
  • Intelligent parsing, formatting, and cleaning of MySQL syntax for SQLite compatibility.
  • Built-in file validator ensures you only process valid MySQL dumps.
  • Background multi-threaded worker prevents UI freezing during conversion.

🎨 Modern User Interface

  • Developed using PySide6 (Qt 6) with a clean, frameless custom design.
  • Supports both Light ☀️ and Dark 🌙 themes (switch instantly).
  • Responsive animations and transitions using QPropertyAnimation and easing curves.
  • Real-time status icon animations (processing / success / error).
  • Custom message boxes for Success, Warning, and Error states.

⚙️ Smart Tools & Utilities

  • Theme Manager — remembers your last theme and updates icons dynamically.
  • System Information — automatically detects Windows version and username.
  • Custom Dialogs — “About” dialog, confirmation popups, and more.
  • Shortcut System — toggle, minimize, maximize, and restore window via hotkeys.
  • Logging System — integrated debug logger for tracking errors and app behavior.
mysql2sqlite/
├── config/                 # App configuration (app.ini)
├── debugs/                 # Logging configuration
├── dialog/                 # About dialog and custom popups
├── icons/                  # Light & dark icon sets
├── Json/                   # Theme & language preferences
├── messages/               # Custom message box UI files
├── qss/                    # Light & dark QSS themes
├── stylesheet/             # Dynamic style and syntax formatting
├── themes/                 # Theme manager logic
├── tools/                  # Conversion, validation, and system utilities
├── ui/                     # Qt Designer UI files and generated Python UIs
├── utils/                  # Core helpers (animations, dialogs, window utils)
├── main.py                 # Main entry point
└── requirements.txt        # Python dependencies

🖥️ Technologies Used:

  • Python 3.11+
  • PySide6 (Qt for Python)
  • SQLite3
  • MySQL Parser
  • QSS (Qt Style Sheets)
  • Threading and Animations
  • Custom JSON-based Theme System
  • Logging & Debugging Framework

🎯 Highlights:

  • Frameless modern window with drag support
  • Animated theme switching
  • Syntax highlighting for SQL preview
  • Thread-safe progress bar and status updates
  • Configurable color themes & icon sets
  • One-click MySQL → SQLite conversion
  • Clean, maintainable modular architecture

📦 Installation:

git clone https://github.com/devloperltd/mysql2sqlite.git
cd mysql2sqlite
pip install -r requirements.txt
python main.py

Or simply double-click run.bat (Windows only).

📘 Usage:

  • Launch the application.
  • Click “Open” to import a .sql file (MySQL dump).
  • Validate and preview your SQL content.
  • Click “Convert” to create a .db or cleaned .sql file.
  • Follow real-time progress with the animated progress bar and logs.

💡 Future Enhancements:

  • 🌐 Multi-language support (JSON translations system ready)
  • 🧠 Advanced SQL optimization engine
  • 💾 Batch conversion mode
  • 🪄 Auto-detection of database encoding

👨‍💻 Author:

Laroussi Boulanouar Software Developer • Python & Qt Enthusiast 🔗 GitHub

🧡 License:

This project is licensed under the MIT License — free to use, modify, and distribute with attribution.

📸 Preview (Recommended for GitHub/Posts):

2025-10-28_141014 2025-10-28_140948 2025-10-28_140827

🏁 Tagline:

🛠️ MySQL2SQLite Converter — PySide6 GUI Application A professional, intelligent, and flexible compiler assistant for PySide6 and database-powered Python projects. Created with passion by Laroussi Boulanouar 💻🔥

▶️ Watch Video Tutorial :

Watch the video

About

The application provides a modern, theme-aware UI, real-time syntax highlighting, progress tracking, status animations, and custom message dialogs, delivering a smooth and polished user experience.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published