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 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 more
Also find David on:
Recent Twitter posts:
Buy Now and Save
Buy 2 books, get the 3rd FREE
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
