PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Speakers
Joe Conway
Schedule
Day Talks - Day 4 - Friday - 2015-06-19
Room DMS 1140
Start time 15:00
Duration 00:45
Info
ID 761
Event type Lecture
Track Applications
Language used for presentation English

Shabang

Scripting with Postgres

Sometimes bash is just the way to go! This talk will cover tips and techniques for effective bash scripting with PostgreSQL.

Sometimes bash is just the way to go! This talk will cover tips and techniques for effective bash scripting with PostgreSQL.

It will include guidance about:

  • Pros/cons of shell scripts
  • Function library creation and use
  • Executing SQL
  • Set/get PostgreSQL data from/into script variables
  • Keeping PostgreSQL functions in sync with scripts
  • Locking
  • Doing work in parallel
  • Ensuring cleanup

This is a source-code heavy talk. Moderate experience with both bash scripting and PostgreSQL is needed to get the most out of it.