Explaining The Postgres Meme (76 minute read)
This article analyzes the SQL Iceberg meme, which shows increasingly complex or advanced SQL commands or operations. The article goes through each of the zones and explains every concept. It starts with simple commands like CREATE TABLE, JOIN, and NULL and moves into intermediate and advanced topics like connection pools, denormalization, the volcano models, and the Halloween problem.
Biome (GitHub Repo)
Biome can format and lint JavaScript, TypeScript, JSON, and CSS code in a fraction of a second. It requires minimal configuration and displays detailed and contextualized diagnostics. Biome is designed to eventually replace Babel, ESLint, webpack, Prettier, Jest, and more. It has first-class IDE support and top-notch error recovery.