This is meant to be a simple way to explore a postgresql/mysql/sqlite database and get data out (super light wrapper to SQLAlchemy).
Connect with DB url in the following formats:
postgresql://someuser:somepassword@somehost[:someport]/somedatabase
mysql://someuser:somepassword@somehost[:someport]/somedatabase
sqlite:///somedb.db
Note: This package uses
pymysql
driver for connecting to mysql. Urls that start withmysql://
will automatically be changed to usemysql+pymysql://
.
Ensure the
pg_config
executable is on the system
$ sudo apt-get install -y libpq-dev
or
$ brew install postgresql
Then install sql-helper
$ pip3 install sql-helper
In [1]: from sql_helper import SQL
In [2]: sql = SQL('postgresql://someuser:somepassword@somehost/somedatabase')
In [3]: table_names = sql.get_tables()
In [4]: results = sql.execute('SELECT ...')
Install sqlalchemy-redshift
wherever you installed sql-helper
$ venv/bin/pip3 install sqlalchemy-redshift
Connect with DB url in the following format:
redshift+psycopg2://someuser:somepassword@somehost/somedatabase