News, tips, guides and tools by the creators of SimpleBackups web

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 17, 2023
Where database backup and recovery is heading: AI and machine learning inside the backup process, and what changes as data sources grow in volume and variety.

November 17, 2023
RTO is how fast you get a process back. RPO is how much data you can afford to lose. What the difference means in practice, and how to set each of them.

November 16, 2023
MongoDB and MySQL compared: BSON documents in schema-less collections against tables, rows and JOINs, MQL against SQL, and which fits which workload.

November 16, 2023
Five MySQL GUI tools compared, from MySQL Workbench to Sequel Pro, with the strengths and drawbacks of each for queries, schema design and administration.
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.