PDXPUGDay 2014 report

We had about 50 folks attend the PDXPUGDay 2014 last week, between DjangoCon and Foss4g. A lot of folks were already in town for one of the other confs, but several folks also day tripped from SeaPUG! Thanks for coming on down.

Thanks again to our speakers:
Josh Drake
David Wheeler
Eric Hanson
Veronika Megler
Kristin Tufte
Josh Berkus

(Plus our lightning talk speakers: Josh B, Mark W, and Basil!)

And our sponsors:
2nd Quadrant
iovation
PGX

And of course, PSU for hosting us.

Videos are linked from the wiki.

PDXPUG: September meeting

When: 7-9pm Thu Sep 18, 2014
Where: Iovation
Who: Jay Riddle
What: Using Postgresql to enable Google like Search

Jay’s been experimenting with Pg’s full text search capabilities. At our next meeting, he’ll cover the following:
* Brief intro on why Google like search capabilities are fun.
* Introduce Postgresql full text abilities. Discuss at a high level why a full text index may be a bit heavier than a normal index.
* Look at possible solutions for use cases where the data you want to index is spread across multiple columns and multiple tables.

Jay Riddle is a database administrator at Viewpoint software.

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!

Elevators open at 6:45 and building security closes access to the floor at 7:30.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!

PDXPUG: August meeting

When: 7-9pm Thu Aug 21, 2014
Where: iovation
Who: Jim Newman, iovation
What: Elasticsearch & Postgres, a working relationship

Topics to be covered:
– A brief intro to Elasticsearch
– Indexing Postgres with Elasticsearch using the JDBC river plugin
– SQL versus the Elasticsearch Query DSL, similarities (there are some) and differences
– Using Postgres Perl functions for some SQLish access to Elasticsearch
– Feasibility of a foreign data wrapper for Elasticsearch?, pg2elasticsearch is still just a GitHub readme

Jim Newman has 30 years of assorted database-related activity and shooting pool. He’s currently employed as Principal Data Architect at iovation.

This month we get to try yet another meeting location while the iovation offices are being renovated. We’re still in the US Bancorp Tower at 111 SW 5th (5th & Oak), but we’ll be in the iovation temporary office on the 36th floor, in the “West Hills” conference room. Once off the elevator, enter through the door with the small “iovation” sign, then just go right and keep right until you hit a dead end, which is where “West Hills” is. Signs will be posted.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!

PDXPUG: June meeting in two weeks

When: 7-9pm Thu June 19, 2014
Where: Iovation
Who: David Kerr
What: Postgres on Docker

David Kerr’s back this month to talk about Postgres on Docker.

Linux containers are finally getting their day, and leading the way is a project known as Docker. Docker is in use today at places like Google, eBay, and New Relic and aims to change the way we think about deploying software.

Join us as we get a quick primer on Docker and then run it through its paces with the not-so-typical, but interesting, use-case of running PostgreSQL in a container.

We’ll look at benchmarks, and various novel use cases where Docker may be an interesting fit in the database world.

Dave Kerr is a recovering DBA, PostgreSQL evangelist and is currently working as a Software Engineer on the Site Engineering team at New Relic.

We have a new meeting location while the Iovation offices are being renovated. We’re still in the US Bancorp Tower at 111 SW 5th (5th & Oak), but on the ground floor in the Training Room. As you face the bank of elevators from the main lobby, take a good deep breath of drywall dust and head to your right to a hallway. Follow the hallway as it turns to the left. The Training Room is the 2nd door on your right and is labeled “Training Room”. There is no room number.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!