Conference Schedule - PGConf.EU 2015

Back

Generic Editor for Hierarchical Data Running in the Browser

Date: Oct. 30, 2015
Time: 11:50 - 12:40
Room: Ballroom A+B
Level: Intermediate

Tables/rows in SQL-databases, being joined by foreign keys, can be viewed as a tree-structure similar to a file explorer. Tables correspond to directories and rows to files. Each node in the tree is clearly defined by its path. This path can be considered as the URI of the table or row under consideration.

Putting this together, we developed a generic, configurable JavaScript based editor with three main modules: - JSON files, defining the tables and hierarchy under consideration. - REST webservice, consuming the URIs. Based on node.jsand node-postges. - HTML5 browser GUI as a single page application, implemented with the open source Qooxdoo framework.

Our solution avoids the creation of individually designed dialogs. It gives the feeling of a local application without reloading pages from the server.

In the talk, structures and details will be discussed and explained with the help of a live demo, based on a real industrial application.

Speaker

Roland Sonnenschein