Querylet - Perl, simplified for lab coats and lazy coders

Posted on Mon Feb 7 21:35:47 2005 by rjbs
Perl, simplified for lab coats and lazy coders

I'd say it was simplified for suits, but I wouldn't be fooling anyone.

I wrote Querylet to try to make life easier on myself by making life easier on the scientists at work. They wrote a lot of queries in Excel and kept wanting to change them in ways that were difficult in SQL or in MS Query. You can read about its birth on use.perl.

I've found Querylet really useful for my own purposes, especially because I can very, very easily write "run this query, asking for these parameters, and out put it this way" in just a few lines. Writing new output methods has been a silly little source of fun; this week, I wrote a write handler that takes the output and encrypts it, then sends it to a remote server. The user doesn't need to see anything weird other than "output method: secure_network"

My next task will probably be to revisit the automatic CGI bits and make them more abstract and more useful. Right now, you can add "input method: auto" and it will act normally, unless it sees that it's running under a CGI environment. If it is, it will output web forms and process CGI parameters as input. I'd like to make that play nicely with things like my secure_network output, so I can just write these ten-liners and run them anywhere and get useful results.

I'd love to know if anybody else finds this useful.

Write a response