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.
Demystifying Vector Distance in PostgreSQL
rpi1337 profile

Demystifying Vector Distance in PostgreSQL

#algorithms #database #postgres #sql
1
Comments
2 min read
Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)
systemcraftdev profile

Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)

#sql #database #tutorial #beginners
Comments 2
3 min read
Query Optimization in IFS: The Hidden Performance Killer
saikat_bose_a5751ba13208b profile

Query Optimization in IFS: The Hidden Performance Killer

#database #debugging #performance #sql
Comments
5 min read
String#squish Quietly Changed My SQL
jessalejo profile

String#squish Quietly Changed My SQL

#rails #sql
Comments
4 min read
interlace.sh: Sandboxes That Cost Nothing
5c4989ca297ed profile

interlace.sh: Sandboxes That Cost Nothing

#sql #opensource #data #python
Comments 1
4 min read
My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀
omargamal_data1 profile

My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀

#sql #database #githubcopilot #beginners
Comments
1 min read
Stop the Schema Chaos: A Workflow Guide for Healthcare Data Architects
season_mudbhary_7856e4083 profile

Stop the Schema Chaos: A Workflow Guide for Healthcare Data Architects

#dataengineering #architecture #healthcare #sql
Comments
3 min read
Epic Clarity Data Model Guide for Healthcare Data Engineers
season_mudbhary_7856e4083 profile

Epic Clarity Data Model Guide for Healthcare Data Engineers

#database #dataengineering #sql #tutorial
Comments
5 min read
Database Isolation Levels & Read Phenomena: An Extensive Deep Dive
urvish_shah profile

Database Isolation Levels & Read Phenomena: An Extensive Deep Dive

#backend #database #sql
3
Comments 1
12 min read
Your agent's memory is a vector store. Ask it "how many" and watch it fall over.
omer_hochman profile

Your agent's memory is a vector store. Ask it "how many" and watch it fall over.

#ai #database #postgres #sql
Comments 1
2 min read
Why Schema-Aware Query Generation Beats Generic AI Templates for Production Databases
maskdatabases profile

Why Schema-Aware Query Generation Beats Generic AI Templates for Production Databases

#database #sql #node #typescript
Comments
3 min read
🌐 Building a Lead Generation Website with Modern .NET and Azure SQL
printo_tom profile

🌐 Building a Lead Generation Website with Modern .NET and Azure SQL

#dotnet #azure #sql #leadgeneration
Comments
2 min read
SQL Window Functions: How to Get the Top Row Per Group
michaelnocito profile

SQL Window Functions: How to Get the Top Row Per Group

#sql #database #tutorial #beginners
Comments
16 min read
Normalization vs. Denormalization: Choosing the Right Database Design for Performance
sudoruss profile

Normalization vs. Denormalization: Choosing the Right Database Design for Performance

#database #performance #sql #systemdesign
Comments
3 min read
SQL Foundations, Start to Finish
michaelnocito profile

SQL Foundations, Start to Finish

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