The 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. Read more ...

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. Read more ....

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. Read more ....

SQL Tips

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


                            SELECT c.id, c.name FROM customers c 
                            WHERE 
                            NOT EXISTS ( SELECT 1 FROM orders o WHERE o.customer_id = c.id );

⚠️ 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;

Words of Wisdom

The best way to predict the future is to invent it. — Alan Kay