PDXPUG April Meetup: Postgres with non-blocking IO and Scala

2019 April 18th Meeting 6pm-8pm


PSU Business Accelerator
2828 SW Corbett Ave · Portland, OR
Parking is open after 5pm.

Speaker: Grant Holly

This month I will be demonstrating using non-blocking IO database access using Scala and the Slick library.  No really, the library is called Slick AND it is very cool to use.  Slick and Scala are great for working with Postgres with either straight SQL, or using the FRM (that’s a Functional Relation Mapper like in functional programming).  After Hannah gave a great talk talk about Python, Postgres, and ORMs, I got to thinking that I could do a language and ORM talk.  Thanks Hannah, that was great.


Hi, it’s me still Grant.  I work at New Relic as an engineer on the database engineering team.  I’ve been using Postgres in production since 9.2 and have been using and enjoying Scala for about two years having worked on a couple of production high throughput applications.


January 2019 meetup and new location

When: 6-8pm Thursday January 24, 2018
Where: New Relic
Who: Mark Wong
What: Multi master replication

Happy new year everyone.  As always the new year brings changes.  For instance, we are moving meetup locations.  We will be meeting at PDX Code Guild (https://pdxcodeguild.com/contact_pdx_code_guild/).  They are located at the Business Accelerator at 2828 SW Corbett Ave (https://www.google.com/maps?q=2828+SW+Corbett+Ave,+Number+208+Portland,+OR+97201).  I think you will find the new accommodations quite nice.  And while the location may have changed, some things have not.  We will still have food and beverages available and interesting topics of discussion with other interesting people.

Mark Wong will be giving a talk on the always-vexing topic of multi-master replication with Postgres.

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the USA. He is a long time Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer
for the United States PostgreSQL Association, and a pretty nice guy too.

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 New Relic on the 27th 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! Please the elevator to the 27th floor.  It will be the last elevator bank on the North side of the building. There will be a front desk where you can sign in.

Thanks to everyone for PostgreSQL Day 2018

Thanks again everyone for a great day of presentations and discussion.

First, to our volunteers Michelle, Erik, and Mary Anne: you guys helped make this day possible.  Second, to our sponsors 2nd Quadrant (https://www.2ndquadrant.com/en/), PGExperts (https://pgexperts.com/): thanks for refreshments and support of the conference.  Thanks to Portland State University School of Computer Science for providing us a wonderful space.  Lastly, a huge ‘thanks a ton’ to Mark Wong for helping organize all of us and leading.

As we get in touch with speakers, we will post links here to any slides sample code here.

Grant Holly – What’s new in PostgreSQL 11 (https://github.com/grantholly/postgres_day_2018)

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.



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.



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!