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()Interactive example
Links
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
query-0.1.4.tar.gz
(387.0 kB
view hashes)
