News for hackers. Stuff that matters.
Re:Automatic REST API for Any Postgres Database by curiously on Saturday January 03, 2015 @05:13PM (#8832214)
What I really want is actually a way to turn a xlsx or a csv file into a REST API. For example if there's a subcategory column, I want it to be hierarchial.
Re:Automatic REST API for Any Postgres Database by kennywinker on Saturday January 03, 2015 @10:47PM (#8833198)
Two suggestions for csv -> api:

1. Parse: http://blog.parse.com/2012/05/22/import-your-csv-data-to-par...

2. csv to api https://github.com/project-open-data/csv-to-api

Though if your data really is as simple as a single table (a csv files tend to be), you could probably put together a sinatra or express app in a day or two depending on your skill level.

Re:Automatic REST API for Any Postgres Database by jhgg on Saturday January 03, 2015 @05:25PM (#8832282)
You should be able to achieve that with this tool paired with postgres foreign data wrappers!
Re:Automatic REST API for Any Postgres Database by curiously on Saturday January 03, 2015 @05:37PM (#8832331)
do you have more information on this?

or do open source solutions already exist that convert spreadsheet into API?

Re:Automatic REST API for Any Postgres Database by jhgg on Saturday January 03, 2015 @06:49PM (#8832530)
Re:Automatic REST API for Any Postgres Database by BjoernKW on Saturday January 03, 2015 @06:36PM (#8832494)
Not quite there yet (no hierarchical structure etc.) but I think sheetlabs seems like what you're looking for: https://sheetlabs.com
Re:Automatic REST API for Any Postgres Database by bthomas on Saturday January 03, 2015 @06:13PM (#8832426)
Something like this that that could operate efficiently on 100M+ rows would be hugely valuable in biology