Feature: server execution via quack · Issue #677 · sqlrooms/sqlrooms · GitHub
Skip to content

Feature: server execution via quack #677

Description

@NickCrews

Do you have any thoughts on, instead of performing execution locally in duckdb wasm, instead pushing that execution to a remote duckdb server using the new quack protocol?

I want to:

  • access a postgres db. the duckdb postgres extension requires raw tcp/ip, not http, so it can't run in either duckdb-wasm nor in motherduck.
  • access to other datasources such as airtable. I could use the shellfs extension for this, but again it requires a real unix machine, wasm/motherduck doesn't work here.

So I'm thinking the way to do this is with a real duckdb server running in an eg sprite.dev instance. that acts as a quack server, and then the sqlrooms client connects to that. IIUC the actual SQL should be nearly the exact same in both cases, sqlrooms would just have to specify to execute the command in the remote DB instead of locally.

Just curious if you have thought of this, if this is any sort of priority for you. It seems like you are trying to be very local-first, so understandable if you just say "no" :).

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions