BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//PDXWIT - ECPv6.17.5.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:PDXWIT
X-ORIGINAL-URL:https://pdxwit.net
X-WR-CALDESC:Events for PDXWIT
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20250309T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20251102T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20260308T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20261101T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20270314T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20271107T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260908
DTEND;VALUE=DATE:20260911
DTSTAMP:20260827T231921Z
CREATED:20260704T215028Z
LAST-MODIFIED:20260827T231921Z
UID:3115-1788825600-1789084799@pdxwit.net
SUMMARY:DevopsDays PDX
DESCRIPTION:This event runs from Tuesday\, September 8\, 2026 at midnight through Thursday\, September 10\, 2026 at midnight.\nDescription:\nJoin us at DevOpsDays Portland – September 8-10\, 2026 at Portland State University!\n\nDevopsdays is a worldwide series of technical conferences covering topics of software development\, IT infrastructure operations\, and the intersection between them. Each event is run by volunteers from the local area. We welcome speakers of all backgrounds and experience levels. DevOpsDays Portland is about sharing real stories\, practical lessons\, and building community.\n\nThe CFP and registration are both open now\, so go get your tickets now.\nTags: devops\, cloud\, ansible\, puppet\, configuration\, sre\nImported from: http://calagator.org/events/1250482618
URL:https://pdxwit.net/event/devopsdays-pdx/
LOCATION:PSU Smith Union Building\, 1825 SW Broadway\, Portland\, OR\, United States
CATEGORIES:Calagator
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20260908T183000
DTEND;TZID=America/Los_Angeles:20260908T203000
DTSTAMP:20260827T231921Z
CREATED:20260813T193841Z
LAST-MODIFIED:20260827T231921Z
UID:3681-1788892200-1788899400@pdxwit.net
SUMMARY:PDXPUG MeetUp: Migrating to a Temporal Schema
DESCRIPTION:Please note different time and location this month at (https://www.upstartcollective.org/) at the U.S. Bancorp Tower (a.k.a. Big Pink).  Please RSVP on MeetUp.  Tuesday September 8\, 2026 from 6:30pm to 8:30pm.\n\nCoinciding with (https://devopsdays.org/events/2026-portland-or/welcome/)\, Sept 8-10\, 2026.\n\nIn v18\, Postgres got temporal primary keys\, unique constraints\, and foreign keys (with `NO ACTION`). Hopefully in v19 we’ll have `UPDATE/DELETE FOR PORTION OF`. So it’s a good time to start thinking about migrating your schema to a temporal structure. Some advantages include:\n\n– Easier queries and joins to reconstruct historical data.\n– A better way to do soft-deletes (preserving referential integrity).\n– No bugs from foreign key references to since-updated data.\n– A less ad hoc way of representing historical data.\n\nThis talk will explore how to migrate your schema to include application-time `daterange` and `tstzrange` columns. I’ll use an existing schema for a time-tracking and invoicing application (used by me for over 12 years)\, showing the pain points of the old structure\, not sparing my pride at some bad decisions\, and give an approach to bring it all into a nicer temporal structure.\n\nWe will also talk about some remaining pain points in using temporal tables\, and suggestions to mitigate them.\nIf you are contemplating a move to temporal tables\, this talk will give you an overview of the landscape.\n\nPresented by Paul Jungwirth:\n\nPaul is a freelance software developer in Portland\, Oregon.\nHe has built applications with Postgres since 2010 and is the author of several extensions.\nHis Postgres contributions include work on GiST indexes\, multiranges\, and SQL:2011 application-time features.\nTags: postgres\, postgresql\nImported from: http://calagator.org/events/1250482662
URL:https://pdxwit.net/event/pdxpug-meetup-migrating-to-a-temporal-schema/
LOCATION:Upstart Collective: 111 SW 5th Ave\, Portland Oregon 97204 US
CATEGORIES:Calagator
END:VEVENT
END:VCALENDAR