Metadata-Version: 2.1
Name: BlueScope
Version: 1.0.0a1
Summary: Library to profile and compare SQL queries for different databases.
Home-page: https://github.com/Arkady-A/BlueScope
Author: ArkadyA
Author-email: mirzabekian.arkadii@gmail.com
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: GNU General Public License v3 (GPLv3)
Classifier: Operating System :: OS Independent
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: asn1crypto==1.5.1
Requires-Dist: beautifulsoup4==4.12.3
Requires-Dist: boto3==1.34.34
Requires-Dist: botocore==1.34.34
Requires-Dist: build==1.0.3
Requires-Dist: certifi==2024.2.2
Requires-Dist: charset-normalizer==3.3.2
Requires-Dist: colorlog==6.8.2
Requires-Dist: idna==3.6
Requires-Dist: iniconfig==2.0.0
Requires-Dist: jmespath==1.0.1
Requires-Dist: lxml==5.1.0
Requires-Dist: numpy==1.26.3
Requires-Dist: packaging==23.2
Requires-Dist: pluggy==1.4.0
Requires-Dist: pyproject_hooks==1.0.0
Requires-Dist: pytest==8.0.0
Requires-Dist: python-dateutil==2.8.2
Requires-Dist: pytz==2024.1
Requires-Dist: redshift-connector==2.0.918
Requires-Dist: requests==2.31.0
Requires-Dist: s3transfer==0.10.0
Requires-Dist: scipy==1.12.0
Requires-Dist: scramp==1.4.4
Requires-Dist: six==1.16.0
Requires-Dist: soupsieve==2.5
Requires-Dist: urllib3==2.0.7

<div style="display: flex; justify-content: left; align-items: left;">
  <img src="media/bluescope3.svg" style="width: 100%; max-width: 360px;" alt="BlueScope">
</div>

Introduce science to SQL optimization.

# Description
Profiles the performance of SQL queries by running the N times and measuring the time it takes to execute 
with minimizing any external reasons such as compilation time, queue time e.t.c.

How many times SQL query will be run is determined by confidence level and margin of error. 

Compares results of 2 different queries using Student's t-test. Returns the result of the test (p-value) and the conclusion.

Table of currently supported databases:

| Data Base           | Current status |
|---------------------|---------------|
| Redshift Serverless | Supported  ✅   |
| Redshift Dedicated  | In development ⏳|
| BigQuery            | Planned       |
| PostgreSQL          | Planned       |
| MySQL               | Planned       |
# How to use
TBD
# How to contribute
TBD
# License
⚖️ GPL-3.0
# Contact
Maintainer: Mirzabekian Arkadii 📧 [Email](mailto:mirzabekian.arkadii@gmail.com)
