· 2 min · PostgreSQL

Small PostgreSQL Installations and 9.0 Replication

PostgreSQL 9.0's streaming replication will be a game-changer for small businesses managing critical data—finally making high availability something a casual…

2 comments

· 2 min · PostgreSQL

Users Want Functionality, Not Features

Users claim they don't need replication—until they lose a day's data.

7 comments

· 1 min · PostgreSQL

Things I Do Not Understand: “Web-Scale.”

What does "web scale" actually mean? Let's move past the marketing speak and pin down some numbers for what constitutes truly high-volume database performance.

5 comments

· 3 min · Django

Django and PostgreSQL “Idle In Transaction” Connections

Django connections pile up in "Idle in Transaction" state because it skips COMMIT for read-only queries. Here's why it happens and how to fix it.

10 comments

· 1 min · Mac OS X

Python build problems on X OS 10.6 Snow Leopard?

I need more information about the post to write an accurate teaser.

0 comments

· 1 min · Django

ORMs and Their Discontents: PGXPUG Day OSCON 2010 Presentation

ORMs promise to hide SQL's complexity—but often hide its power instead. See why raw queries sometimes win.

8 comments

· 1 min · PostgreSQL

Introduction to PostgreSQL: Open Source Bridge 2010 Presentation

Slides from an introduction to PostgreSQL talk are now online.

0 comments

· 1 min · PostgreSQL

SFPUG: Hot Standby and Streaming Replication

Watch the archived video from the February 9, 2010 San Francisco PostgreSQL User Group meeting.

0 comments

· 1 min · IOS

On switching away from Core Data

Brent Simmons ditched Core Data for raw SQLite on iPhone. His experience reveals why ORMs often become bottlenecks in scalable applications.

8 comments

· 1 min · PostgreSQL

SFPUG: Operator Exclusion Constraints

Watch the San Francisco PostgreSQL User Group's December 2009 meeting on exclusion constraints and advanced PostgreSQL techniques.

1 comment