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.
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
Links
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)
| 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 |