Daily Edition · Page 5

THE DAILY INDEX

Technology, AI, software, security, crypto and business

ARTICLES & TUTORIALS

TLDR Dev

UNCONVENTIONAL POSTGRESQL OPTIMIZATIONS

This article goes over some unconventional PostgreSQL optimization techniques that go beyond standard practices like simple indexing. One method involves enabling `constraint_exclusion` to remove unnecessary full table scans when queries contradict existing check constraints. Another technique optimizes for lower cardinality by creating function-based indexes (e.g., on just the date part of a timestamp), which are made consistently usable and efficient with virtual generated columns.

RUNNING CLAUDE CODE DANGEROUSLY (SAFELY)

The author wanted to use Claude Code with the `--dangerously-skip-permissions` flag for an improved workflow, but needed a safe, isolated environment to prevent accidental damage to their host system. They initially considered Docker, but issues like Docker-in-Docker requiring privileged mode made it unsuitable for true sandboxing. They chose Vagrant to create a disposable virtual machine, which offers full isolation and a reproducible configuration.

TLDR IndexPage 5