que
query
pypi i query
que

query

Interactive SQL database exploration in Python

by Nick Greenfield

0.1.4 (see all)License:MIT
pypi i query
Readme

query

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.

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

Demo in 2 lines


Explore the included demo database:

.. code:: python

    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:

.. code:: python

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

Interactive example

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



Links
`````
* `Code and additional details on Github: <http://github.com/boydgreenfield/query/>`_

GitHub Stars

175

LAST COMMIT

3yrs ago

MAINTAINERS

1

CONTRIBUTORS

2

OPEN ISSUES

0

OPEN PRs

1
VersionTagPublished
0.1.4
7yrs ago
0.1.3
8yrs ago
0.1.2
8yrs ago
0.1.1
8yrs ago
No alternatives found
No tutorials found
Add a tutorial