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.
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 1
3 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
Two domains are 53% of the Databricks Data Engineer Associate exam
nicheelab profile

Two domains are 53% of the Databricks Data Engineer Associate exam

#databricks #dataengineering #certification #sql
Comments
4 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
No Jinja: What Replaces Templating When SQL Is an AST
5c4989ca297ed profile

No Jinja: What Replaces Templating When SQL Is an AST

#sql #opensource #python #algorithms
Comments
5 min read
Python Models: dbt and Interlace, Side by Side
5c4989ca297ed profile

Python Models: dbt and Interlace, Side by Side

#python #opensource #sql #dataengineering
Comments
4 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
interlace.sh: A Python Model Is Just a Function
5c4989ca297ed profile

interlace.sh: A Python Model Is Just a Function

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

interlace.sh: Sandboxes That Cost Nothing

#sql #opensource #data #python
Comments
4 min read
I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.
luishrqvf profile

I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

#reverseengineering #database #career #sql
Comments
4 min read
interlace.sh: The IR Is a sqlglot AST
5c4989ca297ed profile

interlace.sh: The IR Is a sqlglot AST

#sql #opensource #python #dataengineering
Comments
4 min read
Your acquisitions table needs a status field, not a boolean
corpdigest profile

Your acquisitions table needs a status field, not a boolean

#database #sql #datascience
Comments
2 min read
Schema Linting vs Migration Linting: Which Database Problems Each One Can See
tbson87 profile

Schema Linting vs Migration Linting: Which Database Problems Each One Can See

#database #sql #postgres #architecture
Comments
11 min read
A Free-Server Regression Job for LLM-Generated SQL
dataio_4921 profile

A Free-Server Regression Job for LLM-Generated SQL

#sql #testing #ai #devops
Comments
6 min read
For Structured Data, Retrieval Accuracy Isn't a Model Problem
melih_birim_8363f43966da2 profile

For Structured Data, Retrieval Accuracy Isn't a Model Problem

#ai #sql #csv #agents
Comments 2
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.