Quick interactive exploration of SQL databases.
Project description
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()Links
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file query-0.1.2.tar.gz.
File metadata
- Download URL: query-0.1.2.tar.gz
- Upload date:
- Size: 387.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a526839829c4bd96d8517edbcd73603c92e0674f9641929cf9c3bec409a0ff54
|
|
| MD5 |
b0eaf86fc45b0f0bec250f59d958a6e9
|
|
| BLAKE2b-256 |
8dd194b9c0a4d9217e0939136c8011cd59fa2966def84e24cd64965829daaa61
|
