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.
Building a Visitor Data Platform with Digital Membership Cards
rixcyshah profile
rixcy

Building a Visitor Data Platform with Digital Membership Cards

#database #sql #api #analytics
Comments
2 min read
Building a Zero-Budget Eval Harness for LLM-Assisted SQL Generation
dataio_4921 profile

Building a Zero-Budget Eval Harness for LLM-Assisted SQL Generation

#dataengineering #ai #sql #testing
Comments
5 min read
The Text-to-SQL Accuracy Cliff: Why Deterministic Compilers Beat LLM Guessing
harshit_colrows profile

The Text-to-SQL Accuracy Cliff: Why Deterministic Compilers Beat LLM Guessing

#ai #sql #llm #database
Comments
2 min read
You Cannot Tell Which of Your ERD Files Are Under Version Control
tbson87 profile

You Cannot Tell Which of Your ERD Files Are Under Version Control

#database #git #sql #tooling
Comments
5 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
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
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.