LISTEN / NOTIFY: Automatic client notification in PostgreSQL
If 1000's of users constantly poll the database, a lot of load is caused for no benefit. LISTEN / NOTIFY is a better way, find out how.
PostgreSQL: Sequences vs. Invoice numbers
What's the problem with using PostgreSQL database side sequences to create unique invoice numbers to send to clients? Let's find out.
What is an inner join in SQL? And what is an outer join?
Joins: Learn how to use an inner join and an outer join in PostgreSQL today by reading our tutorial. Also covers semi and full joins.
ERROR: nextval: reached maximum value of sequence
Fix "ERROR: nextval: reached maximum value of sequence in PostgreSQL" - related to using serial data type to generate auto-increment columns
ALTER TABLE ... ADD COLUMN … done right in PostgreSQL
Running ALTER TABLE … ADD COLUMN can cause serious issues in production. Understand how to cleanly change PostgreSQL data structures.
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
Handling Bonus Programs in SQL
Learn how to address the issue of bonus programs in SQL, improve your understanding of PostgreSQL, and calculate bonus points efficiently
PostgreSQL 15: Using MERGE in SQL
Merge - UPDATED 2023 - a technical preview of how to merge lists with ease. Find out about a wonderful command - add power to your PostgreSQL.
Find and fix a missing PostgreSQL Index
Explains how to find a missing Postgresql index, what you can do to fix missing indexes, and how to achieve good database performance.
Multiranges in PostgreSQL 14
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
