4 ms·
Can other Database systems be used to do this like SQL Server or Oracle? Many of us are forced to use systems other than PostGres.
by Vaslo 6y ago
Can other Database systems be used to do this like SQL Server or Oracle? Many of us are forced to use systems other than PostGres.
- chatmasta 6y agoI'm not sure if you're asking about (a) querying Oracle from a Postgres client through Splitgraph, or (b) querying Splitgraph from Oracle. We want to support both these use cases. For (a), Oracle would be an "upstream" to Splitgraph. We'll need to write a plugin that implements the FDW and does introspection. Eventually, we want you to be able to configure upstreams from the Web UI. For (b), you can probably find a way to query Splitgraph from Oracle, e.g. using Oracle's "gateway" feature [0]. What's nice about Splitgraph is that it's compatible with any SQL client that can speak the Postgres protocol (or ODBC). So if Oracle can connect to a Postgres database, it can connect to Splitgraph. We have instructions for how to query Splitgraph from within ClickHouse at [1]. We're actually giving a presentation about this to a ClickHouse meetup on Sep 10, feel free to join. [2] [0] https://docs.oracle.com/cd/E18283_01/owb.112/e10582/gateways_connection.htm https://docs.oracle.com/cd/E18283_01/owb.112/e10582/gateways... [1] https://www.splitgraph.com/connect https://www.splitgraph.com/connect [2] https://www.meetup.com/San-Francisco-Bay-Area-ClickHouse-Meetup/events/272508526/ https://www.meetup.com/San-Francisco-Bay-Area-ClickHouse-Mee...
- hodgesrm 6y agoSF ClickHouse meetup organizer here. Thanks for the shout-out for the SF ClickHouse Meetup. We're looking forward to hearing about SplitGraph on September 10th.