Learn about adding a constraint, that acts the opposite of a unique constraint, ensuring that values across rows for two columns are never distinct.
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.
Learn about generated columns in PostgreSQL. These may be referred to as "computed", "calculated" or "virtual" columns in other relational database systems.
Configure Terraform to use a shared PostgreSQL server to hold the terraform state and implement locks.
A walkthrough of how you may wish to gracefully handle the need to ingest a large amount of data into your database.
Play around with PostgreSQL with docker so that you don't have to install it locally and can throw it away.
A buildup of how to generate a query to create a "leaderboard" of of your top scorers.
Calculate the distance between two points on earth using PostGIS.
Import spatial data into PostgreSQL and query the data with the help of PostGIS.
Install the routing extension for PostgreSQL
Learn how to use UUIDs in MySQL for your table IDs, rather than using auto_increment.