Capturing Logic with Custom Functions in PostgreSQL

links.md

Short link to this gist: https://bit.ly/2Ppp0Uz

Links to software used in this course:

• Docker Deskop for Mac and Windows
  • https://www.docker.com/products/docker-desktop
• Docker Community Edition for Linux
  • https://docs.docker.com/install/overview/
• Azure Data Studio:
  • https://docs.microsoft.com/en-us/sql/azure-data-studio
• PostgreSQL Docker images:
  • https://hub.docker.com/_/postgres
• PostgreSQL Downloads for local installation:
  • https://www.postgresql.org/download/

Dell DVD Store Database Test Suite

• http://linux.dell.com/dvdstore/

PostgreSQL procedural languages

• Built in languages
  • https://www.postgresql.org/docs/current/xplang.html
• Third party languages
  • https://www.postgresql.org/docs/current/external-pl.html
• C language
  • https://www.postgresql.org/docs/current/xfunc-c.html

Defensive Programming

• Written for SQL Server but full of great tips that you can easily adopt
  • https://www.red-gate.com/library/defensive-database-programming
• Client configuration environment settings
  • https://www.postgresql.org/docs/current/runtime-config-client.html

PostgreSQL courses on Pluralsight

• Programming Postgresql
  • https://app.pluralsight.com/library/courses/programming-postgresql
• PostgreSQL Data Manipulation Playbook
  • https://app.pluralsight.com/library/courses/postgresql-data-manipulation-playbook
• Combining and Filtering Data with PostgreSQL
  • https://app.pluralsight.com/library/courses/combining-filtering-data-postgresql
• PostgreSQL Functions Playbook
  • https://app.pluralsight.com/library/courses/posgresql-functions-playbook