Connecting to multiple PostgreSQL databases in SQLPage without using FDW

[anusou]

Hi,

I’m using SQLPage with PostgreSQL, and I need to query data from multiple PostgreSQL databases on the same page. I understand that one approach is to use postgres_fdw, but I’m looking for alternatives that do not rely on FDW.

Specifically:

Can SQLPage handle multiple PostgreSQL database connections natively?

Is it possible to configure multiple database_urls in sqlpage.json or some other method?

How can I write queries in SQLPage that pull data from different databases without using FDW?

Any examples, configuration snippets, or guidance would be greatly appreciated.

Thanks in advance!

[lovasoa]

Hi !

sqlpage itself currently runs all your sql on the one single database you specify in its configuration file. #66 discusses adding support for multiple database connections. If you'd be interested in funding this feature, let me know !

Currently, the recommended way is to achieve that is to use postgres FDW, or an equivalent in another database that supports connecting to postgres, such as duckdb, dremio, presto, or trino.