Topic on Talk:Quarry

Hello again. I'd like to ask a couple of questions, please.

1. Is there a chance to connect the pilepage as server on quarry query pages? So, if one clicks on "pile" button, the resultset column page_title converts from plain text to hyperlinks to wiki defined in query first line by use statement, in namespace 0 if page_namespace column does not exist, and in proper namespace otherwise? It will be very helpful to have a way to open the result pages on demand.
2. Is there a chance to add an ability to assign temporary tables to variables?
3. I just heared the recursive statement will start working soon. It's amazing. When will it it be?

Thank you very much.

Hi,

1. Could you clarify this, such as by explaining your use case? I don't think I understand the question.
2. Temporary tables by itself as been explicitly declined. If you want to assign the results of a SELECT (multi-row, multi-column; if only a single cell it's much easier) to a temporary table-like name, with upstream higher versions of the database software, that is exactly what WITH statements and CTEs (Common Table Expressions) is designed to do. Unfortunately, that feature is, AFAIK, not in the version of the database we are running on. And when it will be available? I don't know, better to ask a DBA. BTW: I really look forward to this feature. One of my queries would be much simpler if we had this.
3. Recursive statements? Are you referring to the mail thread Recursive Common Table expressions @ Wikimedia? Well, it's still CTE so whatever I said above for CTE also apply to Recursive CTEs

1. Do you know what is the "pile" lab tool?
2. What I really need, is one little thing - an ability to query categorylinks for pages in some category recursively. That's all.
3. Yes, and the most tech person on our wiki sent me a mail with a link to this thread, explaining it will be soon on quarry. So I wanted to know how soon. But maybe it's his mistake, if you don't know about this.

Thank you.

1. No, unfortunately. toollabs:pile is also a 404. Do you have a link?
2. Yeah, that should come in the future, along with Recursive CTEs.
3. I am really not the person to ask about how soon some feature will come. I maintain Quarry itself, not the database replicas in which Quarry queries. DBAs know better about this.

1. .

2., 3. I see, thank you.

What does that pile tool do? Is there an on-wiki documentation or example?

Do not know about the documentation. Here is my explanation:

1. Choose a quarry query that has in resultset a column named page_namespace and a column named page_title.
2. Run it.
3. Give to the pile tool the number of quarry query (not of the special run, the query itself).
4. Give to the pile tool the explicit language+site code for the wiki site that includes these pages, for example enwiki.
5. Run the tool.
6. You'll get an html page with permanent link to access it in the future, that contains the list of pages, taken from the resultset, each one is a hyperlink to the concrete page.

As a result, quarry gives page names as text, pile converts them to convenient hyperlinks.

Ah I see. I would really like some documentation for end-users before Quarry start promoting it. Simply linking to pile will likely confuse users of Quarry. After that, could you file a request on phabricator (and link back to this discussion)? I'll see if I can do it.

I'll try to talk with Magnus. But what do you think, will it be possible technically to add the power into quarry, as I described at the first post? Thank you.

It should be. Technical issues are usually much more simpler than design issues, eg. where to place the button, for me.

Thank's a lot. I'm going to talk with him.

Hello again, User:Zhuyifei1999. It's . Thank you.

I filed phab:T190242 for this.

Thanks a lot!