Обсуждение: Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?

Поиск
Список
Период
Сортировка

Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?

От
Stefan Keller
Дата:
Hi,

I'm interested in using Foreign Data Wrappers (FDW) in order to
connect PG to CSV files, MongoDB, MS SQL Server and the Web.
Was anyone able to compile and use FDWs [1], like mysql_fdw, odbc_fdw
or www_fdw, in PG 9.1.1 (besides official file_fdw) under Ubuntu but
also Windows?
Does anyone have experience, especially with odbc_fdw (e.g. performance) ?

Yours, Stefan

[1] http://wiki.postgresql.org/wiki/Foreign_data_wrappers

Re: Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?

От
Ronan Dunklau
Дата:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello.

We use (and develop) the multicorn foreign data wrapper
(http://multicorn.org).
It is very experimental, but works well for our needs.

We use it to perform IMAP searches in our in-house CRM solution, as
well as to list files on a file system.

We never tested it under Windows so try it at your own risks :)


- --
Ronan Dunklau
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.18 (GNU/Linux)

iQEcBAEBAgAGBQJO1MrHAAoJECTYLCgFy323X6IH/Avo7KERwWORjl543QvFnwHs
nueyj7m/LUjjBbl/WjtrrRFRFnC1Y2iO4gvJRqVe119KRJBvyxiLqF0mr40U0lWg
EGErRf4648xoRL/gCvYHJmovs/ukarBk202v4TJPb9XThZgjlc4oSKa9qNUOj2OF
xONIO/SnnZ2Cql/MWcEQuuSjZ/ET+6tBNawCA474h19KX+i09OTcAvNLC9pmVhOt
t5j8U1bDDKS+JJ5SghSlR5Za5RE9XkA/j2VSLULtz4dV0RF3s+P0NFDYJfxVfVCw
arzAfIbT44hjBF9esIJXiI5jhteQ83C+zezCUixes2G6NrzFJu4fFaeR7H77cOo=
=iopq
-----END PGP SIGNATURE-----