Re:Use one big server
by riquito on Tuesday August 02, 2022 @03:55PM
(#32323490)
Not suggesting it, but for the sake of knowledge you can join tables living in different databases, as long as they are on the same server (e.g. mysql, postgresql, SQL server supports it - doesn't necessarily come for free)
[ Parent
| on HN ]
Re:Use one big server
by yellowapple on Tuesday August 02, 2022 @04:26PM
(#32323855)
In PostgreSQL's case, it doesn't even need to be the same server: https://www.postgresql.org/docs/current/postgres-fdw.html