Page MenuHomePhabricator

Create "Database queries" component under Tool Labs Tools & transfer existing [[jira:DBQ]] requests
Closed, ResolvedPublic

Description

Maybe a bugzilla component?


Version: unspecified
Severity: enhancement

Details

Reference
bz49825

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 2:07 AM
bzimport set Reference to bz49825.

can you elaborate more on that for people who aren't familiar with toolserver in this

From [[tswiki:DBQ]]:

Often, people on Wikimedia projects have a question they can't get an answer to from MediaWiki, but which can be easily answered by asking the database directly. The query service aims to help Wikimedians get the answers they need. It's simple:

  • If you want someone to run a SQL query for you, please file a request on [[jira:DBQ]]
  • If you are a Toolserver user and are willing to run a query every now and then, please look at [[jira:DBQ]] and take whatever task you like.

[[jira:DBQ]] points to https://jira.toolserver.org/browse/DBQ . So do you ask for a section in bugzilla.wikimedia.org under "Wikimedia Labs", similar to the JIRA tracker?

(In reply to comment #3)

[[jira:DBQ]] points to https://jira.toolserver.org/browse/DBQ . So do you ask
for a section in bugzilla.wikimedia.org under "Wikimedia Labs", similar to
the
JIRA tracker?

Maybe or maybe not. Depends on what other people think about.

Would you like to reach out to other people? :)

I think we should just have a 'Database Queries' components under the 'Tool Labs Tools' component.

(In reply to comment #6)

I think we should just have a 'Database Queries' components under the 'Tool
Labs Tools' component.

Hmm, maybe. As far as I remember, "DBQ" was just another Toolserver project. Its equivalent would be tools.wmflabs.org/dbq/ nowadays, I guess (though tools.wmflabs.org/tsreports/ fills a similar role). I'm not sure whether we'll be using Wikimedia Bugzilla (categories) for individual Labs projects, though we've probably already started...

Additionally, we don't want people creating tickets for individual database query requests here, right? For example, "I want to know how many usernames contain 'butt' that were created between 2010 and today on the English Wikipedia". Do you want people to file _those_ type of tickets here? I think having "Database Queries" as a component would naturally lead to that.

No, DBQ was not 'just another project' -- it was a JIRA project /specifically/ for people requesting queries to run on a database.

So yes, it *is* for tickets for individual database query requests. And yes, these *could* include "I want to know how many usernames contain 'butt' that were created between 2010 and today on the English Wikipedia".

More generally usable queries should indeed be moved under tsreports. Luckily, Bugzilla provides us with a feature to move tickets from one project to another ;-)

Component name: Database Queries
Description: Requests for database queries, one time, or lists used by maintenance projects. https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Tools/Query_service
Default CC/assignee: none