Best of SQL — February 2025

  1. 1
    Video
    Avatar of bytegradByteGrad·1y

    SQL Tutorial - All 38 Concepts You Need To Know

    SQL is a structured query language used to manage and analyze data in databases. Understanding SQL concepts is valuable for both organizations and individual careers. Key SQL concepts include creating and managing databases, tables, and relationships, as well as performing queries to insert, update, delete, and retrieve data. Proper data structuring, using primary and foreign keys, and employing joins are essential for database efficiency. Indexing can optimize queries, and using transactions ensures data consistency. Tools and certifications like those offered by DataCamp can enhance SQL skills.

  2. 2
    Article
    Avatar of systemdesigncodexSystem Design Codex·1y

    Your Code is Fast, But Your Database is Slow—Now What?

    If your application is slow despite optimized code, the database might be the bottleneck. This issue often arises because database operations like disk access and network calls are slower than in-memory processes. To address this, you must identify bottlenecks using methods like query profiling and monitoring key performance metrics. Optimize queries by adding indexes, avoiding SELECT *, and using joins instead of nested queries. Also consider architectural optimizations such as caching, connection pooling, materialized views, sharding, and read replicas to improve performance and scalability.

  3. 3
    Article
    Avatar of bunBun·1y

    Bun v1.2.3

    Bun v1.2.3 introduces a full-featured frontend development toolchain with fast hot reloading and bundling. It enhances Bun.serve() with built-in routing and dynamic path parameters, simplifies frontend-backend integration, and improves Node.js compatibility. Notable updates include Bun.SQL improvements, faster WebAssembly startup, streamlined CSS handling, and optimizations in memory usage for file streams. Bug fixes and enhancements cover various aspects like SQL queries, environment variables in HTML imports, and error handling improvements.

  4. 4
    Article
    Avatar of cyber_secCyber Security·1y

    SQLZoo - learn SQL online

    SQLZoo offers a free online tutorial for learning SQL with a built-in SQL client. It supports MySQL, PostgreSQL, Microsoft SQL, and MariaDB databases.

  5. 5
    Article
    Avatar of bytebytegoByteByteGo·1y

    How Google Spanner Powers Trillions of Rows with 5 Nines Availability

    Google Spanner is a globally distributed, strongly consistent, and highly available database system developed by Google. It combines SQL-based queries with the scalability of NoSQL, ideal for modern high-demand applications. Key features include synchronous replication for data durability, the use of TrueTime for accurate global timestamps, and dynamic sharding for load balancing. Spanner leverages Paxos for managing replication across multiple zones and ensures availability and consistency even during failures. The TrueTime API, using atomic and GPS clocks, provides precise time synchronization crucial for maintaining global consistency.

See all SQL archives