crossdb - can you publish mutiple .db files?

[justinkelly]

Hi Datasette crew

Is it possible to publish to a cloud host (like fly.io etc..) multiple .db files and use the cross database queries[1] feature to query across all of them?

1: https://simonwillison.net/2021/Feb/21/cross-database-queries/

Thanks for the amazing project

Cheers

Justin

[simonw]

Hi Justin,

That should be supported by both datasette publish cloudrun, datasette publish heroku and datasette publish fly (via the plugin) at the moment, using the --extra-options option:

datasette publish cloudrun one.db two.db --service my-service --extra-options "--crossdb"

I can't recall if I've tested it against Fly but I've used it a bunch with Cloud Run and Heroku.

[justinkelly]

awesome - thats great news!!!! thanks so much for the crazy fast answer and the awesome project!!!

[huntiezz]

Cool