Custom Environments

[Jonathan Robie]

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

[Tony Hirst]

Would a magic approach work?

eg

https://github.com/catherinedevlin/ipython-sql

[Jonathan Robie]

Hmmm, that looks about perfect ... where do I learn about how SQL Alchemy Magic is implemented?

Jonathan

[sp...@draves.org]

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

--
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 jupyter+unsubscribe@googlegroups.com.
To post to this group, send email to jup...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jupyter/4070a7e8-12a4-4da0-a120-b94ed342fe4b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

BeakerX.com

ScottDraves.com

@Scott_Draves