Programster's Blog
Tutorials focusing on Linux, programming, and open-source
PostgreSQL - Ensuring Non Uniqueness Using Exclude Using Gist Constraint
Learn about adding a constraint, that acts the opposite of a unique constraint, ensuring that values across rows for two columns are never distinct.
PostgreSQL - Select Last Row For A Grouping
A short tutorial on how to select the last row for each grouping, where we are using a time-series of actions taken against a request. Thus we can quickly find the status of a request based on the last action that was taken against it.
PostgreSQL - Generated Columns
Learn about generated columns in PostgreSQL. These may be referred to as "computed", "calculated" or "virtual" columns in other relational database systems.
Use PostgreSQL To Store Terraform State
Configure Terraform to use a shared PostgreSQL server to hold the terraform state and implement locks.
MySQL / PostgreSQL Table Double Buffering
A walkthrough of how you may wish to gracefully handle the need to ingest a large amount of data into your database.
Play with PostreSQL Through Docker
Play around with PostgreSQL with docker so that you don't have to install it locally and can throw it away.
PostgreSQL - Leaderboard Query Example
A buildup of how to generate a query to create a "leaderboard" of of your top scorers.
Using PostGIS To Calculate Distance Between Two Points
Calculate the distance between two points on earth using PostGIS.
PostGIS - Importing Spatial Data
Import spatial data into PostgreSQL and query the data with the help of PostGIS.
Ubuntu 16.04 - Install PostgreSQL Routing Extension (pgRouting)
Install the routing extension for PostgreSQL