Rdbadmin looks much better

A couple of consultants have been working on the look of Rdbadmin lately, and it consequently looks much nicer.

Ryan Foran reworked the appearance to make it more strongly resemble the rest of Rdbhost, with the purple round-cornered title panel, and similar colors otherwise.

Branko Vukelic then reworked the link-buttons, so that they now look like buttons. I recruited Branko to do some other work on the admin program, but you will have to wait to read about that. I will tell you about it when it is pushed to the production server.

So, a big thanks to Ryan and Branko.

See http://www.rdbhost.com/rdbadmin/main.html?r0000000767 , to observe the improved admin look with the stackoverflow database.

Rdbhost module is in SQLObject trunk

The Rdbhost connection module for the Object Relational Mapper (ORM) SQLObject, is now included in the subversion trunk.

Check out (or update) the latest from:
http://svn.colorstudy.com/SQLObject/trunk/

Using your Rdbhost database via SQLOBject is done like this:

from sqlobject import *

role = 's0000000849'
authcode = 'abc123~~~~~~~789xyz'
sqlhub.processConnection = \
connectionForURI('rdbhost://'+role+':'+authcode+'@www.rdbhost.com')

The role and authcode are found on your Rdbhost profile page after you log in.

Presumably, the Rdbhost module will be in the next packaged release. Until then, just check out HEAD from subversion to use SQLObject with Rdbhost.

Facebook

Rdbhost now has a modest presence on Facebook. Created to catch the attention of any database customers who might be searching Facebook for postgresql or sql resources.

May amount to nothing... don't know.

PL/pgSQL on Rdbhost

We have added the server-hosted programming language PL/pgSQL to all Rdbhost accounts.

It is enabled by default for new accounts, and can be enabled on existing accounts via the new Languages page, linked from the profile page.

PL/pgSQL supports variables and conditional execution, so you can write more sophisticated queries than with straight SQL. It is now possible to write sequences of operations to be executed in one request, that formerly required multiple requests, with client side intermediate evaluations between.

One example is illustrated here . Instead of doing an update, determining whether it succeeded, and conditionally doing an insert in a follow-up query, PL/pgSQL code can do the whole sequence on the server, and complete in one request.

http://www.rdbhost.com/plpgsql.html
http://www.postgresql.org/docs/8.2/interactive/plpgsql.html

SO March

The data from the March 2010 data dump from the Stackoverflow website is online, at:

http://www.rdbhost.com/rdbadmin/main.html?r0000000767

The above link is to an online administrative program. We also support access to the data via

a DP API module, at: http://www.rdbhost.com/howpython.html , and the API module supports ORMs, including SQLObject and SQLAlchemy.

Comments are welcome.