search

lincolnturner / gspreadsheet_fdw

Multicorn-based PostgreSQL foreign data wrapper for Google Spreadsheets
MIT License
64 stars 11 forks source link

Write support #1

Open jmealo opened 8 years ago

jmealo commented 8 years ago

@lincolnturner kudos on writing a Google Sheets foreign data wrapper in 36 lines of Python. Any chance you'd be able to tackle write support?

If not, I may be able to, but it's unlikely to be "pythonic" as I only dabble in Python from time to time (and it's always a pleasure).

Thanks, Jeff

lincolnturner commented 8 years ago

Unfortunately no time soon.

This FDW has bitrotted in the last few months as Google has banned "programmatic login" and now insists that all 'apps' use OAuth2. This means, I think, getting an API key from the google dev console. I'm trying to use this on a Google Apps domain at my workplace, so this requires internal permission. I'm getting there...

So first priority is to make this work again with OAuth2 and document for users how to get an API key... then perhaps more features!

jmealo commented 8 years ago

@lincolnturner: I was thinking, would it better just to use a well-supported Python library for integrating with Google services to power this?

A quick search turned up these: