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

File metadata

  • Download URL: querysource-4.5.14.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.14.tar.gz
Algorithm Hash digest
SHA256 5ad2ec96946a82d25646256f3988710165b733dcbf458f51e2588c0190355853
MD5 badbf9c5b64e66d55bba76d38dd287a9
BLAKE2b-256 727afc66eeeae150ebdf9af644ecbba6b97534ab50c4a6d805c15bd91f1168c0

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp313-cp313-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 4379b16d92217463dd13054f1bc9c11c1a142b7e9fa06d4a046f2e73312c7587
MD5 8fc95bcd65443db8fa3e7acf74660e29
BLAKE2b-256 df6b8c0fc0630451f4a3bed418f2fdf16de4c94f96f77269234e11bbefcc2a33

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp313-cp313-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 c2a3e1b54ccabde7ea55df8a2f62861772204ee8eb0bf470ea8b1e659acda354
MD5 7efc790e24f09df58dec01e17e628962
BLAKE2b-256 47d459edc28be9d1f9f8026bd97a38248fc673c782d45748363cc6fa5c285bfa

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp312-cp312-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 a05aa4c7e99be46b778fb32f778208d8b19236b016d3c8f6c73ac511812dd628
MD5 e0932e654080cd5e2305a3605851329d
BLAKE2b-256 3e9e0165eb879df822e784c60b74e1bf16d5e0dabcf56f3bfc926be57a78ae75

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp312-cp312-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 2db3d0b91f49a6d24d41e8ecd6f9a1f7837b561072f349cec8d93fdb2a219195
MD5 b937901fd3114da1fe618cf966b4565f
BLAKE2b-256 4e7d0277f85c76982e2a4a687c9661979417844ff8473675ed7082b2fac4d532

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp311-cp311-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 2ccc1c808a9192c87721734a932922a4f5feb257835993c7c828830623f8cb4c
MD5 cfc8e178c7156000007a6e82ecc9a67a
BLAKE2b-256 fd907d0722535a1a1ed1403785e3bec53ef8b7677a4ec15a8b26001acabd9096

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 b3c1ed188f70fe2d772b09035b8e48a7093e72c564babf3ca080b73358b5c382
MD5 fa13f13bea13c1553f97f0dbe1cb2d64
BLAKE2b-256 529e0bce671cd0ddcfad2f721b80acf6f74b07b073dbff11037f83f508d707a5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp310-cp310-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 33278fbd8a0d3afd880899468a4ba861086d3bfd60089987c8b5a23e715c039f
MD5 d24575797d29ab09fd6107c62748681d
BLAKE2b-256 2e9fc8b5cca3516c0a2695ca87be613914626997f3b03f0bd40e74aa6a85e8a9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.14-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 68ef6ce9dcf1207c58467ec50b39d2595119153f8c30dfb8778c35f481839581
MD5 9dc3eaab77e68f0ed4de2e22d77e1519
BLAKE2b-256 0c7ecefcbb2407294ffb079ea07d4bcceb70838b761d9a524f87a413ad5a43ee

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

This release

4.5.14 This release

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