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.
Best Snowflake Data Modeling Tools: SQLDBM, Hackolade, erwin & Vertabelo for Reverse Engineering and DDL Generation
joonsystems profile

Best Snowflake Data Modeling Tools: SQLDBM, Hackolade, erwin & Vertabelo for Reverse Engineering and DDL Generation

#data #database #sql #tools
Comments
10 min read
A for Athena
amutha_nila profile

A for Athena

#aws #cloud #learning #sql
Comments
6 min read
Read your SQL back as one sentence before you run it
selene_nyx_ai profile

Read your SQL back as one sentence before you run it

#sql #database #postgres #mysql
Comments
6 min read
Is SQLazy Something Missing from Your dbt Workflow?
esproc_spl profile
Judy

Is SQLazy Something Missing from Your dbt Workflow?

#analytics #dataengineering #sql
5
Comments
6 min read
Solving the Classic SQL "Gaps and Islands" Problem: 3 Modern Approaches
rahmanfrr profile

Solving the Classic SQL "Gaps and Islands" Problem: 3 Modern Approaches

#sql #database #tutorial #programming
Comments 2
5 min read
I built a fake 30-year company for a more realistic Postgres sample database
ukhype1983_a92e7968657284 profile

I built a fake 30-year company for a more realistic Postgres sample database

#showdev #postgres #sql #database
Comments
3 min read
Vanna is archived. The failure mode none of the replacements fix.
ashish_sinha_5241c7673d93 profile

Vanna is archived. The failure mode none of the replacements fix.

#sql #ai #database #python
Comments
4 min read
SQL JOINS Explained
sguantai profile

SQL JOINS Explained

#beginners #database #sql #tutorial
Comments
3 min read
「先頭カラムが同じインデックス、それ1つ無駄ちゃう？」— 冗長インデックスの見つけ方と消し方
kaziusan profile

「先頭カラムが同じインデックス、それ1つ無駄ちゃう？」— 冗長インデックスの見つけ方と消し方

#sql #rails
Comments
1 min read
Stop Sending Every SQL Query to Your Most Expensive Model — Build a Router Instead
davidmurray profile

Stop Sending Every SQL Query to Your Most Expensive Model — Build a Router Instead

#ai #database #sql #architecture
2
Comments 1
4 min read
Building Answer Lineage for Enterprise Data Agents
arisyndata profile

Building Answer Lineage for Enterprise Data Agents

#ai #data #llm #sql
Comments 1
5 min read
Railsのstructure.sqlって何？ 何のため?
kaziusan profile

Railsのstructure.sqlって何？ 何のため?

#rails #sql
Comments
1 min read
Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization (Part 1 of 3)
zgl20053779 profile

Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization (Part 1 of 3)

#datalineage #sql #bigdata #database
Comments
2 min read
Azure Virtual Desktop Architecture: How Azure SQL Fits into the Broader Azure Platform
lucasitpro profile

Azure Virtual Desktop Architecture: How Azure SQL Fits into the Broader Azure Platform

#architecture #azure #database #sql
Comments
5 min read
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17
aleksander_frolov profile

One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

#performance #postgres #mysql #sql
Comments 1
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.