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 <[EMAIL PROTECTED]> wrote:
>
> We already do that, we call it the toolserver.
>
> On 10/26/07, James Hare <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
> > > [email protected]
> > > http://lists.wikimedia.org/mailman/listinfo/toolserver-l
> > >
> >
> >
> > _______________________________________________
> > Toolserver-l mailing list
> > [email protected]
> > http://lists.wikimedia.org/mailman/listinfo/toolserver-l
> >
> >
>
>
> --
> ST47
> Administrator, en.wikipedia
> _______________________________________________
> Toolserver-l mailing list
> [email protected]
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
>
>
_______________________________________________
Toolserver-l mailing list
[email protected]
http://lists.wikimedia.org/mailman/listinfo/toolserver-l
