BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:STANDARD DTSTART:20181104T020000 RDATE:20181104T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190206T194854Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T180000 DTSTAMP;VALUE=DATE-TIME:20190206T194854Z LAST-MODIFIED;VALUE=DATE-TIME:20190206T194854Z UID:http://calagator.org/events/1250475002 DESCRIPTION:Temporal databases let you record history: either a history o f the database (what the table used to say)\, a history of the thing its elf (what it used to be)\, or both at once. The theory of temporal datab ases goes back to the 90s\, but standardization has only just begun with some modest recommendations in SQL:2011\, and database products (includ ing Postgres) are still missing major functionality. \;\n \;\nThis talk will cover how temporal tables are structured\, how they are queri ed and updated\, what SQL:2011 offers (and doesn't)\, what functionality Postgres has already\, and what remains to be built. \;\n \;\nPau l started programming on a Tandy 1000 at age 8 and hasn't been able to s top since. He helped build one of the Mac's first web servers in 1994 an d has founded software companies in politics and technical hiring. He wo rks as an independent consultant specializing in Rails\, Postgres\, and Chef.\n\nTags: postgres\, postgresql\, pdxpug\, temporal\n\nImported fro m: http://calagator.org/events/1250475002 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: Temporal Databases: Theory and Postgres LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT END:VCALENDAR