Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997

Blog

Pg Conference East 09, Registration open

This year is shaping up to be an even larger even than last year with 3 days, four rooms, and multiple tracks. East runs from April 3rd to April 5th at Drexel University. To register please point your Open Source web browser to PgUS. Registration is free for Students and Professors and starts at as low as 40.00 for University staff. Once you have registered make sure to visit and …

Seven things

Theo Schlossnagle recently wrote a blog post called seven things. The idea is, seven things that you "might" want to know about him. Along those lines he listed me as someone he would like to know seven things about. It has taken me a while to get to the post because I have been busy with various things. So here we go, seven things about me.
  • I have crashed …

PostgreSQL Conference: Talk deadline approaching

The deadline (Feb, 23rd) is fast approaching for PostgreSQL Conference East talk submissions. Get your talk in today!

PostgreSQL mininum requirements

In this article we will be discussing the minimum requirements for production usage of PostgreSQL whether on-prem or in the cloud. We will not be discussing proprietary forks such as Amazon RDS or other Open Source forks such as Yugabyte or Greenplum.

PostgreSQL is the Linux of databases. It provides the kernel and key features to the most critical database services available today.

What is that sound ... ... ... that is the sound of JD stomping.

After years of listening to Dave Page, Magnus Hagander, Josh Berkus, David Fetter, Stefan Kaltenbrunner, Ads, Gabrielle, JPA and numerous other contributors that I should mention but won't. I have finally submitted to get a passport. Well at least the application is filed. So let's tell a story about acquiring a passport in the United States. Generally speaking it doesn't seem to bad. I needed my birth certificate and my …

Using Simpycity in Pylons

Project Design Simpycity's core philosophy is that the DBA is going to perform the vast majority of the schema design without the aid of a conventional ORM. This is a marked divergence from most other ORMs and database abstraction layers, and it has an impact on how your project should be designed. The best results with Simpycity will be seen with a strong up-front requirements analysis, thorough schema design, and …

Configuring Pylons on Ubuntu Hardy

I recently configured a complete Pylons + PostgreSQL environment for a customer. The operating system was (of course) Ubuntu Hardy. The system included the use of Simpycity and WSGI. Although I could never done it without the Pylons documentation, I found that it was unnecessary complicated for those who just want to get it done. These are the steps I took:

Install some dependencies: The use of …

2nd call for papers: PostgreSQL Conference East!

PostgreSQL Conference East is being held at historic Drexel University on April 3rd through 5th 2009 . This is the second call for papers. The call for papers ends Feb 23rd and speakers will be notified on the 27th. You may submit your talk here. We are looking for a wide range of topics. Can you speak on any of the below topics? What about a different topic? As long …

PostgreSQL and Replicator at Northwest Python Day

Last Saturday I gave a talk at the Northwest Python Day in Seattle. Unfortunately it was a short talk of only 30 minutes so I didn't get to cover all the topics I wanted but I was able to briefly share on PostgreSQL and on configuring PostgreSQL (Mammoth) Replicator. Just for grins I started the talk off with a question, "Please raise your hand if you are running Ubuntu." There …

Reflecting on the great community discussion

As I diligently prepare for PostgreSQL Conference East 09 by trying to ensure that we have enough talks (hint: talk submission closes Feb 27th). We have a suggested hotel and that everyone knows it is going on (including the Groovy, Python, MySQL, PHP and Ruby communities), I take heart in knowing that our community PostgreSQL can have a well thought out, pointed and productive discussion like no other. I …