The default installation of PostgreSQL listens on 127.0.0.1 (the local loopback address) and on Unix sockets. The controlling parameter, listen_addresses, isn’t documented to have a setting that just listens on sockets, and not the loopback address.

As it happens, such a setting exists:

1
listen_addresses=''

Among other things, this appears to prevent local instances of

When I learned SQL, I was taught that the way to do a join was with a WHERE clause. For example, if you have orders:

1
CREATE TABLE orders (
2
   order_id bigserial PRIMARY KEY,
3
   customer_id bigint REFERENCES customers(customer_id),
4
   ...
5
)

and order lines:

1
CREATE TABLE order_lines 

The video for the September 8, 2009 SFPUG meeting is now available:

For downloading, the direct link is here.

This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.

“The locking on this application is not so much pessimistic as clinically depressed.” – me

“Hovercraft are just as happy hovering over the surface of land as of water. The authorities forbid their use on roads. And when you appreciate that they have no brakes, tend to slither off the camber down into the gutter and are deflected sideways by the slightest breeze, you can see that the authorities have made a wise move

The video for the August 11, 2009 SFPUG meeting is now available:

For downloading, the direct link is here.

This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.

“The question of whether a machine can think is no more interesting than the question of whether or not a submarine can swim.” – Edsger Dijkstra

The trailer for the sequel to Tron looks awesome.

And this gives me an opportunity to vent one of my pet peeves about the original Tron.

In Tron, you have (in essence) a battle between three programmers: Flynn (hero), Bradley (hero), and Dillinger (villain). Now, what actual programs have these three delivered, per the movie?

In a thoughtful post at the Big Nerd Ranch blog, Joe Conway talks about the relatively new dot notation in Objective-C for invoking messages on objects.

The executive summary is, he doesn’t like it.

He’s making two arguments against dot notation:

1. While it is now legal Objective-C, it’s an uneasy fit to an enormous history

I have multiple reactions when I read that extremely talented Macintosh developers are boycotting the iPhone App Store.

First, I agree completely with the essential issues. The rejection and approval process is not one that inspires the least bit of confidence, especially for those developers who might write exactly the kind of high-investment, sophisticated application that is