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...
December 1, 2023
PostgreSQL and MongoDB are popular DBMSs. Learn how they defer on performance, features, scalability, security, and more.
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 ...
November 23, 2023
Find slow & long-running postgreSQL queries, kill them and optimize your database.
November 23, 2023
Find out how to list indexes in PostgreSQL together with related commands and SQL queries.
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 sche...
November 21, 2023
How PostgreSQL roles differ from users, how to grant and revoke privileges, and how inheritance decides what each role can actually do.
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 PAT...
November 14, 2023
MySQL and PostgreSQL are popular relational database systems. how do they defer on performance, features, scalability, security, and more.
