Tag: Database
All the articles with the tag "Database".
It's peer, Not ident
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
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.