3 ms·
Could you describe for what use case are you using foreign data wrapper in production?
by hyzyla 5y ago
Could you describe for what use case are you using foreign data wrapper in production?
- shawn-butler 5y agoI used a foreign data wrapper to query elasticsearch indexes from within postgres.[0] It pushed alot of complexity down away from higher-level app developers not familiar with ES patterns. [0]: https://github.com/matthewfranglen/postgres-elasticsearch-fdw https://github.com/matthewfranglen/postgres-elasticsearch-fd...
- adgjlsfhk1 5y agoone place they are great in production is as part of a data migration. if you have an old database system with application code on top that you want to move to pure postgres, fdws provide a way to incrementally rewrite the application logic without ever having to do a hard cutover.