Use Google Spreadsheet as frontend to Postgres

We are running a Postgres on [login to view URL] (please create your own free database for solving this project and give me access to it for testing). We also have a Google Spreadsheet and we want you to make it so that saving data in that Google Spreadsheet will save data in the postgresql database. I do not want this done by syncronizing every fifth minute, but rather using events that trigger saving in Postgres immediately. Before the saving has completed, then please make the background color of the cell that was updated red, and turn it back to the color that it originally had after the saving has completed. Please do not save all the table every time, just the changed cell. The column a in the spreadsheet will be equal to the "id" column of the postgresql table. Please hardcode the mappings of google spreadsheet (GS from now on) columns with postgresql columns. In a test spreadsheet have the columns: id adate adate_time text and the create table statement should be: create table atable (id int primary key, thedate date, thedate_time timestamp(6), the_text varchar(99999)) Please set the validation rules for the columns in the google spreadsheet, and ensure that no values will make your script unable to sync (apart from dates before 1970 and after 2030). The syncing needs to be within seconds usually. You should be able to connect directly to the database using JDBC: [login to view URL] Here is a proof of concept from a developer who attempted this task earlier (I think it is actually working) (but who suddenly did not answer me for 2 months). But there should be no need for the server-side stuff that is done there if you use JDBC connection to the database instead. It should not be possible to add nor delete postgresql rows from the GS. If you need one, you get a linux server for solving this project. Our preferred programming language is PHP. Here is a trigger that could be used: [login to view URL] A previous developer seems to have run into problems with Trigger Aggregate Execution Time found under "Quotas" here: [login to view URL], which slowed down his testing, so you should probably utilize multiple Google accounts and switch ownership to increase your quota. Please ensure that editing multiple cells in one go works. Also, ensure that if there are formulas in the cells, then it is the resulting values that get saved in the DB and not the formulas themselves. Max price for this project is 150$. And I need this within 5 days from you starting the project, but I need to see some sort of progress after 24 hours of me accepting your bid (working or non-working). To ensure that you have actually read all these requirements, I will only consider bids where I can find your freelancer.com username in this form: [login to view URL] You of course need to also submit a bid via Freelancer.com.