December 5, 2023
What is the main difference between PostgreSQL and MySQL? Why choose PostgreSQL over MySQL? Find the answer to these questions in this video comparison.
December 1, 2023
PostgreSQL and MongoDB compared on database structure, deployment, replication, clustering and documentation, with where each one is the wrong choice.
November 30, 2023
Every PostgreSQL data type with its storage size, plus how to choose between the pairs that trip people up: varchar and text, timestamp and timestamptz, numeric and float, json and jsonb.
November 23, 2023
Find long-running PostgreSQL queries with pg_stat_activity, inspect the locks and execution plans behind them, then cancel or terminate them safely.
November 23, 2023
List PostgreSQL indexes from psql or with SQL queries on pg_indexes: filter by table, read each index definition, and check how much space an index uses.
November 22, 2023
Three ways to list schemas in PostgreSQL, with psql, a catalog query and pgAdmin, plus how to read a single table's structure and check schema sizes.
November 21, 2023
How PostgreSQL roles differ from users, the split between user roles and group roles, how to grant and revoke privileges, and how inheritance resolves them.
November 21, 2023
Check your PostgreSQL version on Linux, macOS, Windows or in pgAdmin, with the commands for each and what to do when psql is not on your PATH.
November 14, 2023
MySQL is relational, PostgreSQL is object-relational. What that changes for arrays, JSON and custom types, and how the two compare on the rest of the ground.
