postgresql when it's not your job

9 March 2011

23:25

Concern Troll is Concerned: Verifone vs Square

Suppose a major manufacturer of computer keyboards announced a very serious security problem with a specific competitor’s keyboard: Someone could plug this keyboard into a computer running a malicious app, and cause a user to enter sensitive information. Thus, the manufacturer demands that their competitor recall all of these “insecure” keyboards.

Anyone with the technical sense of a rock would pause for a moment, and then burst out in laughter at the utter absurdity of this proclamation. No one would ever attempt to make such a ludicrous and obviously self-serving claim, would they?

Verifone would. Verifone is very very concerned about Square’s iPhone card scanner, because someone could run a malicious app on the iPhone and collect card data using it. The fact that Square just announced new pricing undercutting Verifone’s is, of course, completely coincidental.

Where to begin?

In short, Verifone is bashing a competitor because the competitor’s pricing is more consumer-friendly than Verifone’s. Their technical arguments are nonsense, and they should be ashamed of launching a FUD campaign that plays on credit card security paranoia.

23:03

Django and PostgreSQL at PostgreSQL Conference East

I’ll be giving a full day tutorial about developing Django applications using PostgreSQL. If you are just getting started with Django, this is a great introduction; it is intended for developers who are just getting into serious Django/PG development.

It’ll cover general development in Django, with a lot of PostgreSQL-specific details.

And, of course, the whole conference will be a fount of great PostgreSQL geekery.

8 March 2011

18:52

“Anatomy of a Crushing”

A fun and interesting article about a sudden burst in traffic at Pinboard when Yahoo! announced they were shutting down Delicious. Relevant to app and DB designers everywhere.

25 February 2011

17:17

“10 Ways to Kill Performance”

The slides from my talk, “10 Easy Ways to Destroy Performance” from PgDay at SCALE 9X are available.

15 February 2011

22:22

“10 Easy Ways to Destroy Performance” at pgDay at SCALE-9X

I’ll be presenting a talk on “10 Easy Ways to Destroy Performance” at pgDay at SCALE-9X, on February 25th in Los Angeles.

22:19

“Django Development with PostgreSQL” at PostgreSQL Conference East

I’ll be presenting a full-day tutorial on Django Development with PostgreSQL at PostgreSQL Conference East, March 22-25 in New York!

4 February 2011

01:59

PostgreSQL for Servoy Developers

The slides from my presentation on PostgreSQL for Servoy Developers, presented at ServoyWorld 2011, are available here.

31 December 2010

13:50

Nobody Here But Us Chickens: Google and Lies We Tell Ourselves

tl;dr: If you make a tradeoff, be honest about it. Don’t lie to yourself that you are making a positive architectural decision when you make a negative tradeoff.

Read the rest of this entry »

22 December 2010

15:54

Extra columns when doing .distinct() in a Django QuerySet

tl;dr: If you are doing a .distinct() query and limiting the results using .values() or .values_list(), you may be in for a surprise if your model has a default ordering using the Meta value ordering. You probably want to clear the ordering using .order_by() with no parameters.

Read the rest of this entry »

00:00

Getting the ID of Related Objects in Django

tl;dr: Don’t retrieve a whole row just to get the primary key you had anyway. Don’t iterate in the app; let the database server do the iteration for you.

Read the rest of this entry »

« Older Entries

Newer Entries »