Implementation: tabular data editing + publishing

I'd like to let the group know about a project I released today, that
implements some of the things we've been discussing (and will
hopefully implement all of them, later on).

It's basically an editing and viewing interface for tabular data,
which can import/export two files: a description of the table, and the
data for all the items in the table.

Here's the introduction: <http://git.macropus.org/vege-table/> and
some read-only examples that are still picky about which web browsers
they work in: <http://git.macropus.org/grocery-store/>

Features that the group might be interested in:

* The table is seeded with items (rows) by importing CSV or JSON
files, or by running a JavaScript function to import data from a
remote resource or paginated collection.

* New properties (columns) can then be added to the items by adding
"leaves" to the table. These are JS functions which take values from
other properties, optionally manipulate them, and can fetch data
asynchronously from remote resources (linked data!).

* If a remote resource is JSON-LD, it tries to use the context
document to convert the data type of each value appropriately. For
CSV, it currently requires that the conversion is specified manually,
as a JS function in a new leaf.

* Once the table has been built, publishing it is as simple as
exporting the description and data files, switching off the database,
and putting the project somewhere online. Currently the exported data
files are JSON, but I'll add CSV export soon…

If it's of interest to anyone in London, I'd be happy to do a
demonstration - it's a bit hard to describe in writing :)

Alf

Received on Friday, 16 May 2014 16:19:19 UTC