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.16.tar.gz (3.3 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.16-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.16-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.16-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.16-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.16-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.16-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.16-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.16-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.16.tar.gz.

File metadata

  • Download URL: querysource-4.5.16.tar.gz
  • Upload date:
  • Size: 3.3 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.16.tar.gz
Algorithm Hash digest
SHA256 60908abb24bd368d03448bec53d36f1a5b7f603ed5531d4ee5c4b0bb44a72bee
MD5 0b44cd9253a525fd5009d34522482924
BLAKE2b-256 57aba4dd078867f84e88b5a756ecd841b699418d4670ad37f6e00ecbcb738049

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp313-cp313-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 5994e40a95b39d79355768d320db9cbb9867e85b0a875333757452f3a5303072
MD5 915cc5321022bb8c08dd917ced29f254
BLAKE2b-256 35bfd28fcf90c97a29603adba2abfbafa273d69d37c1baca1b4ab87f1eaf81e4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp313-cp313-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 f457b1e55b0bc4945a8fcf396425b75920277926ec93d47f163887fce27bf725
MD5 ec79160abf87d3eb4290214a6d96b02d
BLAKE2b-256 e6c08da514dd9a1d649a37bb5879c0f8ac5512b5f574b3ac10f49d9a04407aa9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp312-cp312-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 6b1de094016dbe95e6d8100c7c1ce30309aa6d4ba864aeaa9a1340b9a666a292
MD5 c05ff055d955193235fadc42e4a4ea27
BLAKE2b-256 30112534482eae13d13d1c0a4dc0cc3021ea4125c32cfc5124d11c92a5f5b669

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp312-cp312-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 945d659497fd6f06ecde21ba82917bf1d240fad95c4549fee2dc268aa7f1a0c5
MD5 40b08e9aee2b092fb81f67fbd396e4d8
BLAKE2b-256 11327bd7a1ef70ab94ca1f72f3b246ad934938b53dd27cbf752f1f6203eb416b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp311-cp311-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 fcb4bde1f09318ac003905140852e57dc2617b726f2c841c682b26f5c373b5c5
MD5 8a7711659644545c5850d134034fa05a
BLAKE2b-256 032e39df3d4c15a6e009cc32c4ce44293c4486e3857856471989030665f89d62

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 ea7390b58a6f08b6ecb90bc856c293a0bc88bca1811049c0930969853cb93283
MD5 00ecfd538b5393a7020fce108b8ff3e2
BLAKE2b-256 bab19578d86f46fae75d07f20d592783e12580fbe9bd78cdade3de8aa5c32c5c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp310-cp310-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 2ed7b759ced810ed7dffccfd7ce7174b0d8f2ef98eae5ace4ae0bf081b26b7ac
MD5 8ceb70b7a2be1745a34a9cf178cf8dd8
BLAKE2b-256 69932eaafaf168dd5cbab06d44ff1a2ee5d13cca84f72b517a6a2101ac005081

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-4.5.16-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 d099657a02b70b35b7ae4898f044c9256ffe47c4295591d40e89cb7452483800
MD5 a478eeb8cb27b1698cd655d94525df8c
BLAKE2b-256 f3b24d671edf781fabf368dc07ecbe840402b8d243f98154c349212e8ac9719c

See more details on using hashes here.

Release history Release notifications | RSS feed

5.0.0

9 files

This release

4.5.16 This release

9 files

4.5.15

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