Upcoming meetings

October:
We’ll have a query tuning workshop at our next meeting, on October 18.

Please submit your query to the mailing list beforehand, so we can plan an agenda.

November:
We have a special guest scheduled for our November 15th meeting! Greg Smith from 2nd Quadrant will be visiting us, topic TBD.

Advertisements

PDXPUG: September meeting coming up

When: 7-9pm Thu Sep 20, 2012
Where: Iovation
Who: David Wheeler
What: Sqitch

SQL change management is hard. Most “migration”-style implementations require opaque naming conventions, prefer DSLs that cover a fraction of SQL, and require duplication of code for simple changes to existing functions. Such does not have to be. And now it’s not

Introducing Sqitch, simple SQL change management that doesn’t suck. Sqitch doesn’t care what programming language your app is written in. It has no opinions as to what database to use or what its schema should look like. And it doesn’t require sequentially-named migration scripts or the use of any DSL other than SQL. Sqitch lets you to write SQL migration scripts thar target your database, and provides a simple, unintrusive interface for specifying dependencies, so that it can run things in the proper order.

So come to this talk to learn all about Sqitch: How it works, where to get it, and how to get the most out of managing database deployments.

David Wheeler is Senior Data Architect at iovation and an associate at PGExperts. He is responsible, among other things, for PGXN, pgTAP, and DesignScene. He lives in Portland unless he’s traveling with his family.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Building security will close access to the floor at 7:30.

After-meeting beer location TBD. See you there!