2095 shaares
3 private links
3 private links
7 results
tagged
postgresql
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.