PDXPUG – February meeting

When: 6-8pm Thursday Feb 16, 2017
Where: iovation
Who: Darrell Fuhriman
What: Just enough PostGIS: a brief intro to spatial data in Postgres

In this quick overview, Darrell will cover the spatial data model, data manipulation, spatial joins, and do some basic analysis.

Darrell has been active in the local Open Source Geospatial community for years, most exhaustingly as Chair of FOSS4G 2014, the world’s largest Open Source Geospatial conference. He also teaches Spatial Database Design in the Geography Department at Portland State University, and supplements his adjunct instructor income as VP of System Engineering at Renew Financial — a clean energy financing startup.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG – January meeting

When: 6-8pm Thursday Jan 19, 2017
Where: iovation
Who: Mark Wong
What: pglogical

Mark Wong will give an overview of pglogical, the latest replication option for Postgres. It’s a lower-impact option than trigger-based replication, and features include the ability to replicate only the databases and tables you choose from a cluster. Part of the talk will cover use cases and future development plans.

Find out more here: https://2ndquadrant.com/en/resources/pglogical/

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the
USA.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: November meeting next week

When: 6-8pm Thursday Nov 17, 2016
Where: iovation
Host: Jay R.
Topic: You pick!

We’ll do our last meeting of 2017 “Lean Coffee“-style . Throw your question/topic up and let’s see where the conversation goes!

If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: October meeting in two weeks

When: 6-8pm Thursday October 20, 2016
Where: iovation
Who: Kristin Tufte
What: Urban Analytics: Connecting People to Data

Data from connected and automated vehicles, from connected intersections, positional or probe data from cell phones, crowd-sourced data, fixed-sensor vehicle speed and volume data, air quality data, and more… The list of data sources available to Smart Cities for use in Urban Analytics is almost endless. But data by itself is just data; what’s powerful is using data to solve people’s problems. This premise was central to the City of Portland’s – Ubiquitous Mobility for Portland proposal – one of seven finalists in the U.S. Department of Transportation’s $40 million Smart City Challenge.

In this talk, Dr. Tufte will discuss possibilities for using data and analytics for solving people’s problems including technical, institutional and social barriers to such work. She will also talk about the Smart City Challenge itself – she was a core member of the team and will share insight into (really stories about) the process, the team, the work and the presentation in DC. In the end, Columbus, OH won the challenge, but Portland put together a great proposal and a great team and she’ll also talk about how she expects Portland to continue to move Smart Cities forward.

Dr. Kristin Tufte is a transportation data management expert with expertise in the application areas of transportation and smart cities. Dr. Tufte has collaborated closely with transportation agencies in the Portland-Vancouver area for the past ten years and manages PORTAL — the longest-running public transportation data archive in the nation. Dr. Tufte is a key member of the highly-regarded city-university partnership between Portland State University and City of Portland and was the data lead on the City of Portland’s Smart Cities proposal, one of seven finalists in the US Department of Transportation’s Smart City Challenge. Dr. Tufte’s passion is using data and technology to change people’s lives.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: September meeting

When: 6-8pm Thursday September 15, 2016
Where: iovation
Who: Toby Fee
What: Connecting Your Pg DB to Node Apps

Toby will tell us about his experiences connecting Postgres DBs to Node apps using the Node libraries Bookshelf and Knex. He ran into some of limitations on the node side, and wrote some methods for allowing full query flexibility while still remaining injection-secure.

Toby is currently a developer at NWEA.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: August meeting in two days

When: 6-8pm Thursday August 18, 2106
Where: iovation
Who: Brian Panulla, Marty Zajac, Gabrielle Roth
What: ETL Throwdown (or up)

For August, we’re having a panel discussion on various ETL tools we’ve tried.
Brian: moving from bulk ETL to near real time ETL with Tungsten Replicator to replicate from MySQL to PostgreSQL and Solr
Marty: Pentaho
Gabrielle: CloverETL, home-grown solution using postgres_fdw, and a brief rant about Informatica if we have time.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: 10th anniversary meeting tonight!

We’re having our 10th Anniversary meeting tonight!

As in previous years, I generated speaker & topic tag clouds:

When: 6-8:30pm Thursday July 21, 2016
Where: iovation
What: 10th Anniversary Social
This meeting is 100% social and will take the place of our regular July meeting.  iovation will provide a light dinner and beverages.  We will provide the conversation and reminiscing.  There will not be any long speeches, but there will be cupcakes.
iovation is 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 5:45 and building security closes access to the floor at 6:30.
See you there!