Pre-install ipython-sql package and have it configured with popular DB drivers e.g. Db2, MySQL, Postgres, ...
ipython-sql or SQL Magic makes it very easy to query databases. e.g to issue a query one only has to type the following in a notebook cell i.e. no need to prepare, execute statements and fetch results:
%sql select * from mytable
PS: For Db2 it implies ibm_db_sa also needs to be pre-installed.
Why is it useful?
|Who would benefit from this IDEA?|
How should it work?