Tag: SQL

All the articles with the tag "SQL".

• It's peer, Not ident

  11 Sep, 2026

  I checked a 2021 guide to installing PostgreSQL on Ubuntu. The version it gets you went end-of-life in 2024, and its explanation of authentication had one word wrong from the start.

• USING HASH Silently Becomes a B-Tree on InnoDB

  8 Sep, 2026

  I checked a write-up on MySQL/MariaDB index creation and EXPLAIN against the manuals. The hash index recipe doesn't work on InnoDB, and four of the EXPLAIN column descriptions are wrong.