David Wheeler

Portland, Oregon

Perl, PostgreSQL, iOS hacker; US politics junkie; Webapp developer; Portvangelist; profane iconoclast.

Areas of Expertise:

Perl
PostgreSQL
iPhone
iPad
iOS
JavaScript
plpgsql

plperl
sql
consulting
speaking
programming
training
writing

Biography
Videos
Blog
Articles

David E. Wheeler is President of Portland-based Kineticode, Co-Founder of PostgreSQL Experts, and Co-Founder of Lunar/Theory, purveyors of fine iOS apps. David also maintainers and leads development of Bricolage, a content management and publishing system powered by Perl and PostgreSQL. For his next trick, he may or may not build a Python or Lisp or BASIC-powered Web application, but whatever it is, it will likely be built on PostgreSQL. Unless it’s a blog or iOS app, in which case he’ll just use SQLite.

Test-Driven Database Development
by David Wheeler
August 2010
Video: $99.99

David blogs at:
http://www.justatheory.com/
http://blog.pgxn.org/

Sqitch Update: All Your Rebase Are…Never Mind

December 04 2012

I’m pleased to announce the release of Sqitch v0.940. The focus of this release? Sanity.Read More � read more

New in PostgreSQL 9.2: format()

November 16 2012

There’s a new feature in PostgreSQL 9.2 that I don’t recall seeing blogged about elsewhere: the format() function. From the docs:Read More � read more

Thinking about Changing Sqitch Change IDs

November 14 2012

When Sqitch, (the database change management app I’ve been working on for the last several months) parses a deployment plan, it creates a unique ID for each change in the plan. This ID is a SHA1 hash generated from information about the change, which is a string that looks something… read more

Mocking Serialization Failures

November 02 2012

I’ve been hacking on the forthcoming Bucardo 5 code base the last couple weeks, as we’re going to start using it pretty extensively at work, and it needed a little love to get it closer to release. The biggest issue I fixed was the handling of serialization failures.Read More � read more

Localize Your Perl modules with Locale::TextDomain and Dist::Zilla

October 01 2012

I've just released Dist::Zilla::LocaleTextDomain v0.80 to the CPAN. This module adds support for managing Locale::TextDomain-based localization and internationalization in your CPAN libraries. I wanted to make it as simple as possible for CPAN developers to do localization and to support translators in their projects, and Dist::Zilla seemed like the perfect… read more

Sqitch Symbolism

September 25 2012

It has been a while since I last blogged about Sqitch. The silence is in part due to the fact that I’ve moved from full-time Sqitch development to actually putting it to use building databases at work. This is exciting, because it needs the real-world experience to grow up.Read More… read more

Medium in the Large

September 13 2012

I’ve been reading novels the last few months, taking advantage of our time in Europe to just veg out on epic fantasy when not working or doing family stuff. A such, I had less time to clear out my Instapaper queue or to read The New Yorker. But now I’ve… read more

You need to enable JavaScript to view more than 15 articles by this author.

Batch Updates with PL/pgSQL
Publish Date: Sep. 7, 2006Loops are slow, algorithmically speaking. Every time you find yourself looping over data, you have a process that, at best, scales linearly with the number of items to process. SQL gives you options to perform multiple updates at once; David Wheeler demonstrates how to make them work with PL/pgSQL. Managing Many-to-Many Relationships with PL/pgSQL
Publish Date: Jun. 29, 2006SQL gives you plenty of options for handling relationships--you can use joins and database relations, or you can make multiple queries and write complex logic on the client. What are the benefits and drawbacks of each? David Wheeler recently experimented with moving complex relationship logic into PostgreSQL's PL/pgSQL language; the results were stunning. Writing PostgreSQL Functions with PL/pgSQL
Publish Date: May. 11, 2006One of the most powerful features of PostgreSQL is its support for user-defined functions. The language to learn is PL/pgSQL, an unpronounceable but powerful way to write UDFs. David Wheeler introduces the language and demonstrates why UDFs are useful. Installing libapreq on Jaguar: An Update
Publish Date: Feb. 7, 2003As of version 1.1, libapreq formally supports Mac OS X 10.2. This means that those running Jaguar can now use libapreq without compiling support for it directly into Apache. David Wheeler explains how. Build Your Own Apache Server with mod_perl and mod_ssl
Publish Date: Dec. 18, 2002In part one of this series, David E. Wheeler discussed some of the pitfalls associated with the default Apache install on Mac OS X. In this article he builds upon that approach and guides you through the process of including support for mod_ssl in your custom build. Build Your Own Apache Server with mod_perl
Publish Date: Nov. 5, 2002The Apache server that ships with Mac OS X is the genuine article. We're not talking about a weak, proof-of-concept port of Apache that runs under Windows. But, if you plan to do some serious mod_perl-based Web development work on Mac OS X, you'll need to take a number of issues into consideration as you begin working with Apple's Apache install.

Hire David Wheeler

Also find David on:

Buy Now and Save

About O'Reilly

Community

More O'Reilly Sites

Partner Sites

Shop O'Reilly