Presented by:

Software Developer, working with micro-startups & small teams to build niche software, typically database-backed desktop-style enterprise-oriented web apps running server-side in pure Java on the Vaadin framework.

Previously worked in long-term client engagements building in-house custom-crafted departmental database apps for cost accounting, business operations, and workflow.

Also spent a couple years as a trainer teaching software development (database, business logic, and user-interface) to developers both novice and expert in week-long seminars.

Hobbies include extreme dog-walking and welding bird-cages. And spending way too much time on Stack Overflow.

Ten of my favorite new things in Postgres 10.

  • Replacement for SERIAL (identity column)
  • Traceable COMMIT
  • Parallel query
  • Cross-column statistics
  • New collation (sorting)
  • More XML
  • logical replication
  • Simplifying timestamps
  • Renaming & renumbering
  • Security tweaks

We spend a chunk of time explaining the surprisingly troublesome nature of the Postgres-specific SERIAL and how it is now gladly replaced by SQL-standard identity columns. Another chunk of time is spent on the practicalities of determining if a transaction completed successfully or not, now made easier with traceable COMMIT. Then we accelerate moving faster and faster through the remaining items, looking at the nooks and crannies of new features that I found useful for my own work and that you may not have yet discovered.

Date:
Duration:
1 h 30 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2018
Language:
Track:
PostgreSQL
Difficulty:
Medium

Happening at the same time:

  1. Build and Program Your First NXT Robot
  2. Start Time:
    2018 April 28 02:30

    Room:
    CC-234 BAIRS

  3. Do good things - and talk about it!
  4. Start Time:
    2018 April 28 05:00

    Room:
    CC-201 TUT1

  5. Introduction to Working with Vagrant
  6. Start Time:
    2018 April 28 05:00

    Room:
    CC-202 TUT2

  7. Successful 2FA is a matter of smooth workflows
  8. Start Time:
    2018 April 28 06:00

    Room:
    CC-200

  9. The business case for copyleft
  10. Start Time:
    2018 April 28 06:00

    Room:
    CC-114

  11. Better Brewing through Data Science and Machine Learning
  12. Start Time:
    2018 April 28 06:00

    Room:
    CC-208

  13. The Ubuntu Home Server
  14. Start Time:
    2018 April 28 06:00

    Room:
    CC-115

  15. GO generate all the things!
  16. Start Time:
    2018 April 28 06:00

    Room:
    CC-236

  17. OpenSource: Love what you do everyday!
  18. Start Time:
    2018 April 28 06:00

    Room:
    G-103

  19. Programmers are Evil
  20. Start Time:
    2018 April 28 06:00

    Room:
    HC-108

  21. Orchestrating Multi-service Applications on Kubernetes
  22. Start Time:
    2018 April 28 06:00

    Room:
    CC-235