Multicorn based PostgreSQL foreign data wrapper for Google Spreadsheets
PostgreSQL 9.1+ with Multicorn extension installed.
If you haven't used Multicorn yet, enable it with:
create extension multicorn;
From source:
git clone https://github.com/TheDeadJoe/google_spreadsheets_fdw
cd google_spreadsheets_fdw
python setup.py installcreate server multicorn_srv foreign data wrapper multicorn options (
wrapper 'google_spreadsheets_fdw.GoogleSpreadsheetFDW'
);
create foreign table my_table (
id int default nextval('my_seq'),
foo varchar,
bar int,
baz float
) server multicorn_srv options (
gskey 'zVshdGDuaQKKaQoXqNOwjeTWcxcUtOlSJDZoLeIMUsYx',
keyfile '/path/to/credentials.json',
sheet '0',
row_id 'id'
);
gskey- "ID" of a spreadsheet (the 44 char length part between/spreadsheets/d/and/edit/from spreadsheet URL)keyfile- path to Google Cloud Services credentials json filesheet- index of a sheetrow_id- name of the column which value will be treated as an ID of the whole row
We start with an empty spreadsheet:
Let's insert some data into it:
insert into my_table(foo, bar, baz) values ('a', 1, 0.1);
insert into my_table(foo, bar, baz) values ('b', 2, 0.2);
insert into my_table(foo, bar, baz) values ('c', 3, 0.3);
insert into my_table(baz, bar, foo) values (0.4, 4, 'd') returning *;
Spreadsheet contains our data.
Now let's try retrieve the data:
select * from my_table;
The result:
Of course, we can also perform other SQL operations e.g.:
update my_table set bar = 9, baz = 0.9 where bar = 2;
delete from my_table where bar > 5;
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent