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

$ pip install querysource
---> 100%
Successfully installed querysource

Requirements

Basic Usage

QuerySource can be used in several ways, one is using QS object itself:

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.

Project links

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (5.0.0)

2 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for jelitox from gravatar.com jelitox Avatar for phenobarbital from gravatar.com phenobarbital

Credits

PyPI data
Data sourced directly from PyPI's database.

Author: Jesus Lara

License

BSD License (BSD-3-Clause)

Requires

Python <3.14, >=3.10.1

Provides Extra

analytics vectors geo sharepoint s3 dev

Tags

querysource database query aiohttp web service

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

querysource-4.5.15.tar.gz (3.2 MB view details)

Uploaded Source

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

querysource-4.5.15-cp313-cp313-musllinux_1_2_x86_64.whl (11.4 MB view details)

Uploaded CPython 3.13musllinux: musl 1.2+ x86-64

querysource-4.5.15-cp313-cp313-manylinux_2_28_x86_64.whl (11.4 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.28+ x86-64

querysource-4.5.15-cp312-cp312-musllinux_1_2_x86_64.whl (11.5 MB view details)

Uploaded CPython 3.12musllinux: musl 1.2+ x86-64

querysource-4.5.15-cp312-cp312-manylinux_2_28_x86_64.whl (11.5 MB view details)

Uploaded CPython 3.12manylinux: glibc 2.28+ x86-64

querysource-4.5.15-cp311-cp311-musllinux_1_2_x86_64.whl (11.3 MB view details)

Uploaded CPython 3.11musllinux: musl 1.2+ x86-64

querysource-4.5.15-cp311-cp311-manylinux_2_28_x86_64.whl (11.2 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.28+ x86-64

querysource-4.5.15-cp310-cp310-musllinux_1_2_x86_64.whl (10.4 MB view details)

Uploaded CPython 3.10musllinux: musl 1.2+ x86-64

querysource-4.5.15-cp310-cp310-manylinux_2_28_x86_64.whl (10.4 MB view details)

Uploaded CPython 3.10manylinux: glibc 2.28+ x86-64

File details

Details for the file querysource-4.5.15.tar.gz.

File metadata

  • Download URL: querysource-4.5.15.tar.gz
  • Upload date:
  • Size: 3.2 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/7.0.0 CPython/3.12.3

File hashes

Hashes for querysource-4.5.15.tar.gz
Algorithm Hash digest
SHA256 c853508efebe10f6bf8d222013a78cfac46d846b55b75d261417c5ba53441f34
MD5 c582019f4df7c84cd5d18e35cbb3d4b5
BLAKE2b-256 21028bfcba97930266296e44e6f9b228e39aef4aca037905f63727c76aa07dc1

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp313-cp313-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp313-cp313-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 af4b0b674ddfe47bb37cbc135bf7a1b35dcad07e25c3eb416394ef7cf18524b6
MD5 2a8690cd2a1852591f8c3f5ca51fe2de
BLAKE2b-256 8fc9476174ac8e1c2da8429a180681d01bd47046fc39cfb9bc7d3b7cbf9c1d64

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp313-cp313-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp313-cp313-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 4f4cd9345736ace4c568fed1e22b98d85c60590af8971722035a22158ba8e07a
MD5 6714bb1368ee663b35e98d5c92d665ec
BLAKE2b-256 5e3df3a05b1654b4df7882d30dd0625accf53b4703467e5d0fcf474580152560

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp312-cp312-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp312-cp312-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 5b8c2894106a5b1cf7d89620c892a758f2348fd9e261499d4a65c7e2e8cbefcc
MD5 da67573b2bd2c364cd2eacc51853c7a3
BLAKE2b-256 066dbc8a6261446cc3fc7ccf816d8eb295a53afe5a3717ac627cccb31596abff

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp312-cp312-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp312-cp312-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 8e5172c6bf510a53978e09ff434e26fbed9f0d01311f8574f7376a4a7a1b2108
MD5 47420295c097e867c8bfb9f63948bff1
BLAKE2b-256 6cd02c53700062923e7ea129a81a08d7c88cfe8082326e3f67936e08689d0f0d

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp311-cp311-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp311-cp311-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 e462caadbf1da44b590279724441e12c12cfb333b95d6d9e187ee9e0a2230f62
MD5 217fe2da8fc36ffc03e5b57bca9991ae
BLAKE2b-256 4b2173967d0d4afb8e7933f23d7a0546c4e7ce64151b118128aa70cf3502b321

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp311-cp311-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 56333b60ce3193b5762f6cc21b5537476cb43219938c2b016eb7f384742f8673
MD5 c9938c5cb3020a3f200f980b051eadf3
BLAKE2b-256 5dd6d07dc8af7fde072a15a9bf77e17625b8a064d978be0b5c6ce0048523cf73

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp310-cp310-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp310-cp310-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 f5f734182336450014acec9fded90428591834090ec1cebc069c8202be8a5ead
MD5 c66b42e134f3eddf57fe428528c87747
BLAKE2b-256 0c651fb83dfba764633cae54ece4b52447b609304a0d69d4813a71bcadce7693

See more details on using hashes here.

File details

Details for the file querysource-4.5.15-cp310-cp310-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.15-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 51c99fb45a50df290806f734b9172acb86192a21fa4266c434fd414970c89c27
MD5 2058d5311c1eff4c1ef846b778c7db62
BLAKE2b-256 e862fd21d74d80ed06f875e19e4c8f1677b63026df22c5262524339d92c4ad52

See more details on using hashes here.

Release history Release notifications | RSS feed

5.0.0

9 files

4.5.16

9 files

This release

4.5.15 This release

9 files

4.5.14

9 files

4.5.13

9 files

4.5.12

9 files

4.5.11

9 files

4.5.10

9 files

4.5.9

9 files

4.5.8

9 files

4.5.7

9 files

4.5.6

9 files

4.5.5

9 files

4.5.4

9 files

4.5.1

9 files

4.5.0

9 files

4.4.3

9 files

4.4.2

9 files

4.4.0

9 files

4.3.0

9 files

4.2.1

9 files

4.2.0

9 files

4.1.12

9 files

4.1.11

9 files

4.1.10

9 files

4.1.9

9 files

4.1.7

9 files

4.1.6

9 files

4.1.5

9 files

4.1.4

9 files

4.1.3

9 files

4.1.2

9 files

4.1.1

9 files

4.1.0

9 files

4.0.2

9 files

4.0.1

9 files

4.0.0

9 files

Pre-release

4.0.0rc1

9 files

3.17.11

3 files

3.17.10

3 files

3.17.9

3 files

3.17.8

3 files

3.17.7

3 files

3.17.6

3 files

3.17.5

3 files

3.17.4

3 files

3.17.3

3 files

3.17.2

3 files

3.17.1

3 files

3.17.0

3 files

3.16.9

4 files

3.16.8

4 files

3.16.7

4 files

3.16.6

4 files

3.16.5

4 files

3.16.4

4 files

3.16.3

4 files

3.16.2

4 files

3.16.1

4 files

3.15.43

4 files

3.15.42

4 files

3.15.41

4 files

3.15.40

4 files

3.15.39

4 files

3.15.38

4 files

3.15.37

4 files

3.15.36

4 files

3.15.35

4 files

3.15.34

4 files

3.15.33

4 files

3.15.32

4 files

3.15.31

4 files

3.15.30

4 files

3.15.29

4 files

3.15.28

4 files

3.15.27

4 files

3.15.26

4 files

3.15.25

4 files

3.15.24

4 files

3.15.23

4 files

3.15.22

4 files

3.15.21

4 files

3.15.20

4 files

3.15.19

4 files

3.15.18

4 files

3.15.17

4 files

3.15.16

4 files

3.15.15

4 files

3.15.14

4 files

3.15.12

4 files

3.15.11

4 files

3.15.10

4 files

3.15.9

4 files

3.15.8

4 files

3.15.7

4 files

3.15.6

4 files

3.15.5

4 files

3.15.4

4 files

3.15.3

4 files

3.15.2

4 files

3.15.1

4 files

3.15.0

4 files

3.14.1

4 files

3.14.0

4 files

3.13.15

4 files

3.13.14

4 files

3.13.13

4 files

3.13.12

4 files

3.13.11

4 files

3.13.10

4 files

3.13.9

4 files

3.13.8

4 files

3.13.6

4 files

3.13.5

4 files

3.13.4

4 files

3.13.3

4 files

3.13.2

4 files

3.13.1

4 files

3.13.0

4 files

3.12.33

4 files

3.12.32

4 files

3.12.31

4 files

3.12.30

4 files

3.12.29

4 files

3.12.28

4 files

3.12.27

4 files

3.12.26

4 files

3.12.25

4 files

3.12.24

4 files

3.12.23

4 files

3.12.22

4 files

3.12.20

4 files

3.12.19

4 files

3.12.18

4 files

3.12.17

4 files

3.12.16

4 files

3.12.15

4 files

3.12.14

4 files

3.12.13

4 files

3.12.12

4 files

3.12.11

4 files

3.12.10

4 files

3.12.9

4 files

3.12.8

4 files

3.12.7

4 files

3.12.6

4 files

3.12.5

4 files

3.12.4

4 files

3.12.3

4 files

3.12.2

4 files

3.12.1

4 files

3.11.23

4 files

3.11.22

4 files

3.11.21

4 files

3.11.20

4 files

3.11.18

4 files

3.11.17

4 files

3.11.16

4 files

3.11.15

4 files

3.11.14

4 files

3.11.13

4 files

3.11.12

4 files

3.11.11

4 files

3.11.10

4 files

3.11.9

4 files

3.11.8

4 files

3.11.7

4 files

3.11.6

4 files

3.11.5

4 files

3.11.4

4 files

3.11.3

4 files

3.11.2

4 files

3.11.1

4 files

3.11.0

4 files

3.10.2

3 files

3.10.1

3 files

3.10.0

3 files

3.9.3

3 files

3.9.2

3 files

3.9.1

3 files

3.9.0

3 files

3.8.14

3 files

3.8.13

3 files

3.8.12

3 files

3.8.11

3 files

3.8.10

3 files

3.8.9

3 files

3.8.8

3 files

3.8.7

3 files

3.8.6

3 files

3.8.5

3 files

3.8.4

3 files

3.8.3

3 files

3.8.2

3 files

3.8.1

3 files

3.8.0

3 files

3.7.13

3 files

3.7.12

3 files

3.7.11

3 files

3.7.10

3 files

3.7.9

3 files

3.7.8

3 files

3.7.7

3 files

3.7.6

3 files

3.7.5

3 files

3.7.4

3 files

3.7.3

3 files

3.7.2

3 files

3.7.1

3 files

3.7.0

3 files

3.6.53

3 files

3.6.52

3 files

3.6.51

3 files

3.6.50

3 files

3.6.49

3 files

3.6.48

3 files

3.6.47

3 files

3.6.46

3 files

3.6.45

3 files

3.6.44

3 files

3.6.43

3 files

3.6.42

3 files

3.6.41

3 files

3.6.39

3 files

3.6.38

3 files

3.6.37

3 files

3.6.36

3 files

3.6.35

3 files

3.6.34

3 files

3.6.33

3 files

3.6.32

3 files

3.6.31

3 files

3.6.30

3 files

3.6.28

3 files

3.6.27

3 files

3.6.26

3 files

3.6.25

3 files

3.6.24

3 files

3.6.23

3 files

3.6.22

3 files

3.6.21

3 files

3.6.20

3 files

3.6.18

2 files

3.6.17

2 files

3.6.16

2 files

3.6.15

2 files

3.6.14

2 files

3.6.13

2 files

3.6.11

3 files

3.6.9

3 files

3.6.8

3 files

3.6.7

3 files

3.6.6

3 files

3.6.5

3 files

3.6.4

3 files

3.6.3

4 files

3.6.2

2 files

3.6.1

2 files

3.6.0

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page