Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It sounds like you need to write a web service in Python that consumes and returns <a href="http://www.json.org/" rel="noreferrer">JSON</a>. I'm not sure if the data is originating on the client or the server, so for this example, I'm assuming it comes from the client.</p> <ol> <li>POST your graph data in JSON format to your webservice</li> <li>Do processing server-side</li> <li>return JSON representing the results of the processing to the client</li> <li>Render it with d3.js</li> <li>User interaction on the client creates a new or modified data structure</li> <li>Go back to step 1</li> </ol> <p>Maybe your server-side web service method looks like this (this is pseudo-code based on <a href="http://webpy.org/" rel="noreferrer">web.py</a>):</p> <pre><code>import simplejson class ml(object): def POST(self,data=None): # turn the JSON string into a Python data structure d = simplejson.loads(data) # do stuff results = alter_data(d) web.header('Content-Type','application/json') # send JSON back to the client return simplejson.dumps(results) </code></pre> <p>And your client-side code might look something like this (again, just a rough sketch). This example assumes that you're using jQuery to do your AJAX stuff.</p> <pre><code>function render(data,textStatus) { d3 .select('svg') .selectAll('circle') .data(data) .enter() .append('circle') .on('click',function() { $.getJSON( 'your_webservice_url', // POST an updated data structure to your service { 'data' : alter_data(data) }, // Call the render method again when new data is received render); }); } </code></pre> <p>d3.js' <a href="https://github.com/mbostock/d3/wiki/Selections#wiki-enter" rel="noreferrer"><code>enter</code></a> and <a href="https://github.com/mbostock/d3/wiki/Selections#wiki-exit" rel="noreferrer"><code>exit</code></a> methods make updating the visual representation of your data very easy. I recommend reading the documentation for those.</p> <p><a href="http://mbostock.github.com/d3/ex/force.html" rel="noreferrer">This example</a> might give you some ideas about how to represent your graph data with JSON, and how to render it.</p> <p>Check out the <a href="https://github.com/mbostock/d3/wiki/Selections#wiki-on" rel="noreferrer"><code>on</code></a> method for an idea about how to trigger a POST to your web service when a node is clicked.</p> <p>I'm going to skip the really specific stuff, like displaying text with d3.js. I'm sure you can figure out how to do that by perusing the <a href="https://github.com/mbostock/d3/wiki" rel="noreferrer">d3.js documentation</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POBidirectional flow between D3.js frontend and Python Backend? / Interactive graphs in a website
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJohn Vinyard
    1. USJohn Vinyard
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBidirectional flow between D3.js frontend and Python Backend? / Interactive graphs in a website
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHmm ok! And how should I write the webfacing part... should that be in a python framework, or html or ...? @john
      singulars
      1. PO
      1. USEiyrioü von Kauyf
    2. COSince you mentioned Google App Engine, I'm guessing you'll want to write it with their [Python web framework](https://developers.google.com/appengine/docs/python/gettingstartedpython27/)
      singulars
      1. PO
      1. USJohn Vinyard
    3. COso they use a simple Web.py framework. I don't think it can do that much? They support Django and some others, but do you think that would be well suited for this?
      singulars
      1. PO
      1. USEiyrioü von Kauyf
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload