Home
The AMS was originally designed to help manage referencial projects for a post-doctorate research (http://alemdosandbox.ranoya.com). The goal was to make a easy way to track, classify, filter and show videos documenting physical computing projects around the world. Since the people involved wasn't able to use a SQL Database or any kind of raw technology, the solution was using a Google Docs Spreadsheet as a database, and it worked very well. Online and collaborative spreadsheets are very flexible, can filter data easily and can be much more visual than services like phpMyAdmin.
We wrote a Google Script as a handler between the spreadsheet and our website, so anyone could search and see the data we were mapping. Since then, the spreadsheet scheme was used to track, classify, filter and show a bunch of other documents, like academic papers, website bookmarks, bibliographical references, etc. and we thought that it could be shared.
Unfortunately, filtering spreadsheet data in Google Scripts is something very slow, and sending all data for a javascript application to manage ruined the mobile experience (we trie that too, and it was too heavy for mobile browsers). So, the way seems to be mirroring what is in a Google Spreadsheet page to a SQL Table automatically: people not familiar to databases can still work on the spreadsheet, they can organize data in their own way (sorting, dragging columns and rows, etc.), and filtering and serving data to any app or website will be fast.
In this repo, we are posting the original code, the new code for mirroring a Google Spreadsheet into a SQL Table, and a example spreadsheet.