--- title: Best Web Dev Cody posts — July 2025 | daily.dev description: The most upvoted Web Dev Cody posts from July 2025, curated by the daily.dev community. canonical: https://daily.dev/sources/webdevcody/best-of/2025/07 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/webdevcody/best-of/2025/07 og:type: website og:site_name: daily.dev og:title: Best Web Dev Cody posts — July 2025 | daily.dev og:description: The most upvoted Web Dev Cody posts from July 2025, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of Web Dev Cody — July 2025 1. 1 [](https://daily.dev/posts/how-to-find-performance-issues-in-sql-query-4ggqal9m9 "How to find performance issues in SQL query") Video Web Dev Cody·1y How to find performance issues in SQL query A practical guide to identifying and fixing SQL query performance issues using the EXPLAIN command and database indexing. The tutorial demonstrates how to analyze a complex query with multiple joins and subqueries, use AI tools to interpret query execution plans, and implement indexes to dramatically reduce query costs from 10,000 to 29\. Key techniques include enabling ORM logging to capture raw SQL, using database tools to run EXPLAIN statements, and strategically adding indexes on foreign keys and frequently queried columns. 21 2. 2 [](https://daily.dev/posts/things-you-might-learn-as-a-web-developer-odio2xjnl "Things you might learn as a web developer") Video Web Dev Cody·1y Things you might learn as a web developer A comprehensive overview of the web development learning journey, covering frontend fundamentals (HTML, CSS, JavaScript), backend technologies (Node.js, databases, APIs), DevOps practices (CI/CD, Docker, cloud services), and essential skills like version control, testing, security, and project management. The content maps out the progression from building simple static sites to complex full-stack applications with proper deployment pipelines. 13 1 3. 3 [](https://daily.dev/posts/trying-out-better-auth-for-the-first-time-ajj8hi44x "Trying out Better-Auth for the first time") Video Web Dev Cody·1y Trying out Better-Auth for the first time A developer explores Better-Auth for the first time, setting up authentication in a TanStack Start project with Google OAuth. The tutorial covers installation, database configuration with SQLite, creating authentication routes, and implementing sign-in/sign-out functionality. The setup process reveals Better-Auth uses database sessions with signed tokens stored in cookies, and the developer compares it favorably to alternatives like NextAuth.js and Oslo/Arctic. 10 [See all Web Dev Cody archives](/sources/webdevcody/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/webdevcody/best-of/2025/07#page","url":"https://daily.dev/sources/webdevcody/best-of/2025/07","name":"Best Web Dev Cody Posts — July 2025","description":"The most upvoted Web Dev Cody posts from July 2025, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/webdevcody/best-of/2025/07#items","numberOfItems":3,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/how-to-find-performance-issues-in-sql-query-4ggqal9m9","name":"How to find performance issues in SQL query"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/things-you-might-learn-as-a-web-developer-odio2xjnl","name":"Things you might learn as a web developer"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/trying-out-better-auth-for-the-first-time-ajj8hi44x","name":"Trying out Better-Auth for the first time"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"Web Dev Cody","item":"https://daily.dev/sources/webdevcody"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/webdevcody/best-of"},{"@type":"ListItem","position":5,"name":"July 2025"}]}]} ```