Codeminer42's Engineering Blog

SQL

  • Mastering Derived Tables in Rails

    · 7 min read · by Anderson Guimarães Moura

    Hey fellow Rails developers! Ever found yourself wrestling with complex SQL queries that involve aggregations, subqueries, or needing to join against computed results? Today, we're diving into one of the…

  • Powering Your Database Queries with a LLMs and MCPs

    · 11 min read · by Gabriel Quaresma

    Today, we live in an era where we increasingly encounter AIs of various types and uses in our lives, whether due to hype or not, such as the well-known ChatGPT,…

  • Codeminer42 Dev Weekly #78

    · 3 min read · by Gabriel Quaresma

    HELLO EVERYONE!!! It’s September 12th 2025 and you are reading the 78th edition of the Codeminer42’s tech news report. Let’s check out what the tech world showed us this week!…

  • Codeminer42 Dev Weekly #64

    · 6 min read · by Gabriel Quaresma

    HELLO EVERYONE!!! It’s June 6th, 2025, and you are reading the 64th edition of Codeminer42’s tech news report. Let’s check out what the tech world showed us this week! Track…

  • Introduction to Relational Databases and SQL

    · 23 min read · by Jonathan Ribeiro

    Hi! I hope you’re enjoying The Miners' Guide to Code Crafting series. Today, we’re diving into databases — one of the most essential tools in web development. Keep in mind…