Library to profile and compare SQL queries for different databases.
Project description
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file BlueScope-1.0.0a2.tar.gz.
File metadata
- Download URL: BlueScope-1.0.0a2.tar.gz
- Upload date:
- Size: 18.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 04caff2325370a433a179c5ebc48df9690e3f4baf9a8b3a64cbeea97a4d25343 |
|
| MD5 | 5c3f45d12ed49870a96b24c3cb1d3b5a |
|
| BLAKE2b-256 | 8b3ecf4d506bd1d537ed9a23f8b4f9317e31f4c29fd80a878f29624da4d65ef7 |
File details
Details for the file BlueScope-1.0.0a2-py3-none-any.whl.
File metadata
- Download URL: BlueScope-1.0.0a2-py3-none-any.whl
- Upload date:
- Size: 18.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | af82325599422b065af391a25fb3b4462d6b124a7e4a1202a7caaedf3eaae313 |
|
| MD5 | 2614bbc78bfb96a252e1c38eb948af62 |
|
| BLAKE2b-256 | eaa188811dc3772ac10714e71e187c90e23b4352f61896968daf39c96227474f |
