For Want of a JOIN

Re:For Want of a JOIN by zvrba on Thursday December 22, 2022 @12:28PM (#34095915)

> I don’t want to give other teams direct access to a DB [...]

You don't have to. Package up necessary queries into views and/or stored procedures and grant permissions only on those. Views can also shield from schema changes.

[ Parent | on HN ]

Re:For Want of a JOIN by jonhohle on Thursday December 22, 2022 @01:07PM (#34096392)

That also requires all data to be in the same DB. Often that’s not practical or possible.

[ Parent | on HN ]

Re:For Want of a JOIN by Tostino on Thursday December 22, 2022 @02:03PM (#34097087)

Postgres FDW's do wonders to centralize this type of access.

[ Parent | on HN ]

Re:For Want of a JOIN by zvrba on Friday December 23, 2022 @01:16AM (#34102801)

In SQLServer you can define external tables that access data on another server, or even parses a file.

[ Parent | on HN ]