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.12.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.12-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.12-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.12-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.12-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.12-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.12-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.12-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.12-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.12.tar.gz.

File metadata

  • Download URL: querysource-4.5.12.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.12.tar.gz
Algorithm Hash digest
SHA256 381e374d84c48bb102ddc071799ab47dd670d95c67ddcb5b636d73a0035a3aa2
MD5 1bfc8ccba3cdc0625a8a3d27c147ef78
BLAKE2b-256 2ff07193959234df831549155946b00d774226cff5cd35dd3f0dd3237c72d179

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp313-cp313-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 45fe5ec41f4be61a6e5fa6c5b2aa82a7e7dbde828698d660c8bce511ab02c2c4
MD5 d53d1777675f1fed27be23f313d38f03
BLAKE2b-256 8ba2930fd3dafab8f0622f3922046715fca733e34e758eb0fa08d0d1d810aec6

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp313-cp313-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 adb48e778822ddf0bc3db67cba31cc24c72902766772bbaa0f40fbdc7b559e95
MD5 120726fb5d9526a4f9744639c93792ad
BLAKE2b-256 f3524551d7c1a03b56ff0cd26f37c48c231952b4da11e223c870d4632815136e

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp312-cp312-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 a3f817a27bd2688b4ad3c3e6cf73a35b1b2c4383be903e770ebc1865e09d9d47
MD5 0a6bad98eb4a5b9a31ab2987c47db657
BLAKE2b-256 5159241766cf59ff19869df5674d9c08daad107a74d713ed62b22b526c0e76c6

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp312-cp312-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 6ddb8a92d32244a0d471aaf8c76247ee04e7624089f59f312ee0fcc4094783ad
MD5 0d51cb40aab030798b0bf289bc0db1d4
BLAKE2b-256 14d5d539b3afba744b2f13a4f3149d8f1832fa9681b5218c77fc29150a24f2de

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp311-cp311-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 30a224efad4b1a54d616a7eb2b8239e95deeb21f68a56f643d471797dd0fb73b
MD5 fc74075cb329da09586bb4e1fcbc1efd
BLAKE2b-256 23e56b07f41c28d26ee833b6db5aba8674b41cf64734366f7f424966d2428a07

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 7b9c5e6d1f72791ef35bead746982ac3c0399037fc35c03748dd9a4d7d1535e8
MD5 9143aed1c34fb25bf45dd9716c8bdded
BLAKE2b-256 dfb810223185afad2aeabacf804786967db37f67210fbf0da687e9baa2c3a5ac

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp310-cp310-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 55d5f5a2affc71fe4f225544f383c88effd6ea33550866b5049b796d2f7d48aa
MD5 569455b484ec2b6b642335c9361d0d6b
BLAKE2b-256 d428a15b5e2ab55bd32d0bbf3bcca7d0807143bbf93e8c851132929bfdcdba74

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.12-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 9a63d6ebfb2c699ec8e73b7cb1b556182accbaebadd69d3779cf0fbabf8dd033
MD5 af9f7495ab3601032d0aac569ae73a2b
BLAKE2b-256 a64d2a04bc3666395aa8ec252a4af00da3987e2d1be8f669eb707dace0c72bb0

See more details on using hashes here.

Release history Release notifications | RSS feed

5.0.0

9 files

4.5.16

9 files

4.5.15

9 files

4.5.14

9 files

4.5.13

9 files

This release

4.5.12 This release

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