Custom database clients for use with Observable SQL cells.

Visnu Pitiyanuvath

Observable

Connecting to databases

Mike Bostock

DatabaseClient Specification

Hello, DuckDB

Alex Garcia

Observable Ambassadors

Hello, Datasette

Hello, QuestDB

Hello, HEAVY.AI!

Artjoms Iskovs

Seafowl

Seafowl database client

Hello, Dolt

Robert Harris

Cobus Theunissen

Hello, Trino/Presto

Whether your data is hosted on the web, stored in a database, or saved in a local file, you can access it from Observable with these techniques.

Getting Data In and Out

Resources for working with SQL in Observable

Database Clients

hi @asg017, there's something in this code that is reordering the columns. 

notice that in this table using this client, the case_type column is moved to the end.  https://observablehq.com/d/805cde4744eb38a6#union_membership

in this notebook, with the same query, but the older datasette client, case_type is at the beginning, as it should be:

https://observablehq.com/@fgregg/nlrb-cases#union_membership