November 28, 2023
Explore our in-depth guide on Server-Side Encryption with Customer-Provided Keys (SSE-C). Learn how to securely upload and download data using SSE-C with Amazon S3, DO, Wasabi, and Linode.
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 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.
