SQLite Manager

sqlite_manager is a Python package designed to streamline SQLite database creation from dataframes and query execution workflows.

Table of Contents

• Introduction
• Documentation
• Installation

Introduction

The sqlite_manager package streamlines SQLite database workflows by offering two primary functionalities:

1. Database Creation:

   • Generate an SQLite database directly from a pandas DataFrame and a schema file.

2. Query Execution:

   • Recursively execute SQL queries stored in directories on the database.
   • Automatically mirror directory structures for query results, outputting them as CSV files.
   • Avoid redundant query execution unless explicitly requested, saving time and computational resources.
   • Log all execution details and errors for easy debugging and traceability.

3. Automated Plot Generation:

   • Generate plots from query results using Python plotting functions stored in directories.
   • Automatically detect and execute plotting functions based on predefined rules.
   • Save plots to specified directories, ensuring traceable and reproducible workflows.
   • Prevent redundant plot generation, and log all activities for clarity and debugging.

Documentation

Check out the webpage for the documentation.

Installation

Install directly from GitHub:

pip install git+https://github.com/Thomas-Rauter/[email protected]