Best of SQL — October 2025

  1. 1
    Article
    Avatar of colkgirlCode Like A Girl·30w

    Learning to Be Okay With Not Knowing Everything

    The data analytics field requires continuous learning rather than mastery of everything. Success comes from embracing curiosity over certainty, learning in layers rather than all at once, and focusing on relevant skills instead of chasing every trend. The imposter feeling is normal, and even experienced professionals regularly search for answers. Progress matters more than perfection, and being comfortable with not knowing everything is essential for sustainable growth in data careers.

  2. 2
    Article
    Avatar of elixirstatusElixirStatus·31w

    You Don't Need an ORM

    Explores an alternative approach to database access that embraces raw SQL instead of abstracting it away with ORMs. Introduces Squirrel, a library for Gleam that uses code generation from SQL queries to provide type-safety and good developer experience without sacrificing performance. Demonstrates how developers can write plain SQL while maintaining the benefits of static typing in functional languages, avoiding common ORM pitfalls like N+1 query problems.

  3. 3
    Article
    Avatar of jetbrainsJetBrains·34w

    DataGrip Is Now Free for Non-Commercial Use

    JetBrains DataGrip, a cross-platform database IDE, is now free for non-commercial use including learning, hobby projects, open-source development, and content creation. The change follows similar moves for RustRover, CLion, Rider, WebStorm, and RubyMine. All commercial features remain available in the free version, including AI-powered code completion, multi-database support, and Git integration. Commercial users must still purchase licenses. The free license lasts one year with automatic renewal and requires anonymous telemetry sharing.

  4. 4
    Article
    Avatar of gnjkg5k0npw7asw1zhhu6Suraj Shetty·29w

    Every Developer Should Know What Their DBA Knows

    A comprehensive roadmap covering essential PostgreSQL database administration knowledge that developers should understand. Topics include database fundamentals, PostgreSQL architecture, query optimization, indexing strategies, replication, backup and recovery, security, monitoring, and performance tuning. The guide bridges the gap between development and database administration, helping developers write better queries and understand database behavior.

  5. 5
    Article
    Avatar of milanjovanovicMilan Jovanović·29w

    What's New in EF Core 10: LeftJoin and RightJoin Operators in LINQ

    .NET 10 introduces native LeftJoin and RightJoin methods to LINQ, eliminating the verbose GroupJoin + DefaultIfEmpty pattern previously required for left/right joins in Entity Framework Core. The new methods provide clearer intent, less code, and identical SQL output while making outer joins as straightforward as other LINQ operations. Developers can now write joins that directly express their meaning, keeping all rows from one side while matching optional rows from the other.

  6. 6
    Video
    Avatar of codinggopherThe Coding Gopher·32w

    99% of Developers Don't Get PostgreSQL

    Deep dive into PostgreSQL's internal architecture, covering its ACID implementation, object-relational model, and storage mechanisms. Explains multi-version concurrency control (MVCC) for handling concurrent transactions without blocking, the TOAST system for managing oversized data, and write-ahead logging (WAL) for durability and crash recovery. Includes details on heap files, page organization, tuple versioning, vacuum processes, and checkpoint mechanisms that ensure data consistency and performance at scale.

  7. 7
    Article
    Avatar of collectionsCollections·32w

    Bun 1.3: Enhancing Full-Stack JavaScript Development

    Bun 1.3 introduces major enhancements transforming it into a comprehensive full-stack JavaScript runtime. Key features include a development server with hot module replacement, unified SQL API supporting multiple databases, built-in Redis client, and 100x reduction in idle CPU usage. The release adds cross-platform compilation to standalone executables, improved package management with security scanning, WebSocket compression, and enhanced testing with VS Code integration. Despite rapid growth to 5 million monthly downloads and some stability concerns, Bun positions itself as a production-ready Node.js alternative with significant performance and cost benefits.

  8. 8
    Article
    Avatar of freekFREEK.DEV·33w

    SQL performance improvements: analysing & fixing the slow queries (part 2)

    Learn how to optimize slow SQL queries using indexes in MySQL 8.0. The post covers how indexes work internally, demonstrates using the EXPLAIN keyword to analyze query execution plans, and shows the performance impact of different index configurations on query speed.

  9. 9
    Article
    Avatar of lonely_programmerLonely Programmer·31w

    SQL Insanity

See all SQL archives