Simon Willison’s Weblog

PostgreSQL 8.3 beta 4 release notes. In addition to the huge speed improvements, 8.3 adds support for XML, UUID and ENUM data types and brings full text (tsearch2) in to the core database engine.

# 12th December 2007, 12:43 am / beta, databases, enum, full-text-search, postgresql, tsearch2, uuid, xml

PostgreSQL 8.3 vs. 8.2—a simple benchmark. Stefan Kaltenbrunner reports a 2.2x speed increase for PostgreSQL 8.3 compared to 8.2 for a relatively simple benchmark.

# 12th December 2007, 12:42 am / benchmarks, postgresql, stefankaltenbrunner

ThingDB. Another extensible key/value pair data store, constructed for the Open Library based on Aaron Swartz’s Infogami technology.

# 17th July 2007, 10:21 am / aaron-swartz, infogami, openlibrary, postgresql, python, thingdb

PostgreSQL for Mac (via) Looks like a great way of getting PostgreSQL up and running on a Mac.

# 10th July 2007, 8:24 am / mac, osx, postgresql

Rails and Scaling with Multiple Databases. Ryan Tomayko explains how his team spreads a high traffic Rails application across five separate PostgreSQL databases by giving each client their own schema—similar to how WordPress MU scales.

# 14th April 2007, 2:32 am / postgresql, rails, ryan-tomayko, scaling, wordpress

pg8000 v1.02. The pure Python PostgreSQL library now supports DB-API 2.0 (and SSL too). That didn’t take long!

# 13th March 2007, 9:18 pm / dbapi, pg8000, postgresql, python

pg8000 (via) A pure-Python interface to PostgreSQL, using the PostgreSQL network protocol directly. Doesn’t (yet) support DB-API 2.0, but that’s promised in a future release.

# 9th March 2007, 7:35 pm / pg8000, postgresql, python