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.
PostgreSQL INCLUDE indexes: what problem are they trying to solve?

Clarifies pre-v11 covering index capabilities
franckpachot profile

PostgreSQL INCLUDE indexes: what problem are they trying to solve?

#postgres #sql #database #index
12
Picked as gem Comments 7
10 min read
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
Subqueries & CTEs
emilio_ochieng_632030149c profile

Subqueries & CTEs

#database #sql
1
Comments
3 min read
SQL vs. NoSQL — stop asking the wrong question
vladut02 profile
VLAD

SQL vs. NoSQL — stop asking the wrong question

#sql #nosql #database #mongodb
2
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 Taught Me That There Is Always an Easier Way to Do Things
josephine_mackylah_d6b31f profile

SQL Taught Me That There Is Always an Easier Way to Do Things

#basic #sql #analytics #luxdev
4
Comments 2
5 min read
Building a Sales Analytics Data Warehouse with PostgreSQL
otasium profile

Building a Sales Analytics Data Warehouse with PostgreSQL

#analytics #data #database #sql
Comments
3 min read
We Replaced 3 Microservices With One Postgres Table
infoinlet1 profile

We Replaced 3 Microservices With One Postgres Table

#postgres #architecture #backend #sql
11
Comments 1
7 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
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
interlace.sh: A Macro Is an Expression, Not a Template
5c4989ca297ed profile

interlace.sh: A Macro Is an Expression, Not a Template

#sql #python #opensource
Comments
6 min read
Twenty-Five Million Rows in Five Seconds, and How to Check
5c4989ca297ed profile

Twenty-Five Million Rows in Five Seconds, and How to Check

#opensource #sql #python #data
Comments
5 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
Migrating jaffle_shop: A Real dbt Project, End to End
5c4989ca297ed profile

Migrating jaffle_shop: A Real dbt Project, End to End

#sql #opensource #python #data
Comments
8 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.