DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Killing Deadlocks Before They Form: Wait-Die vs Wound-Wait Schemes
binarydose profile

Killing Deadlocks Before They Form: Wait-Die vs Wound-Wait Schemes

#dbms #database #systemdesign #sql
Comments
2 min read
SQLAlchemy MissingGreenlet in Async Code: Fix Lazy Loading With selectinload, awaitable_attrs, or lazy="raise"
libme profile

SQLAlchemy MissingGreenlet in Async Code: Fix Lazy Loading With selectinload, awaitable_attrs, or lazy="raise"

#python #database #sql #backend
Comments
5 min read
BigQuery MERGE Is Not a Uniqueness Constraint: A Replay-Safe Tutorial
saravanan_techx profile

BigQuery MERGE Is Not a Uniqueness Constraint: A Replay-Safe Tutorial

#sql #database
Comments
3 min read
A created_at-only cursor lost 587 rows, even with clock_timestamp() and microseconds
muhammad_adnan_61b78b9816 profile

A created_at-only cursor lost 587 rows, even with clock_timestamp() and microseconds

#postgres #sql #pagination #backend
Comments
3 min read
Stop Using OFFSET for Pagination: Keyset Pagination Is 10,000x Faster on Deep Pages
mzlipu profile

Stop Using OFFSET for Pagination: Keyset Pagination Is 10,000x Faster on Deep Pages

#sql #postgres #performance #webdev
Comments
3 min read
SQL injection in the WHERE clause: how to reach unreleased products (PortSwigger)
gh0stbloom profile

SQL injection in the WHERE clause: how to reach unreleased products (PortSwigger)

#cybersecurity #security #sql
Comments
2 min read
SQL Server Multiple Cascade Paths (Error 1785): Which Foreign Key Loses ON DELETE CASCADE, and What Replaces It
tbson87 profile

SQL Server Multiple Cascade Paths (Error 1785): Which Foreign Key Loses ON DELETE CASCADE, and What Replaces It

#sqlserver #database #sql #dotnet
Comments
11 min read
5 Reasons Your SQL Index Is Being Ignored (and How to Fix Them)
mzlipu profile

5 Reasons Your SQL Index Is Being Ignored (and How to Fix Them)

#sql #database #performance #webdev
Comments
3 min read
4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)
mzlipu profile

4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)

#sql #postgres #database #beginners
Comments
3 min read
SQL Challenge: Can You Build a Customer Report Using JOIN, GROUP BY and CASE WHEN?
kailas_warade_d2a15d1ef8a profile

SQL Challenge: Can You Build a Customer Report Using JOIN, GROUP BY and CASE WHEN?

#database #sql #tutorial
Comments
2 min read
SQL Window Functions in 5 Minutes: ROW_NUMBER, RANK, Running Totals, Top N
mzlipu profile

SQL Window Functions in 5 Minutes: ROW_NUMBER, RANK, Running Totals, Top N

#sql #database #beginners #tutorial
Comments
3 min read
First Record with a Specific Value Within Each Group
esproc_spl profile
Judy

First Record with a Specific Value Within Each Group

#algorithms #database #programming #sql
6
Comments
4 min read
PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀
deepika_pusala profile

PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

#database #performance #postgres #sql
Comments
17 min read
SQL Server Index Tuning for Beginners: A Practical Guide
lingamsuyambu profile

SQL Server Index Tuning for Beginners: A Practical Guide

#sql #sqlserver #database #performance
Comments
4 min read
How to Convert Shopify Product CSV Exports into Clean SQL Statements
maazulhaq profile

How to Convert Shopify Product CSV Exports into Clean SQL Statements

#shopify #sql #databasemigration #datacleaning
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.