Best of SQL — November 2023

1. 1
   Article

   Community Picks·2y

   SQL Formatter

   A tool called SQL Formatter that helps developers format SQL code for readability and consistency.

   200

   9
2. 2
   Article

   Towards Dev·2y

   CRUD Operations In SQL Database

   Learn about CRUD operations in SQL, which stands for Create, Read, Update, and Delete. Understand how to apply these operations and their importance in managing data effectively in relational databases.

   47

   1
3. 3
   Article

   Community Picks·3y

   Your database skills are not 'good to have'

   The article discusses the importance of having strong database skills and highlights common mistakes made when using databases and ORMs. It also provides insights into anti-patterns to avoid when working with databases.

   27
4. 4
   Article

   Community Picks·2y

   Comparing database/sql, GORM, sqlx, and sqlc

   This article compares the database/sql package with 3 other Go packages, namely sqlx, sqlc, and GORM. It explores the features, ease of use, and performance/speed of each package.

   24
5. 5
   Article

   Community Picks·3y

   Why Is It Hard to Horizontally Scale SQL Databases?

   Scaling SQL databases horizontally is a complex task due to challenges such as maintaining ACID properties across distributed systems, handling distributed joins, managing transactions across shards, ensuring data consistency, selecting appropriate sharding strategies, and enforcing data integrity. Various strategies, including partitioning and federated databases, application-level sharding, consistent hashing, database middleware, denormalization, polyglot persistence, and geo-partitioning, can be used to mitigate these challenges. It is crucial for system designers to understand the trade-offs and choose the right strategies to design scalable SQL database systems.

   22
6. 6
   Article

   Code Like A Girl·3y

   SQL’s Order of Execution

   Understanding the order of execution in SQL queries is crucial for optimizing performance and obtaining accurate results. The logical order of execution includes clauses like FROM, WHERE, GROUP BY, SELECT, and ORDER BY, while the physical order can be influenced by indexing, query optimization, and storage structures. Subqueries can be integrated into the SQL execution flow and impact query processing. Different databases may have variations in the execution order due to optimization strategies. When writing efficient SQL queries, consider factors like indexing, limiting the use of SELECT *, and optimizing JOIN operations. The database engine can change the order of execution through query optimization, utilizing techniques like cost-based optimization, index usage, and parallel processing. Troubleshooting issues related to the execution order involves understanding the logical flow, examining the query execution plan, checking index usage, profiling the query, and optimizing conditions in the WHERE clause.

   13
7. 7
   Article

   System Weakness·3y

   Protecting Your C# Entity Framework Application from SQL Injection

   Learn how to protect your C# Entity Framework application from SQL injection attacks by using parameterized queries, the Entity Framework Core setup, and proper input sanitization.

   10