# QuerySource #
QuerySource is a powerful Python library designed to streamline access to multiple databases and external APIs through a single, unified interface. Utilizing the proxy design pattern, QuerySource allows developers to seamlessly integrate various data sources into their projects without worrying about the complexities of managing multiple connections.
## Features ##
* Unified interface for querying multiple databases (Redis, PostgreSQL, MySQL, Oracle, SQL Server, InfluxDB, CouchDB, Druid)
* Support for external APIs (Salesforce, ShopperTrack, ZipCodeAPI, etc.)
* Easy-to-use API for executing queries
* Extensible design, allowing for easy addition of new data sources
## Installation
<div class="termy">
```console
$ pip install querysource
---> 100%
Successfully installed querysource
```
### Requirements ###
* Python >= 3.9
* asyncio (https://pypi.python.org/pypi/asyncio/)
## Basic Usage ##
QuerySource can be used in several ways, one is using QS object itself:
```python
from querysource.queries.qs import QS
query = QS(
query='SELECT * FROM tests',
output_format='pandas'
)
result, error = await query.query()
```
## Extending QuerySource ##
To add support for a new data source, create a new class inheriting from the BaseProvider or BaseAPI class and implement the required methods (prepare_connection, query, close). Then, register the new data source in the QuerySource class by adding it to the appropriate dictionary (_supported_databases or _supported_apis).
### Contributing ###
We welcome contributions to QuerySource! If you'd like to contribute, please follow these steps:
* Fork the repository
* Create a new branch for your feature or bugfix
* Implement your changes
* Add tests covering your changes
* Create a pull request against the original repository
### Contribution guidelines ###
* Writing tests
* Code review
* Other guidelines
### License ###
QuerySource is released under the BSD License. See the LICENSE file for more details.
Raw data
{
"_id": null,
"home_page": null,
"name": "querysource",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.10.1",
"maintainer_email": null,
"keywords": "querysource, database, query, aiohttp, web service",
"author": null,
"author_email": "Jesus Lara <jesuslarag@gmail.com>",
"download_url": null,
"platform": null,
"description": "# QuerySource #\n\nQuerySource is a powerful Python library designed to streamline access to multiple databases and external APIs through a single, unified interface. Utilizing the proxy design pattern, QuerySource allows developers to seamlessly integrate various data sources into their projects without worrying about the complexities of managing multiple connections.\n\n## Features ##\n\n* Unified interface for querying multiple databases (Redis, PostgreSQL, MySQL, Oracle, SQL Server, InfluxDB, CouchDB, Druid)\n* Support for external APIs (Salesforce, ShopperTrack, ZipCodeAPI, etc.)\n* Easy-to-use API for executing queries\n* Extensible design, allowing for easy addition of new data sources\n\n## Installation\n\n<div class=\"termy\">\n\n```console\n$ pip install querysource\n---> 100%\nSuccessfully installed querysource\n```\n\n\n### Requirements ###\n\n* Python >= 3.9\n* asyncio (https://pypi.python.org/pypi/asyncio/)\n\n## Basic Usage ##\n\nQuerySource can be used in several ways, one is using QS object itself:\n\n```python\nfrom querysource.queries.qs import QS\n\nquery = QS(\n query='SELECT * FROM tests',\n output_format='pandas'\n)\nresult, error = await query.query()\n```\n\n## Extending QuerySource ##\n\nTo add support for a new data source, create a new class inheriting from the BaseProvider or BaseAPI class and implement the required methods (prepare_connection, query, close). Then, register the new data source in the QuerySource class by adding it to the appropriate dictionary (_supported_databases or _supported_apis).\n\n\n### Contributing ###\n\nWe welcome contributions to QuerySource! If you'd like to contribute, please follow these steps:\n\n* Fork the repository\n* Create a new branch for your feature or bugfix\n* Implement your changes\n* Add tests covering your changes\n* Create a pull request against the original repository\n\n### Contribution guidelines ###\n\n* Writing tests\n* Code review\n* Other guidelines\n\n### License ###\n\nQuerySource is released under the BSD License. See the LICENSE file for more details.\n",
"bugtrack_url": null,
"license": "BSD-3-Clause",
"summary": "Aiohttp web service for querying several databases easily",
"version": "3.17.4",
"project_urls": {
"Documentation": "https://querysource.readthedocs.io/en/latest/",
"Funding": "https://paypal.me/phenobarbital",
"Homepage": "https://github.com/phenobarbital/querysource/",
"Say Thanks!": "https://saythanks.io/to/phenobarbital",
"Source": "https://github.com/phenobarbital/querysource/",
"Tracker": "https://github.com/phenobarbital/querysource/issues"
},
"split_keywords": [
"querysource",
" database",
" query",
" aiohttp",
" web service"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "3ea6a191fb71f60a027e0f65c24289691e9a525e6110a5a152a1c7cad32ebdac",
"md5": "1084004ceeff52944dfb9d4bbb86309c",
"sha256": "da52adeda2dc951fc5e299a858b9597f41d5d2c335d79e3b2475f967c19fa1e2"
},
"downloads": -1,
"filename": "querysource-3.17.4-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "1084004ceeff52944dfb9d4bbb86309c",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10.1",
"size": 6187083,
"upload_time": "2025-10-24T21:26:37",
"upload_time_iso_8601": "2025-10-24T21:26:37.982501Z",
"url": "https://files.pythonhosted.org/packages/3e/a6/a191fb71f60a027e0f65c24289691e9a525e6110a5a152a1c7cad32ebdac/querysource-3.17.4-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "9339b327ec98e02310cb02cbb003752dfd84fa0ffc9a0fa73778f24c75c9f8e7",
"md5": "0b0ec8ae366c001096bb34444a99c73c",
"sha256": "5550aa5bbcf8c5204153e2bf9ea557cf9fa0d65238af1e925ec84a75417446cc"
},
"downloads": -1,
"filename": "querysource-3.17.4-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "0b0ec8ae366c001096bb34444a99c73c",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10.1",
"size": 6580212,
"upload_time": "2025-10-24T21:26:40",
"upload_time_iso_8601": "2025-10-24T21:26:40.627018Z",
"url": "https://files.pythonhosted.org/packages/93/39/b327ec98e02310cb02cbb003752dfd84fa0ffc9a0fa73778f24c75c9f8e7/querysource-3.17.4-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "837ed87b200f363b1b3a56dec76356654890d023d5dcc3e7f09953e30ffcc177",
"md5": "2297276a747a815fbdcae5a9621228fd",
"sha256": "8fef1a6e9573c8f5ddc18b8e6cca839db2e7b0204ca4fdea8cea355c6a07517e"
},
"downloads": -1,
"filename": "querysource-3.17.4-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "2297276a747a815fbdcae5a9621228fd",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10.1",
"size": 6653464,
"upload_time": "2025-10-24T21:26:42",
"upload_time_iso_8601": "2025-10-24T21:26:42.538259Z",
"url": "https://files.pythonhosted.org/packages/83/7e/d87b200f363b1b3a56dec76356654890d023d5dcc3e7f09953e30ffcc177/querysource-3.17.4-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-10-24 21:26:37",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "phenobarbital",
"github_project": "querysource",
"github_not_found": true,
"lcname": "querysource"
}
JSON
