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:
Latest release

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-5.0.0.tar.gz (3.5 MB view details)

Uploaded Source

Built Distributions

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

querysource-5.0.0-cp313-cp313-musllinux_1_2_x86_64.whl (11.5 MB view details)

Uploaded CPython 3.13musllinux: musl 1.2+ x86-64

querysource-5.0.0-cp313-cp313-manylinux_2_28_x86_64.whl (11.5 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.28+ x86-64

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

Uploaded CPython 3.12musllinux: musl 1.2+ x86-64

querysource-5.0.0-cp312-cp312-manylinux_2_28_x86_64.whl (11.6 MB view details)

Uploaded CPython 3.12manylinux: glibc 2.28+ x86-64

querysource-5.0.0-cp311-cp311-musllinux_1_2_x86_64.whl (11.4 MB view details)

Uploaded CPython 3.11musllinux: musl 1.2+ x86-64

querysource-5.0.0-cp311-cp311-manylinux_2_28_x86_64.whl (11.3 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.28+ x86-64

querysource-5.0.0-cp310-cp310-musllinux_1_2_x86_64.whl (10.5 MB view details)

Uploaded CPython 3.10musllinux: musl 1.2+ x86-64

querysource-5.0.0-cp310-cp310-manylinux_2_28_x86_64.whl (10.5 MB view details)

Uploaded CPython 3.10manylinux: glibc 2.28+ x86-64

File details

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

File metadata

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

File hashes

Hashes for querysource-5.0.0.tar.gz
Algorithm Hash digest
SHA256 9fdd7760b06bceac6d82a4d03d9059313bf03bd5f975c112db0ea4f6361235df
MD5 e65ad68323cc0ba4fa6bbca72b500ce8
BLAKE2b-256 571ca25bc33b404fc8e498d9bcf7ff4bbb61c126a59712db83c7db10274bd4e4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp313-cp313-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 cce40c93e47bbbdf1d298878cd830f41bfd1214e7628e938e0ac7fefc8a7b1c4
MD5 2f2c83a4dc6745eadaf29db28e9592ec
BLAKE2b-256 e8a1a039620da67900a1dc0291e92496e8efba4edc69d3a3c03eda31af1a78c0

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp313-cp313-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 a4e0788af0d7f485c3551ed87fe5e050c10017e590feec50897b0dc02a116b29
MD5 d5acf5651e32eb74677a30bcbcf2b0f4
BLAKE2b-256 4b1e04a59739ccd4d11bb6ed032110f34e2c5bc879effeab000d07941f1d792c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp312-cp312-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 e7e278d967db3fde2e1be928002d0380950b2bd27809609b403242bd045d328e
MD5 88cee4fe2df357947bf08f9e1ed122bb
BLAKE2b-256 ab0c7f1b51573ef5ac828f33f82b6350ccc7f5500cab4971e2576a1240ceec1b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp312-cp312-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 4c489a00dc4c518c65053c95674807c5cb92c3ef2837feffabef0f362f310096
MD5 7d063d308457c032a37ce51503d3d716
BLAKE2b-256 06bab391ca67ace38a3b70f9cc751a8dae7e1db54be01ee2a8538a4d96e2f277

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp311-cp311-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 a0f6eb1ab305e1b3716b46fcb57e6eb53f019fc5f21bd44ba3899e55576d4be0
MD5 c49aaf9626751f1815acc2c6de9ba8c2
BLAKE2b-256 91259a77d26b6748d04cdf1cd9468308e44c70b65a668ae480963395c90bf278

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 7f93f8dfd0cdbae28599e736fb8d66c46f505d9a390e9082aa373370d18166ac
MD5 5bfd068c73816a5612340c4da218544b
BLAKE2b-256 e9fa32c3c5e21760e453c4c09a22aa18747fb4943174b47d14dfa8c4feb23f46

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp310-cp310-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 257a1468bc12130bdda3bef00081ff16785527cc14c9339716d367efb8bf5e99
MD5 7c12f0a84c6222825da5c2b435639819
BLAKE2b-256 a52e45050c48abb05c226e5534a59f90995165e5303a450b370d8e302c8f1a5d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for querysource-5.0.0-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 5270bb8da041954eae659eef45641a842ae5335b148b4c1afd08b66dfd5c78d8
MD5 e87c71f1680b04c0029396e10dec38f7
BLAKE2b-256 e5b782ae90e724c5ee883f45327de0f1b00855357a6458d888f2e6b385d4f4b2

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

5.0.0 This release

9 files

4.5.16

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