PDXPUG: February Meetup: Temporal Databases: Theory and Postgres

2019 February 21 Meeting 6pm-8pm (Note: Back to third Thursday this month!)

Location:

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

Speaker: Paul Jungwirth

Temporal databases let you record history: either a history of the database (what the table used to say), a history of the thing itself (what it used to be), or both at once. The theory of temporal databases goes back to the 90s, but standardization has only just begun with some modest recommendations in SQL:2011, and database products (including Postgres) are still missing major functionality.

This talk will cover how temporal tables are structured, how they are queried and updated, what SQL:2011 offers (and doesn’t), what functionality Postgres has already, and what remains to be built.

Paul started programming on a Tandy 1000 at age 8 and hasn’t been able to stop since. He helped build one of the Mac’s first web servers in 1994 and has founded software companies in politics and technical hiring. He works as an independent consultant specializing in Rails, Postgres, and Chef.

Advertisements

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)

PDXPUG: August Meetup

When: 6-8pm Thursday August 16, 2018
Where: iovation
Who: Mark Wong
What: Sneak peek at stored procedures

Stored procedure support is coming to PostgreSQL 11.  Come hear about what a stored procedure is and how it differs from the existing user-defined functions.

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.

—
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 3rd 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! 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. All attendess must check in at the iovation front desk.

See you there!

PDXPUG: June meeting

When: 6-8pm Thursday June 21, 2018
Where: iovation
Who: Mark Wong
What: Intro to OmniDB with PostgreSQL

OmniDB is an open source browser-based app designed to access and manage many different Database Management systems, e.g. PostgreSQL, Oracle and MySQL. OmniDB can run either as an App or via Browser, combining the flexibility needed for various access paths with a design that puts security first.

OmniDB’s main objective is to offer an unified workspace with all functionalities needed to manipulate different DBMS. It is built with simplicity in mind, designed to be a fast and lightweight browser-based application.

Get a tour of OmniDB with PostgreSQL!

 

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.

—
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 3rd 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! 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. All attendess must check in at the iovation front desk.

See you there!

PDXPUG: May meeting in one week

When: 6-8pm Thursday May 17, 2018
Where: iovation
Who: Dylan Hornstein
What: Learning SQL

During this PDXPUG meetup, we will talk about one person’s journey to learn SQL. From joining iovation’s Reporting Team without any experience with SQL or relational databases, to using SQL every day for adhoc data analysis and bulk data dumps, Dylan Hornstein will talk about his experience getting familiar with SQL and learning to navigate a relational database, as well as some challenges and tips he’s found along the way. The presentation is geared towards those starting out in data roles and we will likely expand into a wider conversation around using SQL and understanding data.

Dylan has been a Data Analyst at iovation for three years now. Having spent six months as a Client Manager before moving to his Data Analyst role, Dylan has experience working directly with iovation’s clients as well as working behind the scenes with the data. In his current role, he is responsible for providing reports, adhoc analysis and bulk data dumps for clients and internal teams. While Dylan had prior work experience as a Data Analyst, his move to iovation’s Reporting Team came with a steep learning curve, as he was new to working with SQL and relational databases.

—
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 3rd 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! 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. All attendess must check in at the iovation front desk.

See you there!

You can get the slides here:

https://pdxpug.files.wordpress.com/2018/05/pdx-pug.pptx

Here are some other cool resources that came up

Data Analysis Template

https://docs.google.com/document/d/1_heYpQNOa0c6XBvmhdFwiDiLZevkP47cViXcrBeyQBY/edit?usp=sharing

Sweet PSQLrc file

https://github.com/gorthx/generic_rc_files/blob/master/psqlrc

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.