Data-Manipulation-Python

1. Introduction

The most simplest and easiest way for connecting to a databse remotely and manipulate it by adjusting few lines of code accordingly! The project is written in pure python and uses no other libraries. The project is written in a way that it can be used for any database with any number of columns and rows. You just need to configure your database credentials and you are good to go!

2. Requirements

• Python 3.6 or above
• MySQL Server 5.7 or above (In case you are using MySQL)
• MySQL Connector for Python (In case you are using MySQL)
• SQLite3 (Used in the project)
• SQLite3 Connector for Python (Used in the project) Note: The project is compatible with SQL databases only. NoSQL databases are not supported.

3. Installation

• Install Python 3.6 or above from here
• Install MySQL Server 5.7 or above from here [Optional]
• Install MySQL Connector for Python from here [Optional]
• Install SQLite3 from here [For this project]
• Install SQLite3 Connector for Python from here [For this project]
• Clone the repository using git clone git@github.com:huzaifamk/Data-Manipulation-Python.git
• Navigate to the project directory using cd Data-Manipulation-Python
• Install the requirements using pip install -r requirements.txt
• Simply run the project using make run command or python app.py command

Note: The project will be extended in future for other databases as well. Stay tuned! And also more features will be added in future.