Add support for writeable FDWs

[andreypopp]

It would be cool if Multicorn supports writeable FDWs.

[andreypopp]

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

[houmanb]

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

[andreypopp]

@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]

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]

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