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.
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
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
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
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
Normalize It, Then Break It On Purpose: 3NF to Star Schema, Explained Through Food Delivery
nbaubek profile

Normalize It, Then Break It On Purpose: 3NF to Star Schema, Explained Through Food Delivery

#dataengineering #sql #datamodeling
Comments 2
10 min read
How Do SQL Database Engines Work?
ishimwe_charles_9a4461252 profile

How Do SQL Database Engines Work?

#sql #database
Comments
6 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
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
interlace.sh: Why We Built a Unified Abstraction
5c4989ca297ed profile

interlace.sh: Why We Built a Unified Abstraction

#data #opensource #python #sql
Comments
5 min read
Teradata, Explained Like the Warehouse That Was There First
ramkumar-m-n profile

Teradata, Explained Like the Warehouse That Was There First

#datawarehouse #dataengineering #sql #database
7
Comments
6 min read
Don't put an LLM in charge of your production database
aniketsoni profile

Don't put an LLM in charge of your production database

#sql #llm #data #platform
1
Comments
5 min read
Postgres earthdistance
dshumw profile

Postgres earthdistance

#database #postgres #sql
Comments
1 min read
SQL JOIN Practice: From Basic to Advanced — 39 Real-World Queries with Solutions
dev_saravanan_journey profile

SQL JOIN Practice: From Basic to Advanced — 39 Real-World Queries with Solutions

#sql #database #webdev #beginners
6
Comments
15 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.