Author Archives: aklaver

Postgres and hstore

Posted on June 23, 2012 by aklaver

I recently started working with the hstore contrib module in Postgresql.  My impetus was  the desire to create a generic way of redirecting deletes on key tables to archive tables.  I do that now using a rule based mechanism. The … Continue reading →

Posted in Postgres | 8 Comments

Thinking

Posted on May 28, 2012 by aklaver

When presented with a problem I tend to see the solution as a snapshot encompassing the depth and breadth of whatever is presented. What is usually wanted is an answer that is some subset of that snapshot. Naked bear just … Continue reading →

Posted in Uncategorized | Comments Off

Social Networking

Posted on May 20, 2012 by aklaver

A very brief look at social networking now and then and what it means. Recently I gave a short presentation on the Python package Brewery. At the conclusion of said talk I was so bold as to mention I was … Continue reading →

Posted in Uncategorized | Comments Off

Making things easier

Posted on November 26, 2011 by aklaver

Have not trolled the source enough to know who specifically to thank, so a general thank you to whoever is responsible for \e(f) in psql and the command DO. I have been working on a fairly complex plpythonu function in … Continue reading →

Posted in Postgres | 1 Comment

PostgreSQL 9.1, first beta around the corner

Posted on April 24, 2011 by aklaver

Joshua Berkus recently gave a heads up on the Advocacy list of the forthcoming release of the first beta for PostgreSQL 9.1, tentatively scheduled for May 3.  I have been following the development fairly closely, though given the number of … Continue reading →

Posted in Postgres | Comments Off

Troubleshooting

Posted on April 2, 2011 by aklaver

Some thoughts on the art and science of troubleshooting, or how not to resort to the bigger hammer. What I offer up is based on my experience trying to solve problems across an array of disciplines, from truck repair to … Continue reading →

Posted in Life lessons, Postgres | Comments Off

SQL inside Jedit

Posted on January 20, 2011 by aklaver

I use Jedit as my primary text editing tool. I recently ran across a plugin (SQL) to the editor that allows for running SQL from within an editor  buffer. What follows is an explanation of how to set it up … Continue reading →

Posted in Postgres | Comments Off

PostgreSQL Roles

Posted on December 20, 2010 by aklaver

Today I got involved in a discussion on the General mailing list about using ROLE in Postgres.  I realized this is a topic that can get confusing in a hurry and I thought I might try to clear things up, … Continue reading →

Posted in Postgres | 1 Comment

Quantas gripe sheet

Posted on August 21, 2010 by aklaver

Ran across this years back, it still gives me a chuckle: After every flight, Qantas pilots fill out a form, called a “gripe sheet,” which tells mechanics about the problems with the aircraft. The mechanics correct the problems, document their … Continue reading →

Posted in Uncategorized | Comments Off

First Postgres post

Posted on June 23, 2010 by aklaver

This is more of a test post than anything. A way of checking that I have my feed to Planet PostgreSQL set up right. The point being to have only Postgres related posts come through, not my thoughts on cat … Continue reading →

Posted in Postgres | Comments Off