SQLite-MySQL Sync Tool

Project Description

The SQLite-MySQL Sync Tool is a Python-based application that provides a simple interface to synchronize data between a local SQLite database and a MySQL database. It is built using the Tkinter library for the graphical user interface and supports bi-directional synchronization of data.

Features

• Add data to SQLite or MySQL databases.
• Synchronize data between SQLite and MySQL with a single click.
• Automatic synchronization every 5 seconds.
• User-friendly graphical interface.

Requirements

• Python 3.11 or higher
• MySQL server
• Required Python packages:
  • mysql-connector-python
  • tkinter

Installation

1. Clone the repository:

   git clone <repository-url>
   cd sql_lite

2. Create a virtual environment and activate it:

   python3 -m venv myenv
   source myenv/bin/activate  # On Windows: myenv\Scripts\activate

3. Install the required dependencies:

   pip install mysql-connector-python

Usage

1. Start the application:

   python syn.py

2. Use the graphical interface to add data to SQLite or MySQL.
3. Data will automatically synchronize every 5 seconds.

File Structure

• syn.py: Main application file.
• .gitignore: Specifies files and directories to be ignored by Git.
• README.md: Project documentation.

License

This project is licensed under the MIT License. See the LICENSE file for details.