GreyNeurons Bookmark Dispatch #2

What happens when you combine Nmap’s raw scanning power with ChatGPT’s intelligence? Wazuh’s latest integration shows how to automate security auditing while getting context-rich insights on vulnerabilities—all without leaving your SIEM. If you’re into smarter threat detection, this one’s worth a read.

Why did Microsoft's TypeScript team choose Go over Rust or C# for their compiler rewrite? Discover how Go's native code compilation and garbage collection influenced this strategic decision, aiming to enhance performance and developer experience. The following Reddit commenter also summarizes this nicely.

In his article "Here's how I use LLMs to help me write code," Simon Willison shares his experiences and strategies for effectively utilizing large language models (LLMs) in software development. He emphasizes that while LLMs can significantly boost productivity, they require careful guidance and validation. Willison discusses setting realistic expectations, understanding the importance of context, and the necessity of thoroughly testing AI-generated code. He also highlights that LLMs serve as tools to amplify existing expertise rather than replace the need for human oversight and skill.

SQL Tip: Use NOT EXISTS Instead of LEFT JOIN + IS NULL for Anti-Joins

Tip: When filtering rows that do not have a match in another table, prefer NOT EXISTS over LEFT JOIN ... IS NULL It's usually faster and more readable.

✅ PostgreSQL Example

⚠️ What to Avoid (Less Efficient):

SELECT c.id, c.name FROM customers c LEFT JOIN orders o ON c.id = o.customer_id WHERE o.customer_id IS NULL; 

Quotable Quote

Originally published on Greyneurons