4 ms·
Didn't know about that, thanks! Is there a way to connect this to other databases, to basically have views of your redis/MySQL/other databases in postgres?
by cube2222 7y ago
Didn't know about that, thanks!
Is there a way to connect this to other databases, to basically have views of your redis/MySQL/other databases in postgres?
- truth_seeker 7y agoYes sir, that too is supported. https://www.postgresql.org/docs/11/contrib-dblink-function.html https://www.postgresql.org/docs/11/contrib-dblink-function.h...
- cube2222 7y agoSeems like it's solving part of the problems we're having really well, I'll have to read up more on it, thanks!
- truth_seeker 7y agoSure. You might also wanna check this: PG community extensions - https://pgxn.org/ https://pgxn.org/ There are a lot of open-source or free extensions to make PG as a data platform rather than just a RDBMS.
- jon-wood 7y agoPostgres Foreign Data Wrappers are an incredibly powerful tool. I've in the past built a basic data warehouse for a distributed system by pulling in read slaves from assorted service's databases as FDW sources to a central Postgres instance, after which Postgres allows you to treat them all as one big database.