Page MenuHomePhabricator

Support queries against Quarry's own database and ToolsDB
Open, Needs TriagePublic

Description

Add a way to specify the database server to attach to so that queries can be written against:

  • The tool owned databases in ToolsDB
  • The "local" database that is used to track Quarry's saved queries

This way you can for example find scripts that query specific tables with LIKE "%tablename%"

Event Timeline

Framawiki renamed this task from Query Quarry's own database to Query Quarry's own database and tools one.Jun 8 2018, 5:30 PM
bd808 renamed this task from Query Quarry's own database and tools one to Support queries against Quarry's own database and ToolsDB.Aug 2 2018, 11:02 PM
bd808 updated the task description. (Show Details)
Bstorm added a subscriber: Bstorm.

This would be trivial to add to the work on the parent task I just added. Therefore, adding it.

I dug around a little bit and realized it isn't as simple as what I stated above. The reason is that those are read-write databases, which dramatically changes the scope of what Quarry could do. In order to provide such services, this would require a read-only permission to most tables on ToolsDB. It would also require a review of and possible view layer/read-only role for the Quarry database.

This cannot be fitted into the scope of the replica changes. It also may be surprising for developers if their ToolsDB information became dramatically more public than it currently is, but that's more of a topic for discussion.