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 on Oracle

May 09 2013

I found myself with a little unexpected time at work recently, and since we use Oracle (for a few more months), I decided to port Sqitch. Last night, I released v0.970 with full support for Oracle. I did the development against an 11.2 VirtualBox VM, though I think it should… read more

Rationality and Faith

April 24 2013

I got an invitation to write on Medium a couple weeks ago. I have been pondering some more philosophical posts lately, so I thought I’d try posting there. My first post, “Misguided Delusion,” tries to pull apart the the false dichotomy between faith and rationality. Yeah, really. That kind of… read more

More Sun

April 17 2013

We spent seven weeks last summer in Northern France. Man it was an awesome time. None of us wanted to leave! Well, almost true. The thing about Normandy is that the weather is very much like Portland—except that Juneuary lasts through July and August. We were so desperate for sun… read more

Sqitch: Now with SQLite Support

April 10 2013

This week I released Sqitch v0.961. There are a number of great new features v0.95x, including the beginning of two features I’ve had in mind since the beginning: VCS integration and support for multiple databases.Read More � read more

Sqitch on Windows (and Linux, Solaris, and OS X)

February 27 2013

Thanks to the hard-working hamsters at the ActiveState PPM Index, Sqitch is available for installation on Windows. According to the Sqitch PPM Build Status, the latest version is now available for installation. All you have to do is:Read More � read more

Sqitch Homebrew Tap

February 22 2013

If Sqitch is to succeed, it needs to get into the hands of as many people as possible. That means making it easy to install for people who are not Perl hackers and don’t want to deal with CPAN. The Sqitch Homebrew Tap is my first public stab at that.… read more

Bootstrapping Bucardo Master/Master Replication

February 12 2013

Let’s say you have a production database up and running and you want to set up a second database with Bucardo-powered replication between them. Getting a new master up and running without downtime for an existing master, and without losing any data, is a bit fiddly and under-documented. Having just… 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

Partner Sites

Shop O'Reilly