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.
Pagination That Skips Rows Is an Off-by-One in the Data Model
_66d02d0cc1ece7d1137c5f profile

Pagination That Skips Rows Is an Off-by-One in the Data Model

#postgres #sql #api #backend
Comments
3 min read
Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL
anusha_renangi_05a4e41d35 profile

Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

#database #performance #postgres #sql
Comments
6 min read
Why SyteLine Says "Row Has Been Modified by Another User" (and How Optimistic Concurrency Works)
al_hasibtamim_7a98724a4e profile

Why SyteLine Says "Row Has Been Modified by Another User" (and How Optimistic Concurrency Works)

#sql #database #architecture #enterprise
Comments
3 min read
Reylo types .sql files by asking your database. I tried to fool it five ways.
frankchu profile

Reylo types .sql files by asking your database. I tried to fool it five ways.

#backend #database #sql #typescript
Comments
5 min read
SQL WINDOW FUNCTIONS, JOINS, CTES AND SUBQUERRIES.
karianjahi profile

SQL WINDOW FUNCTIONS, JOINS, CTES AND SUBQUERRIES.

#sql #data #database #ai
1
Comments
11 min read
Why Your SQL Query Returns the Wrong Rows (And How WHERE and ORDER BY Fix It)
kailas_warade_d2a15d1ef8a profile

Why Your SQL Query Returns the Wrong Rows (And How WHERE and ORDER BY Fix It)

#sql #database #sqlserver #interview
1
Comments
6 min read
Sentry and Mandrill Both Went Down When Postgres Ran Out of Transaction IDs
gabrielanhaia profile

Sentry and Mandrill Both Went Down When Postgres Ran Out of Transaction IDs

#postgres #database #sql #devops
1
Comments
9 min read
Why Databases Use B+ Trees Instead of BSTs
binarydose profile

Why Databases Use B+ Trees Instead of BSTs

#database #sql #performance #backend
Comments
1 min read
Composite Indexes in PostgreSQL & MySQL: Column Order Guide
muhammadalimughal profile

Composite Indexes in PostgreSQL & MySQL: Column Order Guide

#database #postgres #sql #backend
Comments
7 min read
Your lowest-rated product list may contain highly rated items
dataspryva profile

Your lowest-rated product list may contain highly rated items

#datascience #python #sql #analytics
1
Comments 1
6 min read
SQL: Find the Customers Who Stopped Ordering With a LEFT JOIN (and Why a Plain JOIN Hides the One You Most Need to Call)
robert_breen_d96e41ecd765 profile

SQL: Find the Customers Who Stopped Ordering With a LEFT JOIN (and Why a Plain JOIN Hides the One You Most Need to Call)

#sql #beginners #database #productivity
Comments
4 min read
Why We Need Databases
fj_palacios profile

Why We Need Databases

#sql #database #beginners #tutorial
Comments
8 min read
SQL: The Monthly Revenue Report in Five Lines (GROUP BY Month Instead of a Spreadsheet Every Month-End)
robert_breen_d96e41ecd765 profile

SQL: The Monthly Revenue Report in Five Lines (GROUP BY Month Instead of a Spreadsheet Every Month-End)

#sql #beginners #database #productivity
Comments
3 min read
Adding a Razor Page with Entity Framework Core to an ASP.NET Core Project
karenpayneoregon profile

Adding a Razor Page with Entity Framework Core to an ASP.NET Core Project

#database #sql #tutorial #dotnetcore
Comments
5 min read
Your Postgres Get-or-Create Has a Race. Postgres 19's ON CONFLICT DO SELECT Closes It
gabrielanhaia profile

Your Postgres Get-or-Create Has a Race. Postgres 19's ON CONFLICT DO SELECT Closes It

#postgres #sql #database #backend
5
Comments 1
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.