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
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.
|
|
David blogs at:
http://www.justatheory.com/
http://blog.pgxn.org/
SQL Change Management Sans Duplication
January 30 2012
In the previous episode in this series, I had one issue with regard to SQL change management that I wanted to resolve: duplication of code between deploy and revert scripts sucks. Worse still is the duplication of code to change just one line of a procedure. Here’s how I propose… read moreVCS-Enabled SQL Change Management
January 27 2012
In my previous post, I outlined the basics of a configuration-file and dependency-tracking SQL deployment architecture. But I left it off wanting to eliminate the need for such a file and still have it all work. This post outlines just how to do that by relying on VCS history to… read moreJanuary 26 2012
I've been thinking a lot about SQL change management. I've written about this before, implemented a dubious implementation of SQL migrations, and used a dependency-tracking solution with its own set of challenges. Nothing has satisfied me. But I think I may finally have cracked this thing wide open.Read More » read moreJanuary 12 2012
Day before yesterday, I finally got all of PGXN moved to a new server. I had been using a small server owned by my company, Kineticode, and hosted by Command Prompt. That was fine for a while, but CMD was needing its rack space back, and what with my new… read moreToday on the Perl Advent Calendar
December 22 2011
Hey look everybody, I wrote today's Perl Advent Calendar post, Less Tedium, More Transactions. Go read it!Read More » read moreHow to Integrate the TestFlight SDK into an iOS Project
December 18 2011
I've started using TestFlight to release DesignScene betas to testers. The documentation is thin, so I had to futz a bit, but fortunately it's a pretty simple app, so once I figured out that I just needed to stick to one "Team", I was off and running. And let me… read moreNovember 30 2011
Since June, as part of my work for PGX, I’ve been doing on-site full-time consulting for iovation here in Portland. iovation is in the business of deterring online fraud via device identification and reputation. Given the nature of that business, a whole lot of data arrives every day, and I’ve… read moreNovember 28 2011
By Daniele Varrazzo Finally, here it is. Well tested, documented, and pampered. With the PGXN Client installing extensions from the PGXN Network is a breeze: $ pgxn install semver $ pgxn load semver $ psql =# select 'foo'::semver; ERROR: bad semver value 'foo': expected number at foo LINE 1: select 'foo'::semver; Error! Meaning: success! The… read moreNovember 27 2011
After posting my thoughts on the Isaacson Steve Jobs biography a couple weeks ago, I finally let myself check out some of the deeper pieces on the topic by folks I respect. John Siracusa’s take was particularly enlightening, as his familiarity with the existing sources empowers a deeply authoritative critique… read moreNovember 11 2011
Thanks for all the comments on my Disposable Computing post. Alas, I’m beginning to see why sites like Daring Fireball don’t allow comments. Not that anyone was rude; it’s just that everyone missed the point. Every last one of you. (Well, except commenter “John”, who pointed out an inaccuracy in… read moreHire David Wheeler
For Inquiries Contact
Press Inquiries
Find Other Authors
Buy Now and Save
Use discount code: OPC10

All orders over $29.95 qualify for free shipping within the US. See details.

