Environment variables are how applications receive configuration like database passwords and API keys. The article explains that .env files don't automatically work—apps read from their environment, not files—requiring a loader like dotenv. Misunderstanding this has led to widespread security problems including credential sprawl across laptops, messaging apps, and CI systems.
This article lists common PostgreSQL mistakes to avoid, including using SQL_ASCII encoding, the psql -W password flag, rules, table inheritance, and NOT IN SQL constructs. Each mistake includes explanations of why it's problematic and when (if ever) it might be appropriate, with recommendations for better alternatives like triggers, foreign keys, and NOT EXISTS.
A Hacker News user asks the community to share their AI workflows and best practices for integrating AI assistants like Claude into daily engineering tasks, seeking to understand current standards and separate effective approaches from hype.
A guide explaining why well-crafted Git commit messages matter for code maintainability and developer collaboration. Good commit messages provide context about changes that diffs alone cannot convey, enabling efficient code review and historical understanding across a project's lifetime.
GitHub's wiki feature is considered an anti-pattern for documentation compared to using a /docs folder in the repository. While wikis offer single-click access, docs folders provide versioning alongside code, local availability, peer review via pull requests, and better tooling support. The recommended approach is storing docs in a /docs folder with GitHub Pages for publishing.