PDXPUG: June meeting

When: 6-8pm Thursday June 15, 2017
Where: iovation
Who: Kevin Jernigan, AWS
What: Amazon Aurora (PostgreSQL)

In 2014, AWS announced Amazon Aurora – a cloud-native, MySQL-compatible relational database. Features include fault-tolerant, self-healing storage that allows customers to scale from 10 GB all the way up to 64 TB without pre-provisioning. Aurora makes six copies of data across three Availability Zones and backs it up to Amazon Simple Storage Service (S3) without impacting performance or availability. Customers can create up to 15 low-latency read replicas that draw from common storage.

In response to repeated customer requests for the same capabilities for PostgreSQL, AWS announced the Amazon Aurora PostgreSQL-compatible edition in late 2016.

In this talk we’ll cover what makes Aurora (PostgreSQL) different from PostgreSQL, as well as what remains the same. We’ll discuss compatibility, scalability and performance. Please bring your scenarios, questions and requests!


Kevin Jernigan is a Senior Product Manager in the Amazon Relational Database Services (RDS) team. His deep database engine experience spans Oracle, Ingres, Informix, DB2, and PostgreSQL. He lives in San Francisco, and when not working on database engines loves to play squash and spend time with his wife and kids.


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!

Advertisements

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

PDXPUG: July meeting – It’s Our 10th Anniversary!

When: 6-8:30pm Thursday July 21, 2016
Where: iovation
What: 10th Anniversary Social

I can’t believe it’s been 10 years since OSCON 2006, when Selena and I spoke to Josh B about starting a user group.

And here we are.

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; there might 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!

PDXPUG: March meeting in two weeks

When: 6-8pm Thursday Mar 17, 2016
Where: Iovation
Who: Josh Berkus
What: Big Data on Pg 9.5

PostgreSQL 9.5, released in January, is full of tasty goodness for big data folks: UPSERT, new aggregation types, OLAP support, new Foreign Data Wrapper functionality, BRIN indexes, and more. Josh Berkus will give us a rundown of these features, with multiple demos.

Josh Berkus is a member of the PostgreSQL Core Team, and works at Red Hat where he manages the Project Atomic community. Containers, containers, containers! Which is appropriate, since he’s also a potter.


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!

PDXPUG: February meeting in two weeks

When: 6-8pm Thursday Feb 18, 2016
Where: Iovation
Who: Jason Owen
What: Incremental Schema Discovery via JSON Wrangling

Over the last few releases, Postgres has added and expanded support for storing and querying JSON documents. While the simplicity and flexibility of storing free-form data can be appealing, frequently what’s stored is actually fairly structured. Using data from the GitHub Archive, Jason will show how easy it is to load JSON into Postgres, demonstrate some fairly mechanical schema refactorings to extract structure from JSON data, and then compare the resulting normalized tables with the original, with the documentation, and with the data set loaded into Google BigQuery.

Jason has been using Postgres in earnest for two years now. While he’s worn the DBA hat as a full stack engineer from time to time, he is primarily a developer. He works at Tripwire and is an alumnus of Portland State University. Sometimes he says things online as @jasonaowen.


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!

PDXPUG: January meeting

NOTE: This month’s meeting is one week earlier than our usual schedule, so we don’t conflict with SCALE.

When: 6-8pm Thursday January 14, 2016
Where: Iovation
Who: Gabrielle Roth
What: RDS Postgres

Amazon integrated Postgres into their general Relational Database Services (RDS) offerings July 1, 2014. RDS offers automatic failover, scalability, and easy configuration, plus Amazon handles all the patching and most of the upgrades for you! Their SDK supports many languages and includes a robust CLI, if you want to automate management of your deployments. They also support several popular Postgres extensions.

Of course, since it’s a managed service, you can’t do everything you might expect or want to. We’ll discuss the fun and quirky features I’ve discovered in a year and a half of working with production RDS deployments. Come find out what it’s like to use RDS Postgres day-to-day.

(This is an updated version of my talk from last year. )

Gabrielle has been using Postgres since sometime in the version 7s and thinks that the best part of using Open Source software is the culture of sharing knowledge. She co-leads PDXPUG, the Portland PostgreSQL Users’ Group. Gabrielle’s current areas of interest are monitoring, benchmarking, and writing freaky SQL.


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!