Blog

PgWest: 2010 Call for Papers (2nd call)

Yes, it is the second call. That means some of you haven't submitted after the first call. Of course, I haven't submitted mine either; so it is time for everyone to get on it. West is just around the corner and from all observations this West stands to be the largest PostgreSQL Conference, ever. (O.k. we might not over take Brazil).

Here is the announcement for everyone to review, enjoy …

An update on Replicator

This is my first post on Replicator, I'm going to start by describing the terminology we use, bringing some analogies from other replication systems.

Replicator is an asynchronous master-to-multiple-slaves replication system. It works by propagating binary changes from a single read-write node (called master) to one or more read-only nodes (called slaves) through an intermediary (forwarder) process. The data changes are stored in binary transaction files on a per-transaction basis. …

FOSSExperts, day 2

I expected feedback from the community on FOSSExperts. I did not expect feedback with such immediacy. All the feedback I have received so far is positive. Which is a great feeling. Here are the key points that are coming back.

How do deal with disagreement about the deliverable:

This is an interesting one. I wanted to keep FOSSExperts simple. That is why the deliverable on the ALTER TABLE project …

FOSSExperts, a new way to fund Open Source (Beta)

The cat is out of the proverbial bag. I originally planned to have a quiet roll out with a few close contributors but that has gone by the wayside. Now I am going to be pushing hard for people to test, beat on, object to, argue about, flame upon, scream at, praise and hopefully help us build out something that is truly useful for the FOSS Community. What am I …

A better backup with PostgreSQL using pg_dump

This is generously borrowed from the PostgreSQL Docs, and updated to something that represents a modern approach to PostgreSQL backups. This documentation has always bothered me because it should have been re-written years ago. Yes I plan on submitting a more comprehensive version as a patch but I don't have time to push it into DocBook right now. If someone else wants to grab it, please do. Yes, I really …

Multiple Drupal installations, single login, 10 steps

We have several Drupal sites, no I am not typing this blog on one. We needed a way to have single sign on with these Drupal sites. One of which is PostgreSQL Conference. There are a few modules out there that can do it, some don't work with PostgreSQL, some are usable but not user friendly (HTTP AUTH) and still others use external services such as OAuth. I didn't …

Let the jokes begin! PostgreSQL Conference West has changed locations.

About a week ago I announced PostgreSQL Conference West 2010 CFP. In that CFP I also announced the location. A nice place, the Westin at Union Square in San Francisco. We were excited, the hotel was top knotch.

Then on Monday I received notice, the hotel acquisitions team (EDB) has received an amazing counter offer from a competing hotel.

The hotel is still in San Francisco, it is …

Simpycity now available on Github

Following up on our brand-new Simpycity 0.3.1 release from earlier today, you're now able to get hold of Simpycity via the ever-popular code-sharing platform GitHub. Check us out @ GitHub, and track all the Command Prompt projects!

Announcement: Simpycity 0.3.1 Released

Following up on the blog post covering the new coolness in 0.3, and better docs on working with Simpycity, we've just released Simpycity 0.3.1, our best release yet! Simpycity can be downloaded from our Wiki, and our code is available from the Subversion repository. Finally, starting today, all new releases of Simpycity are available on the PyPI package index, and Simpycity installable via:

$ easy_install Simpycity

Active Object in Simpycity

Simpycity is, as we've previously covered, a small library that permits for the direct mapping of arbitrary SQL statements to Python callables. This power allows for the development of complex representations that do not need to directly map to the underlying database representation. This differs from most conventional ORM technology, which follows the ActiveRecord pattern. Simpycity was implemented in this way for a great many reasons, first and foremost that …

Postgres and Open Source Experts

PgWest: 2010 Call for Papers (2nd call)

An update on Replicator

FOSSExperts, day 2

FOSSExperts, a new way to fund Open Source (Beta)

A better backup with PostgreSQL using pg_dump

Multiple Drupal installations, single login, 10 steps

Let the jokes begin! PostgreSQL Conference West has changed locations.

Simpycity now available on Github

Announcement: Simpycity 0.3.1 Released

Active Object in Simpycity

Recent posts

The Essential

PgManage 1.0 Released

Less is More

Getting Started with pgBackRest: Perform Your First Backup

The Importance of Language

PgManage 1.0rc1 released

Embrace Creative Living