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.