So let's see... my idea is a duplicate of the toolserver, and we want a public query service, but it would prove too tempting for people to use it for a denial of service attack, not to mention the fact that it would bog down the server.
Does this *have* to be on the toolserver, or can we take the databases and put it on its own server dedicated for querying? Maybe we could have a sexy *multi-server* layout featuring a distributed computing scheme.
On 10/26/07, Dan Collins en.wp.st47@gmail.com wrote:
We already do that, we call it the toolserver.
On 10/26/07, James Hare messedrocker@gmail.com wrote:
Or what if we only made the tool available only to those who know what they're doing? This way, we'll know that said people can go easy on the servers and if they screw up, they lose access.
On 10/26/07, Edward Chernenko edwardspec@gmail.com wrote:
Just a point about implementation. As was already written, it's impossible to allow users to execute their own selects, but we need to implement new queries by their requests quick, without writing tonns of same code each time.
What we can do: create some kind of repository which can be modified by any of those who have accounts on Toolserver. It would contain list of queries with placeholders ("?") for parameters. For example, query_id | query_text 1 SELECT user_id FROM user_ids WHERE user_name=? 2 SELECT page_namespace FROM page WHERE page_title=? ORDER BY page_namespace (this list may be written into mysql table).
User can inflict query by accessing some script common for all queries, which would find query by it's number (query_id) and print HTML form on GET (with textfields instead of placeholders) or results on POST.
All toolserver programmers should be able add/modify/delete any query in another form and receive query_id to be sent to users. All modifications must be written to special log and it should be possible to revert'em, of course. Single login with other ts sites (like MediaWiki) for this script would be appreciated.
-- Ed
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
-- ST47 Administrator, en.wikipedia _______________________________________________ Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l