Add support for writeable FDWs

Segfault-Inc / Multicorn

Data Access Library

https://multicorn.org/

PostgreSQL License

700 stars 145 forks source link

Add support for writeable FDWs #40

Closed andreypopp closed 10 years ago

andreypopp commented 10 years ago

It would be cool if Multicorn supports writeable FDWs.

andreypopp commented 10 years ago

Ok, this feature seems to be implemented but not documented.

houmanb commented 10 years ago

Hi, Could you please post an example for the usage of a wirteable FDW? regards

andreypopp commented 10 years ago

@houmanb sure

directory on filesystem — we can write a file into a directory
git's object storage — create blobs
s3 — upload files
bindings to some HTTP API — POST/PUT/DELETE create/modify/delete data
prototype bindings for other databases
...

cristen commented 10 years ago

I didn't get your question at first, you can of course write fdw that will retrieve all the data you need. But I think you are more interested in fdw with DML write operations (insert, update and such…) support which has recently been added to postgresql 9.3. This is a major feature and I'm sure it is or it'll be soon added :).

rdunklau commented 10 years ago

This is available in the git version. Please see the documentation here: http://multicorn.org/implementing-an-fdw/#idwrite-api