PDXPUG: April meeting

When: 6-8pm Thursday April 20, 2017
Where: iovation
Who: Josh Berkus
What: 9.6 Features

PostgreSQL 9.6 has been out for six months … how many of you have migrated to it? Well, you might decide to stop putting off that upgrade once you learn about a few of the features you might have missed reading about. In this all-demo presentation, Josh Berkus will show off a bunch of 9.6’s key features, including:

– parallel query
– sync replication improvements
– FDW query push-down
– crosstabs
– full-text phrase search
– pgAdmin4

Yes, Postgres 10 will be way cool, but that’s no reason to put off
deploying 9.6 now.

Josh Berkus recently retired from the PostgreSQL Core Team and is currently working for Redhat as the Project Atomic Community Lead.


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 – March meeting

When: 6-8pm Thursday March 16, 2017
Where: iovation
Who: Grant Holly
What: Intro to Postgres

This month, Grant’s going to give a talk best described as “Getting started with Postgresql for the uninitiated and bitter veterans”.

Grant Holly is a Service Reliability Engineer at iovation, where he works with a lot of different database systems.


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 – 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!