David Fetter's blog

PostgreSQL Weekly News vs. Casa Donde

nospam@example.com (David Fetter) — Sun, 07 Feb 2010 11:32:04 +0200

This week's PostgreSQL Weekly news may be rescheduled to Wednesday February 10, evening PST.

Thanks very much to whatever component failed at my home for this.

FOSDEM Starting

nospam@example.com (David Fetter) — Fri, 05 Feb 2010 09:10:07 +0200

The herd of blue elephants is gathering for FOSDEM, including several talks in the main track.

I'd like to thank the FOSDEM for making it possible for me to attend this year.

More on this soon...

Adding Only New Rows (INSERT IGNORE, Done Right)

nospam@example.com (David Fetter) — Mon, 01 Feb 2010 05:04:08 +0200

Let's say you have a table and a data set, and would like to add only those rows in your data set that aren't already in the table. There are hard ways, but here's an easy one.
Continue reading "Adding Only New Rows (INSERT IGNORE, Done Right)"

ORDER BY column_header

nospam@example.com (David Fetter) — Sat, 30 Jan 2010 21:02:38 +0200

Ever wondered why you can't "just sort" by column when you're looking at an HTML table?
Continue reading "ORDER BY column_header"

PL/Parrot Needs a Logo

nospam@example.com (David Fetter) — Wed, 27 Jan 2010 00:51:51 +0200

The PL/Parrot Project, long dormant, is shaking off its sleep.

The virtual machine for dynamic languages meets the dynamicest of RDBMSs. Good things are coming soon!
Continue reading "PL/Parrot Needs a Logo"

Clearing "Commercial" Confusion

nospam@example.com (David Fetter) — Tue, 05 Jan 2010 18:45:07 +0200

According to Webster's first set of definitions, "commercial" means:

occupied with or engaged in commerce or work intended for commerce
of or relating to commerce
characteristic of commerce
suitable, adequate, or prepared for commerce

What's not in that definition?

Continue reading "Clearing "Commercial" Confusion"

The M word

nospam@example.com (David Fetter) — Tue, 05 Jan 2010 07:25:11 +0200

No, it's not the sequel to that wildly popular television show.

It's not some former Swedish company either. It's
Continue reading "The M word"

Trip Detector

nospam@example.com (David Fetter) — Sat, 19 Dec 2009 00:20:12 +0200

Yes, it's an amazing technology. The DSL modem, or some other vital
network component, at my house tends to malfunction some short time
after I leave on any given trip, taking my personal email down with it.

The likeliest result, this time, is that the PostgreSQL Weekly News
will be late this week. I would like to apologize in advance to
readers for the delay.

Pre-OSDC

nospam@example.com (David Fetter) — Tue, 24 Nov 2009 16:07:09 +0200

Thanks to the Brisbane PHP/MySQL User Group for a lovely evening.

First, we...
Continue reading "Pre-OSDC"

PostgreSQL Conference Japan...and onward

nospam@example.com (David Fetter) — Tue, 24 Nov 2009 16:03:35 +0200

Finally, the people doing all kinds of clustering in PostgreSQL have met and sketched out the issues.
Expect great things to come from this...

And that was before the official conference even got started.

Thanks to all the people who made the JPUG 10th Anniversary great!
Continue reading "PostgreSQL Conference Japan...and onward"

Removing (Much of) the Suck from ORMs

nospam@example.com (David Fetter) — Mon, 16 Nov 2009 16:54:39 +0200

It really isn't terribly complicated, but the reasoning is a bit subtle.
Continue reading "Removing (Much of) the Suck from ORMs"

PGEU Day 2

nospam@example.com (David Fetter) — Sun, 08 Nov 2009 09:32:27 +0200

It's a wrap!
Continue reading "PGEU Day 2"

PGEU Day 1

nospam@example.com (David Fetter) — Sat, 07 Nov 2009 07:57:58 +0200

Early one mornin', I was makin' the rounds...
Continue reading "PGEU Day 1"

PGEU Day 0

nospam@example.com (David Fetter) — Sat, 07 Nov 2009 07:49:41 +0200

Put a batch of database geeks on an I/O problem, and you get some very strange-looking solutions along the way.
Continue reading "PGEU Day 0"

Why ORMs Suck

nospam@example.com (David Fetter) — Fri, 06 Nov 2009 07:42:41 +0200

(and how to fix them)
Continue reading "Why ORMs Suck"