PDXPUG: March Meetup: Let’s talk databases in python!

2019 March 21 Meeting 6pm-8pm

Location:

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

Speaker: Hannah Stepanek

Let’s talk databases in python! What’s an ORM? Is there a way to write database queries so that they are compatible with multiple types of databases? How do you make database changes (such as adding a new table or a new column) safely? What is a connection pool and why is it useful? What are some things that can go wrong when operating at scale? In this talk we’ll take a deep dive into how the python libraries sqlalchemy and alembic make managing production databases simple, efficient, and painless so you can get back to feature development.
Hannah has been working in industry for over 6 years as a python software engineer. She currently works at Hypothesis, a web application for annotating web pages and pdfs. In her spare time she enjoys riding her horse Sophie and playing board games.
Advertisements

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.

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!

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.

February 2018 Meeting: Automatic For The People

When: 6-8pm Thursday February 15, 2018

Want automated high availability PostgreSQL *without* relying on someone
else’s cloud service? It’s possible today, and easier than you think;
we just need a little container orchestration pixiedust, and your DBAs
can take the weekend off.

Josh Berkus will explain the current state of HA Postgres services on
Kubernetes/OpenShift, introducing the several projects in this area, and
then going into a deep dive on Patroni/Spilo. He’ll bring you up to
date on the new “Kube-native” Patroni, and work expected in the future.
With live demos!

———

Josh Berkus helps manage the Kubernetes community for Red Hat. He is a
“hacker emeritus” for PostgreSQL. He lives in NE Portland with a large
black cat, a pottery studio, and a librarian.

———

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.

PostgreSQL 10 Beta

When: 6-8pm Thursday July 20, 2017
Where: iovation
Who: Josh Berkus
What: PostgreSQL 10 Beta

 

PostgreSQL 10 is now out in beta. We called it 10 because this release is going to blow your socks off. Josh Berkus will demonstrate several of the new features in this version, including built-in logical replication, native partitioning, additional query parallelism, JSON full-text search, and more. He’ll also explain some of the issues you’re likely to encounter upgrading to Version X.

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.