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.
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
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
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
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
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
iris-agentic-dev -- Give Your AI a Live Connection to IRIS, Part 1: The Problem, the Tool, and Getting Started
intersystemsdev profile

iris-agentic-dev -- Give Your AI a Live Connection to IRIS, Part 1: The Problem, the Tool, and Getting Started

#sql #ai #coding #tooling
Comments 1
8 min read
Choose the Reporting Grain Before You Choose the Chart
datplan profile

Choose the Reporting Grain Before You Choose the Chart

#accounting #dataengineering #businessintelligence #sql
Comments 1
3 min read
Postgres Array Column vs Junction Table: What Each One Does to Your ERD
tbson87 profile

Postgres Array Column vs Junction Table: What Each One Does to Your ERD

#database #postgres #sql #architecture
Comments 1
10 min read
Why GitHub Cannot Paginate Through Millions of Repositories - Deep Pagination Explained
mayank7924 profile

Why GitHub Cannot Paginate Through Millions of Repositories - Deep Pagination Explained

#database #programming #sql #backend
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.