April 2018 Meeting – PUDL: Portland Urban Data Lake

Presented by: Dr. Kristin Tufte

When: 6-8pm Thursday April 19, 2018

 

This talk will describe work in Smart Cities in the Portland region. We’ll begin with the framework and motivation for the Smart Cities work and the question What is a Smart City? We’ll discuss Portland’s approach to Smart Cities, provide some historical context and then give an overview of ongoing Smart Cities projects including work on AV policy, the Portland Urban Data Lake, new sensors and earthquake resilience. The goal of the talk is to give the audience an overview of the work being done in Portland to bring a human face to data and technology and to inspire question and discussion.

———

Dr. Tufte is actively involved in Portland’s Smart Cities work and was the data lead on the City of Portland’s Smart Cities proposal. Dr. Tufte has collaborated closely with transportation agencies in the Portland-Vancouver area for the past ten years and directs PORTAL — the regional transportation data archive. Dr. Tufte is a member of the Transportation Research Board’s Urban Data Committee, co-chairing its Urban Big Data subcommittee and Portland Global Cities Team Challenge Action Cluster. Dr. Tufte has a PhD in Database Management from the University of Wisconsin – Madison. Dr. Tufte’s passion is using data and technology to change people’s lives, especially those in traditionally underserved communities.

———

NEW MEETING LOCATION

Our meeting will still be held at iovation, but now on the 3rd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines.  For access to the 3rd floor of the plaza, please either take the lobby stairs to the third floor or take the plaza elevator (near Subway and Rabbit’s Cafe) to the third floor. There will be signs directing you to the meeting room.

Advertisements

Postgres container workflows

When: 6-8pm Thursday March 15, 2018

Ahoy database folk!  Time for another meetup and more container chit chat.  Yeah yeah, you, like me, have heard that you shouldn’t run databases in containers.  Well without throwing all caution to the wind, I’m hoping to show you guys some container workflows with Postgres that I’ve been using lately.  We’ll talk a bit about why you haven’t been running databases in containers, then walk through some development work flows with Postgres, and lastly look at options for deploying and running persistent databases in containers.

https://github.com/grantholly/pg_docker

———

Hi, its me Grant Holly.  I work at Iovation on the data science and analytics team wrangling our data into visualizations and machine learning models.  I live in SE, play in bands, and am a learning machine.

———

NEW MEETING LOCATION

Our meeting will still be held at iovation, but now on the 3rd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines.  For access to the 3rd floor of the plaza, please either take the lobby stairs to the third floor or take the plaza elevator (near Subway and Rabbit’s Cafe) to the third floor. There will be signs directing you to the meeting room.

PDXPUG is moving location

Our host Iovation (https://iovation.com) has recently moved office locations, so we’re packing up and moving to the new location.  Where we used to meet on the 32nd floor of the US Bank Corp Tower, we’re now meeting on the third floor.  You could say that’s pretty close by.  Right now we are working on getting a new room for the group hopefully with more space.  We’re looking forward to 2018 in the new digs.  See you guys at the next meeting!

PDXPUG: June meeting

When: 6-8pm Thursday June 16, 2016
Where: Iovation
Who: Josh Berkus
What: HA PostgreSQL Cluster In A Box

Josh Berkus, crazy container guy and core team member, will demonstrate high availability Postgres using a tiny rack of mini servers, just 12″ high. Not only is this a fun stunt, but the software and techniques used are ones which work on real servers. This stack includes PostgreSQL, Patroni, Kubernetes, Atomic Host, Docker, etcd, and a stack of Minnowboards. Learn to scale out PostgreSQL with containers. He may also be able to demo the new multi-master PostgreSQL.


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!

May meeting in one week

When: 6-8pm Thursday May 19, 2016
Where: Iovation
Who: Mark Wong, 2ndQuadrant
What: PostgreSQL Performance Presentation 9.6devel Edition

We will present the latest test results comparing where we are with
9.6devel to the 9.5 branch. Additionally, there will also be data to
illustrate the gaps that Postgres may attempt to close between other
open source column store database solution using DBT-3 (a synthetic
ad-hoc decision support workload).

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!

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

When you arrive at the Iovation office, please sign in on the iPad at
the reception desk.

See you there!

(You can RSVP on our meetup group, if you like.)

PDXPUG: September meeting next week

When: 6-8pm Thursday Sept 17, 2015
Where: Iovation
Who: Eric Hanson
What: 10 examples of datafication

Eric, our resident data philosopher and CEO of Aquameta, will talk and give demos on 10 examples of Datafication, including the raspberry pi FDW!

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 5:45 and building security closes access to the floor at 6:30.

See you there!

PDXPUG: November meeting in two weeks

When: 6-8pm Thu Nov 20, 2014
Where: Iovation
What: 9.4 party!

As discussed at last month’s meeting, we’re going to check out some of the new 9.4 features. It will help if you already have 9.4 installed on your laptop, but if you’re new & don’t know how to do that, just show up & we’ll help you out.

If you’re a Vagrant user, try this: https://github.com/softwaredoug/vagrant-postgres-9.4

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 5:45 and building security closes access to the floor at 6: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!