Query SQL databases via ODBC

pemo's picture

It would be great to be able to connect to various databases (ODBC, SQL, Postgres etc.), with structured data loading of XML, JSON, CSV, TXT file types (I see this is listed elsewhere in the roadmap) - including multidimensional lists/arrays/matrices.

Of particular interest would be the ability to query NetCDF files via a THREDDS server, using URL strings to query structured scientific data via OPenDAP. This would open up Vuo for scientific visualisation development (my research area) and take it leaps and bounds beyond Quartz Composer. In addition, if some functionality similar to d3.js (e.g. standard graphing types) and WebGL support was implemented - the Data Scientist mind would boggle, given the limits of MatPlotLib, Mayavi etc.

Application scenario: Vuo composition as visualisation front-end for oceanographic data (NetCDF) on a (e.g.) THREDDS server, interaction via Leap and wand devices, 3d mouse, enabling tagging of data for subsequent computational routines in Python etc.


Proposed nodes

(Mockup by Team Vuo.)

For database support, Team Vuo proposes adding the following nodes:

  • Query ODBC Database — Connects to an existing ODBC data source (DSN) on the workstation, and executes a prepared SQL query.
    • ODBC drivers are available for many database servers, including Microsoft SQL Server, Microsoft Access, Oracle, PostgreSQL, and MySQL.
    • This node provides an interface to specify the query and its value placeholders — for example, SELECT * FROM company.employees WHERE location = ? AND age > ?. An input port is created for each value placeholder (parameter1 and parameter2 in the mockup below). These input ports have generic types, allowing you to provide either text, integers, or real numbers.
    • If the query returns rows, they are provided as a list via the rows output port.
  • Get Row Value — Outputs the value of the specified column in the row.

Here's a simple composition demonstrating how these nodes could be used:

Screenshots, Mockups, and Videos: 

Mockup

Component: 

Tags: 

Notes from Team Vuo

Vuo Pro: 

Yes — requires a Vuo Pro license

Complexity: 

●●○○ — A few weeks of work
Subscribe to RSS - scientific visualisation