3 ms·
Observable supports direct DB connections [0], but these only work in private notebooks at the moment. At Splitgraph [1] we're building a "data delivery networ
by chatmasta 6y ago
Observable supports direct DB connections [0], but these only work in private notebooks at the moment.
At Splitgraph [1] we're building a "data delivery network" (DDN, like a CDN but for databases) that looks like a big Postgres database. It works really well with the Observable Postgres client in private notebooks -- you configure it like you would for any Postgres connection. For public notebooks, you can use our HTTP API for sending SQL queries directly to the DDN. Here's an example [2] using that SQL-over-HTTP API to plot some Covid data.
[0] https://observablehq.com/@observablehq/connecting-to-databases https://observablehq.com/@observablehq/connecting-to-databas...
[1] https://www.splitgraph.com https://www.splitgraph.com
[2] https://observablehq.com/@mildbyte/splitgraph-ddn-oxcovid19-other-dataset-join-and-visualiza https://observablehq.com/@mildbyte/splitgraph-ddn-oxcovid19-...