Another option is the BeakerX SQL plugin, which includes JDBC drivers for many popular databases and allows you to load your own as well (note this has changed since the last time I posted about it here). No magic is required and it supports syntax highlighting and autocomplete: https://github.com/twosigma/beakerx/blob/c57b6e5b0fde5eea4e6e9c3bf5ff8a9f608cf776/doc/sql/SQL.ipynb
On Fri, Dec 1, 2017 at 10:41 AM, Tony Hirst <[email protected]> wrote: > Would a magic approach work? > > eg > > https://github.com/catherinedevlin/ipython-sql > > On Friday, 1 December 2017 14:06:01 UTC, Jonathan Robie wrote: >> >> I am trying to understand how difficult it would be to set up a custom >> environment for people querying syntax trees. Ideally, I would like to set >> up a database server and provide people with an environment where the >> database connection is already open and the functions they use to execute >> queries are already defined. >> >> The attachment shows a session that does this. I would like to make it >> possible to get started without executing the lines at the beginning that >> open the database and define the functions. I have only been using Jupyter >> for a few weeks, but I am very impressed and would like to make this kind >> of functionality available in a user-friendly way to my own very >> specialized community. >> >> Can you help me know where to look in the documentation, or where to find >> examples of how people have done this? >> >> Thanks! >> >> Jonathan >> > -- > You received this message because you are subscribed to the Google Groups > "Project Jupyter" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/jupyter/4070a7e8-12a4-4da0-a120-b94ed342fe4b%40googlegroups.com > <https://groups.google.com/d/msgid/jupyter/4070a7e8-12a4-4da0-a120-b94ed342fe4b%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- BeakerX.com ScottDraves.com <http://www.ScottDraves.com> @Scott_Draves <http://twitter.com/scott_draves> -- You received this message because you are subscribed to the Google Groups "Project Jupyter" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jupyter/CAMaD%2Bf74MeovQw5raKnTxc4xkRo9Qo1TUyebChxY9LMv8MmKNw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
