Each saved query should reference a specific database

simonw / datasette-saved-queries

Datasette plugin that lets users save and execute queries

12 stars 0 forks source link

Each saved query should reference a specific database #3

Open simonw opened 4 years ago

simonw commented 4 years ago

Right now we assume that saved queries only execute against the database they were saved in.

If the saved_queries table included a database column, a single database could be used to save queries against many other (potentially read-only) databases.

As part of this an optional plugin configuration can be used to specify which database the saved_queries table should live in, as opposed to now where it uses the first attached database.

CharlesNepote commented 2 years ago

I agree. I open my big database in read only mode (-i) so I couldn't have a saved_queries table in it.