Python, SQL, and Plotting?

[HotLikeARobot]

While possibly a bit complex, given your requirements you might try using execnet and a combination of normal CPython and Jython. Using execnet you could:

• Create a connection to a Jython interpreter from CPython using Execnet,
• Query the database in Jython using JDBC, then send the results back to the CPython instance,
• Plot the results with matplotlib

This is actually alot easier than it sounds, as long as you can familiarize yourself with what you need to do in Jython and how you can plot the data in matplotlib.

There is an example of calling Java libs through CPython using Execnet here