see also https://osquery.io/

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 1484120AC4E9F8A1A577AEEE97A80C63C9D8B80B

sudo apt-get install software-properties-common python-software-properties

sudo add-apt-repository ''deb [ arch=amd64 ] https://osquery-packages.s3.amazonaws.com/xenial xenial main'

sudo apt-get update

sudo apt-get install osquery

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.