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.
Recursive CTEs, explained from first principles
sophiemwangi profile

Recursive CTEs, explained from first principles

#sql #cte #dataengineering #datascience
3
Comments 2
5 min read
Database Indexing Explained: How Indexes Make SQL Queries Faster
siddhu_kumar_fd7a80402b7e profile

Database Indexing Explained: How Indexes Make SQL Queries Faster

#backend #database #performance #sql
1
Comments
7 min read
The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems
amasen profile

The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems

#sql #postgres #distributedsystems #architecture
Comments
3 min read
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
arpitmbangre profile

SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

#sql #database #dataengineering #beginners
Comments
2 min read
How to return top-N from each group with GROUP_CONCAT()
sanikolaev profile

How to return top-N from each group with GROUP_CONCAT()

#database #sql #opensource #tutorial
Comments
6 min read
Three ways your dashboard can be correct and still lie
sprettball profile

Three ways your dashboard can be correct and still lie

#data #sql #webdev #analytics
Comments
3 min read
SQLazy: Get the Latest Closed Before ConfirmationStarted
esproc_spl profile
Judy

SQLazy: Get the Latest Closed Before ConfirmationStarted

#backend #database #sql
5
Comments
3 min read
🚨 3 PostgreSQL Anti-Patterns That Are Silently Killing Your App's Performance
mindinu profile

🚨 3 PostgreSQL Anti-Patterns That Are Silently Killing Your App's Performance

#ai #webdev #productivity #sql
10
Comments
3 min read
How we put 16 database engines behind one result grid
yusufgundogdu profile

How we put 16 database engines behind one result grid

#database #opensource #sql #webdev
Comments
6 min read
When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots
dataio_4921 profile

When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots

#postgres #sql #ai #security
Comments
8 min read
Ranking a Two-Dimensional Catalog With One SQL Expression
citationbuilder profile

Ranking a Two-Dimensional Catalog With One SQL Expression

#sql #postgres #webdev #database
Comments
5 min read
SQL Basics: A Real-World Guide to Databases and Queries
harshitha_madhavarapu profile

SQL Basics: A Real-World Guide to Databases and Queries

#sql #database #beginners #tutorial
Comments
4 min read
SQL Starters
kalyanam_venumadhav_aaddf profile

SQL Starters

#sql #sqlserver #database #mysql
Comments
2 min read
What Is SQL Injection? How User Input Can Become a Database Command
aditya_d_sharma profile

What Is SQL Injection? How User Input Can Become a Database Command

#database #programming #security #sql
1
Comments
4 min read
Speeding Up a Slow PL/SQL Routine with BULK COLLECT and FORALL
zahid23saim profile

Speeding Up a Slow PL/SQL Routine with BULK COLLECT and FORALL

#database #performance #sql #tutorial
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.