issues: 811505638

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
811505638 MDU6SXNzdWU4MTE1MDU2Mzg= 1234 Runtime support for ATTACHing multiple databases 9599 open 0     1 2021-02-18T22:06:47Z 2021-02-22T21:06:28Z   OWNER  

The implementation in #1232 is ready to land. It's the simplest-thing-that-could-possibly-work: you can run datasette one.db two.db three.db --crossdb and then use the /_memory page to run joins across tables from multiple databases.

It only works on the first 10 databases that were passed to the command-line. This means that if you have a Datasette instance with hundreds of attached databases (see Datasette Library) this won't be particularly useful for you.

So... a better, future version of this feature would be one that lets you join across databases on command - maybe by hitting /_memory?attach=db1&attach=db2 to get a special connection.

Originally posted by @simonw in https://github.com/simonw/datasette/issues/283#issuecomment-781665560

 107914493 issue     
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/1234/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    

Links from other tables