Best of SQL — March 2024

1. 1
   Video

   Community Picks·2y

   Stop using COUNT(id) to count rows

   Counting rows using COUNT(*) in MySQL is not slow as often believed. It is actually optimized to be the fastest way to count rows.

   790

   27
2. 2
   Article

   Community Picks·2y

   10 Cool SQL Optimisations That do not Depend on the Cost Model

   The post evaluates 10 SQL optimizations that do not depend on the cost model. It discusses the applications and support for transitive closure, removing 'silly' predicates, JOIN elimination, provably empty sets, and more.

   125

   1
3. 3
   Article

   Community Picks·2y

   Learn SQL for Free

   Learn SQL for free and unlock the power of data with SQL basics. This comprehensive tutorial will equip you with the fundamental SQL skills needed to thrive in today's data-driven world.

   72
4. 4
   Video

   Theo - t3․gg·2y

   I Suck At SQL, Now My DB Tells Me How To Fix It

   Planet Scale introduces schema recommendations, a new feature that helps improve database performance by providing tailored recommendations based on production database traffic. The recommendations include adding indexes for inefficient queries, removing redundant indexes, preventing primary key ID exhaustion, and dropping unused tables.

   44

   5
5. 5
   Article

   Awesome Go·2y

   Preventing SQL Injection with Golang

   This post discusses the concept of SQL injection and how to prevent it in Go. It explains the vulnerabilities associated with SQL injection and demonstrates ways to fix them using prepared statements and parameterized queries.

   34

   2
6. 6
   Article

   Laravel News·2y

   Easily create complex database queries with the Query Enrich Package

   Laravel Query Enrich simplifies the creation of complex database queries in Laravel. It provides examples of fetching orders placed in the last 7 days, using the avg function for grabbing average monthly prices for oil and gas, using exists queries, and getting a full name using concatws. The complete documentation and Github repository for the Query Enrich Package can be found.

   33
7. 7
   Article

   KDnuggets·2y

   A Free Data Science Learning Roadmap: For All Levels with IBM

   Learn data science according to your expertise with 4 different learning roadmaps. Start from the introduction level and progress to advanced data science courses.

   31
8. 8
   Article

   Vlad Mihalcea·2y

   PostgreSQL Index Types

   This post explores PostgreSQL index types, including B+Tree, Hash, and GIN indexes. It discusses the benefits of using B+Tree indexes for filtering, range scans, and sorting. It explains how Hash indexes are useful for equality checks and saving space. It also explains how GIN indexes can speed up JSON-specific operations. The post concludes by mentioning other index types available in PostgreSQL.

   30
9. 9
   Video

   Community Picks·2y

   Prisma in 100 Seconds

   Prisma is an open source tool that provides a modern and safe way to work with databases. It allows you to write a schema to express your data and relationships, performs typesafe CRUD operations, handles migrations, and offers a convenient way to view and manage your data in the browser.

   28
10. 10
    Article

    AWS in Plain English·2y

    Understanding Database Indexing

    Database indexing is used to facilitate faster data retrieval by creating a separate data structure that contains pointers or references to the actual data in a table. Indexing helps optimize disk operations and improve search performance in databases. There are different types of indexing, such as B-tree indexing and LSM tree indexing. The sequence of columns in a composite index is important for efficient searching. Certain considerations should be made when using indexes in queries.

    25

    1
11. 11
    Article

    gitconnected·2y

    SQL Series: Preparing a Database Step by Step

    This post discusses the process of preparing a database step by step for SQL learning, using a dataset related to sanitary inspections on cruise ships. It provides an overview of the dataset, instructions for creating a schema in MySQL Workbench, and guidance on loading data into the database.

    21
12. 12
    Article

    KDnuggets·2y

    Collection of Guides on Mastering SQL, Python, Data Cleaning, Data Wrangling, and Exploratory Data Analysis

    Collection of guides for mastering SQL, Python, data cleaning, data wrangling, and exploratory data analysis. Start with SQL, then move on to Python and essential techniques like data cleaning. Gain expertise in data wrangling and master exploratory data analysis to uncover insights.

    18
13. 13
    Article

    Lobsters·2y

    DuckDB as the New jq

    DuckDB is a database project similar to SQLite that has native support for reading and parsing JSON data without extra dependencies. It provides a simpler and more familiar SQL syntax compared to the powerful but complex syntax of jq.

    15

    1
14. 14
    Article

    Supabase·2y

    PostgREST Aggregate Functions

    PostgREST v12 has released aggregate functions, which allow users to summarize data by performing calculations across groups of rows. These functions can be used directly through the PostgREST API, making data manipulation easier. Users can also use aggregate functions in conjunction with embedded resources to perform complex calculations. However, it is important to use aggregate functions safely to prevent potential performance issues.

    15
15. 15
    Article

    The New Stack·2y

    How to Write SQL Queries

    SQL is a declarative language used for querying, analyzing, and manipulating data. It uses different elements like SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, OFFSET, and FETCH to retrieve and analyze data. SQL queries can be used to join tables, filter rows, aggregate data, and sort results. The GROUP BY clause is used to group rows with common values and the HAVING clause is used to filter the grouped rows based on a condition.

    14

    1
16. 16
    Article

    Hacker News·2y

    incentius-foss/WhatTheDuck: WhatTheDuck is an open-source web application built on DuckDB. It allows users to upload CSV files, store them in tables, and perform SQL queries on the data.

    WhatTheDuck is an open-source web application built on DuckDB. It allows users to upload CSV files, store them in tables, and perform SQL queries on the data.

    14

    1