News for hackers. Stuff that matters.
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)
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