# 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.0",
"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": "1f70e881dadf864040a833c8f25af70c0ad4725151b451d94a6d4dfb0e74b4f5",
"md5": "aa837e09f1198f2da627bfae8f4f77e5",
"sha256": "0de9f1ca80c8d6f826f3c0fb03c18c55c568f537d707933b3e0748195e606b8c"
},
"downloads": -1,
"filename": "querysource-3.17.0-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "aa837e09f1198f2da627bfae8f4f77e5",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10.1",
"size": 6185185,
"upload_time": "2025-08-01T23:31:37",
"upload_time_iso_8601": "2025-08-01T23:31:37.612936Z",
"url": "https://files.pythonhosted.org/packages/1f/70/e881dadf864040a833c8f25af70c0ad4725151b451d94a6d4dfb0e74b4f5/querysource-3.17.0-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "b925a4188d25bc27d5aac4c729a87d16c80dadfdebcb6a5767da694376c482f7",
"md5": "cf84ceb4c1e113c3af6d6ecd560aecbd",
"sha256": "379933040ba92a1c8107bd1b194f40f3f202a02a74353362ff889f5b413ff7be"
},
"downloads": -1,
"filename": "querysource-3.17.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "cf84ceb4c1e113c3af6d6ecd560aecbd",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10.1",
"size": 6578308,
"upload_time": "2025-08-01T23:31:39",
"upload_time_iso_8601": "2025-08-01T23:31:39.980896Z",
"url": "https://files.pythonhosted.org/packages/b9/25/a4188d25bc27d5aac4c729a87d16c80dadfdebcb6a5767da694376c482f7/querysource-3.17.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "103cd40b5929b6a5e7770bb65046b3f16593122f81a1ed9936144b0f8161b492",
"md5": "3d918469463437db88f30af52958a826",
"sha256": "c20e83d77c7b45fd26d4d22222105236bc4fd2f285de81d6515c0d19b7b6c0b3"
},
"downloads": -1,
"filename": "querysource-3.17.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "3d918469463437db88f30af52958a826",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10.1",
"size": 6651571,
"upload_time": "2025-08-01T23:31:41",
"upload_time_iso_8601": "2025-08-01T23:31:41.470971Z",
"url": "https://files.pythonhosted.org/packages/10/3c/d40b5929b6a5e7770bb65046b3f16593122f81a1ed9936144b0f8161b492/querysource-3.17.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-01 23:31:37",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "phenobarbital",
"github_project": "querysource",
"github_not_found": true,
"lcname": "querysource"
}
JSON
