An intuitive spreadsheet-like interface that lets users of all technical skill levels view, edit, query, and collaborate on Postgres data directly—100% open source and self hosted, with native Postgres access control. - mathesar-foundation/mathesar

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.