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.
You Forgot to Mention the 500 Million Rows
raghavsharma_ profile

You Forgot to Mention the 500 Million Rows

#ai #dataengineering #sql #performance
Comments
4 min read
Why CTE vs Subquery Matters More on Redshift Than Anywhere Else
maithreyan11 profile

Why CTE vs Subquery Matters More on Redshift Than Anywhere Else

#redshift #sql #dataengineering #aws
Comments
2 min read
SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算
caresodev profile
tine

SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算

#sql #database #mysql #tutorial
Comments
1 min read
Navigating views in oracle database
doreen970 profile

Navigating views in oracle database

#database #sql
1
Comments
2 min read
What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL
darshan_dev profile

What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL

#sql #database #programming #beginners
1
Comments
6 min read
SQL Patterns Hidden Inside Social Networks
meroline_lizlent profile

SQL Patterns Hidden Inside Social Networks

#architecture #backend #database #sql
1
Comments
4 min read
SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents
tbson87 profile

SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

#database #sqlserver #sql #documentation
Comments
6 min read
Fixing Enterprise HR Hierarchy Lookups Without Cache Invalidation Nightmares
shubhamshaw profile

Fixing Enterprise HR Hierarchy Lookups Without Cache Invalidation Nightmares

#database #softwareengineering #architecture #sql
Comments
1 min read
Database Views in Your ERD: Read-Only Entities, Not Fake Tables
tbson87 profile

Database Views in Your ERD: Read-Only Entities, Not Fake Tables

#database #sql #postgres #architecture
Comments 1
5 min read
How Do SQL Database Engines Work?
ishimwe_charles_9a4461252 profile

How Do SQL Database Engines Work?

#sql #database
Comments
6 min read
From SQL to Power BI: Building Your First Connected Dashboard
victak36lgtm profile

From SQL to Power BI: Building Your First Connected Dashboard

#beginners #database #sql #tutorial
3
Comments
5 min read
Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View
tbson87 profile

Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

#database #postgres #supabase #sql
Comments
6 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes
sanikolaev profile

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

#backend #database #search #sql
Comments
3 min read
Choose the Reporting Grain Before You Choose the Chart
datplan profile

Choose the Reporting Grain Before You Choose the Chart

#accounting #dataengineering #businessintelligence #sql
Comments 1
3 min read
Why GitHub Cannot Paginate Through Millions of Repositories - Deep Pagination Explained
mayank7924 profile

Why GitHub Cannot Paginate Through Millions of Repositories - Deep Pagination Explained

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