Search Articles

Found 6 results for "SQL"

💻

💻Tech Skills

SQL Query Optimization: Indexes, Execution Plans & Performance (Complete Guide)

Master SQL optimization, use indexes correctly, read execution plans, speed up queries 4000x on 1M rows.

March 7, 20269 min read

#SQL#Database#Performance

🔮

🔮Vibe Coding

The Idiomatic Code Audit: Do AI Tools Write Modern Code?

Testing whether Claude Code, Codex CLI, and Gemini CLI produce modern, idiomatic, and secure code by default. Our experiments reveal a critical gap in library version awareness.

February 5, 202610 min read

#ai-coding#claude-code#codex-cli

💻

💻Tech Skills

JavaScript Template Literals: String Interpolation & Multiline Strings

Master JavaScript template literals for string interpolation and multiline strings. Includes tagged templates, examples, and best practices.

March 1, 202614 min read

#javascript#es6-features#strings

💻

💻Tech Skills

Pandas pd.concat(): Merge & Combine DataFrames (Complete Guide)

Complete guide to Pandas pd.concat() for combining DataFrames. Learn axis stacking, index handling, and comparisons with merge() and join().

March 1, 202615 min read

#pandas#data-analysis#dataframes

💻

💻Tech Skills

CrewAI Tools: Building Custom Agents & Tool Integration (Guide)

Complete guide to building tools for CrewAI agents. Learn @tool decorator, tool creation, built-in tools, and multi-agent workflows.

March 1, 202616 min read

#crewai#ai-agents#llm

🔮

🔮Vibe Coding

The Generative Core: Understanding Hallucination in Large Language Models

Hallucination isn't a bug in LLMs—it's the generative process itself. Understanding this changes how we should think about working with these tools.

January 6, 202610 min read

#LLM hallucination#AI generation#confabulation