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