Jacob Kaplan-Moss

Activity tagged “databases”

Bookmarks

HTSQL — a database query language for the accidental programmer

OMGWTFBBQ!? This looks incredible.

(database, databases, db, django, http, sql)

Waiting for 8.5 – Hot Standby

A first look at hot standby (a.k.a. read slaves) will work in PostgreSQL 8.5. Mark my words: 8.5 is going to be a watershed moment for PostgreSQL.

(databases, postgresql, postgresql8.5, scaling)

mmalone's django-multidb at master - GitHub

Mike shows off how to implement multiple master/slave replication support in Django right now. Nifty.

(databases, django, djangocon, edc, mutlidb, replication)

Josh Berkus: Finding Useless Indexes

“PostgreSQL 8.3, by improving the Stats system, has made it very easy to find your useless indexes. These are indexes which aren't being used by any regular query, and don't enforce a constraint. Unneeded indexes cost you in several ways: they slow updates, inserts and deletes; they may keep HOT from updating the row in-place, requiring more VACUUMs; they take time to VACUUM; they add to query planning time; they take time to backup and restore. So we want to get rid of them. ”

(databases, performance, postgres, postgresql, sql)

EveryBlock: A news feed for your block.

Whatdayaknow… looks like Everyblock is live. Time to play :)

(databases, everyblock, friends)

Entries

The sorry state of database journalism

I’ve been following with interest as Derek Willis explores Caspio, a sort of hosted data-driven web app tool for journalists. This post started out as a comment on his blog, but soon ballooned.

(caspio, databases, journalism)