Welcome to SQL-Integration, a Django application that connects to a PostgreSQL server, accepts SQL statements as input, and displays query results as Pandas DataFrames in HTML.
- Input SQL queries and see the results as interactive Pandas DataFrames on the webpage.
- Securely connects to a PostgreSQL database using Django's integrated ORM and the psycopg2 library.
- Enhances your understanding of Django, PostgreSQL, and Pandas while building a practical web application.
- Clone this repository:
git clone https://github.com/yuenfu001/SQL_integration.git - Navigate to the project directory:
cd SQL_integration - Install dependencies:
pip install -r requirements.txt - Run the development server:
python manage.py runserver
- Visit
http://127.0.0.1:8000/in your web browser. - Input your SQL query into the form and click "Execute."
- The query results will be displayed as an interactive Pandas DataFrame on the webpage.
Contributions are welcome! If you find any issues or want to enhance the app, feel free to open a pull request or submit an issue.
- This project was inspired by my desire to learn more about Django, PostgreSQL, and Pandas.
- Thanks to the coding community, online resources, and fellow developers for their valuable insights.
Note: This README is a template. Modify it to suit your project's needs. Include details like installation instructions, prerequisites, troubleshooting, and any other relevant information.