Skip to main content

query is a simple module for quickly, interactively exploring a SQL database. Together with IPython, it supports quick tab-completion of table and column names, convenience methods for quickly looking at data (e.g., .head(), .tail()), and the ability to get a rich interactive database connection up in only 2 lines by setting a few required environmental variables.

https://travis-ci.org/boydgreenfield/query.svg?branch=v0.1.4

Demo in 2 lines

Explore the included demo database:

from query import QueryDb
db = QueryDb(demo=True)

Real-world use case in 2 lines

Or set a few environmental variables (QUERY_DB_DRIVER, QUERY_DB_HOST, QUERY_DB_PORT, QUERY_DB_NAME, and QUERY_DB_PASS) and get started just as quickly:

from query import QueryDB  # capital 'B' is OK too :)
db = QueryDB()

Interactive example

https://github.com/boydgreenfield/query/raw/v0.1.2/docs/images/interactive_demo.gif?raw=True

Metadata

Release files for query 0.1.4

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for query 0.1.4
File Size Uploaded
query-0.1.4.tar.gz 387.0 kB Details

Release files / query-0.1.4.tar.gz

Download URL query-0.1.4.tar.gz
Size 387.0 kB
Tags Source
SHA-256 checksum
How to use checksums
d7ea720b2646c0fe7ea632c5443e86b86e16247b6786d5096627e5204efe992e
BLAKE2b-256 checksum
How to use checksums
e11e3fb4dc69ff757c9c0e107f7620b08051d856beee0db3e8be443f6e213401
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

0.1.4 This release

1 release file

0.1.3

1 release file

0.1.2

1 release file

0.1.1

1 release file

0.1.0

1 release file

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