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.
How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query
michaelnocito profile

How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

#sql #database #tutorial #beginners
Comments
9 min read
How an Employee Hierarchy Helped Me Understand Recursive CTEs
saamiabbaskhan profile

How an Employee Hierarchy Helped Me Understand Recursive CTEs

#sql #database #algorithms #programming
6
Comments 1
13 min read
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each
jonathan_kip profile

SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each

#sql #datascience #beginners
2
Comments
4 min read
Dominando SQL para la Ciberseguridad: De la Selección Básica a la Detección de Amenazas
ce4vjpcode profile

Dominando SQL para la Ciberseguridad: De la Selección Básica a la Detección de Amenazas

#cybersecurity #database #sql
Comments
3 min read
Your text-to-SQL model isn't as wrong as your benchmark says. The gold SQL is.
omer_hochman profile

Your text-to-SQL model isn't as wrong as your benchmark says. The gold SQL is.

#sql #llm #ai
Comments 1
3 min read
How We Query 1.2 Billion Rows in Under 50ms — Partitioning, Columnstore, and Read Models at Scale
kirandeepjassalcrypto profile

How We Query 1.2 Billion Rows in Under 50ms — Partitioning, Columnstore, and Read Models at Scale

#sql #systemdesign #azure #dotnet
Comments
7 min read
Your text-to-SQL accuracy is measured on schemas your users will never build
omer_hochman profile

Your text-to-SQL accuracy is measured on schemas your users will never build

#sql #llm #ai
Comments 1
3 min read
How SQL Actually Works Under the Hood — A Deep Dive Into Snowflake and Redshift
maithreyan11 profile

How SQL Actually Works Under the Hood — A Deep Dive Into Snowflake and Redshift

#sql #dataengineering #snowflake #redshift
Comments
5 min read
DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits
tbson87 profile

DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits

#database #sql #tooling #programming
Comments
21 min read
PostgreSQL: A Beginner's Guide to Getting Started
adhi_sankar_45ccfb9350749 profile

PostgreSQL: A Beginner's Guide to Getting Started

#beginners #database #sql
1
Comments
2 min read
Reconstructing Wallet Journeys Across DEX Frontends, One Chain at a Time
andrewmaury profile

Reconstructing Wallet Journeys Across DEX Frontends, One Chain at a Time

#datascience #sql #blockchain #analytics
Comments
8 min read
Understanding and Solving the N+1 Problem in Spring Data JPA / Hibernate
programming_coyote profile

Understanding and Solving the N+1 Problem in Spring Data JPA / Hibernate

#sql #softwaredevelopment #database #java
Comments 2
4 min read
Why Senior Data Engineers Write SQL Differently
vfazal profile

Why Senior Data Engineers Write SQL Differently

#sql #database #dataengineering #data
1
Comments
8 min read
How I Stopped Recalculating the Same MAX(date) Subquery on Redshift
maithreyan11 profile

How I Stopped Recalculating the Same MAX(date) Subquery on Redshift

#redshift #sql #dataengineering #aws
Comments
4 min read
SQL vs NoSQL for Node.js Applications: A Practical Guide
synfinity-dynamics-pvt-ltd profile

SQL vs NoSQL for Node.js Applications: A Practical Guide

#sql #node #database #nosql
5
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.