The Build

3 June 2010


Introduction to PostgreSQL: Open Source Bridge 2010 Presentation

The slides from my talk, Introduction to PostgreSQL are available here.

6 May 2010


SFPUG: Hot Standby and Streaming Replication

The archive video for the February 9, 2010 SFPUG meeting is now available: Read the rest of this entry »

28 February 2010


On switching away from Core Data

Brent Simmons has a very good piece about switching away from using Core Data to using SQLite directly in his iPhone app. Substituting “any common ORM” for “Core Data” (which, after all, is all Core Data is) and “any SQL database” for SQLite, he encounters the most common problems that plague those trying to develop scalable solutions on top of ORMs.

23 December 2009


SFPUG: Operator Exclusion Constraints

The archive video for the December 8, 2009 SFPUG meeting is now available: Read the rest of this entry »

22 December 2009


SFPUG: Continuent Tungsten with PostgreSQL

The archive video for the November 10, 2009 SFPUG meeting is now available: Read the rest of this entry »

7 November 2009


Django, PostgreSQL, and Autocommit

In part 1, we ran down a list of the standard Django features for controlling transactions. Now, we’re going to look at some ways to optimize how these tranactions happen.

Read the rest of this entry »


Django, PostgreSQL, and Transaction Management

Django has quite a bit of code in it devoted to transaction management. Although the documentation goes into quite a bit of depth on transactions, I’ve never felt that the docs by themselves let you build a good mental model of how transactions actually work. So, I decided to approach it experimentally: Build a small Django app, and see how the various options actually work.

Read the rest of this entry »

4 November 2009


ORMs and Their Discontents

I love object-oriented programming. The first time I ever encountered an OO language or framework (Object Pascal and MacApp, thank you for asking), it was as if the heavens opened. It simply made sense to me as a way of structuring programs, and I’ve been wedded to it ever since. (As it turns out, if you do the right paperwork, you can marry a concept.)

So, I think object-oriented programming is the bee’s knees. And, in this post, I’m going to tell you to not use it.

Read the rest of this entry »


Git vs Mercurial

No, I’m not going to write another Git vs Mercurial post that really digs into them, because… well, if you are using one or the other, it is probably for reasons that don’t have much to do with your preferences.

In strictly my opinion, for personal use, I like Mercurial. For projects that use Git, I use Git.

My two sentence summary is: Mercurial is your smart friend who likes to explain things to you. Git is your genius coworker who sighs and rolls his eyes every time you ask him a question.

19 October 2009


WordPress to Django+PostgreSQL, Part 4: Configuring Apache, Django, PostgreSQL

In the previous installment of this series (in which we’re migrating this blog from WordPress to Django and PostgreSQL), we installed Apache, Python 2.6, psycopg and mod_wsgi on the server. Read the rest of this entry »

« Older Entries

Newer Entries »