select Command for Ubiquity

Donate to mitcho (Michael Yoshitaka Erlewine) for this plugin via PayPal

by mitcho (Michael 芳貴 Erlewine)


select Command for Ubiquity from mitcho on Vimeo.

The select command for Ubiquity lets you execute SQL select statements from Ubiquity. select features:

Installation

To access your databases, you'll need to upload a helper PHP script on your site and link your select command to it. select requires PHP 4+.

select.php for MySQL 4+
5 kb - PHP
select.php for PostgreSQL
by Jonathan Winandy
5 kb - PHP
  1. Configure the database config in your select.php file.
  2. Put this file on your server. If this is a public server, for security reasons, you might want to rename it to something obscure.
  3. Go to this script on your server. You should get a success message.
  4. Subscribe to the verbs on this page if you haven't already.
  5. Select the URL to the script (including http://...), enter Ubiquity and run setup-select this on the URL.
  6. [optional] If you don't plan on using any other databases (i.e. any other select.php instances), you can go to the Ubiquity command list (command-list) and disable the setup-select command. select should remember your select.php choice across restarts. (Thanks Aza!)

Issues

  1. The preview display of query results often will get clipped. This has to do with the interaction between the command and your Ubiquity theme. Suggestions welcome.
  2. There's no authentication mechanism.
  3. There ought to be a way to set aliases for commonly used databases so you don't need to enter the URL each time.
  4. [your feedback here]
© 2006-2010 mitcho (Michael 芳貴 Erlewine).
The views expressed on these pages are mine alone and do not
reflect those of my employers and clients, past and present.