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.
Fan-Out Joins: The Silent Cause of Inflated Metrics
vaishnavprabhu profile

Fan-Out Joins: The Silent Cause of Inflated Metrics

#dataengineering #sql #database #analytics
Comments 2
2 min read
Parser Gates or Runtime Guards: A Debate for Agent-Written SQL
dataio_4921 profile

Parser Gates or Runtime Guards: A Debate for Agent-Written SQL

#discuss #sql #postgres #ai
Comments 1
9 min read
Database Naming Conventions: A Practical Guide for Tables and Columns
sqemo profile

Database Naming Conventions: A Practical Guide for Tables and Columns

#database #sql #postgres #bestpractices
Comments
7 min read
One repository answered the same question twice on 11 September
mosiddi profile

One repository answered the same question twice on 11 September

#agentsecurity #mcp #sql
Comments
4 min read
Six Rows Deleted. Three Decrements Applied. No Error.
mahmut_gndzalp_c736ac4b profile

Six Rows Deleted. Three Decrements Applied. No Error.

#mysql #sql #database #webdev
Comments
6 min read
OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost
hidetzu profile

OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost

#postgres #sql #performance #database
Comments
6 min read
Adhiya Meets Athena: Exploring Amazon Athena 🔍☁️
adhiya_r_002cf5cfd90c17b7 profile

Adhiya Meets Athena: Exploring Amazon Athena 🔍☁️

#aws #cloud #serverless #sql
Comments
6 min read
SQL Window Functions Made Simple
alex_murithi profile

SQL Window Functions Made Simple

#sql #database #datascience
Comments
3 min read
SCD Type-2 Without the Duplicate-Current-Row Footgun
vaishnavprabhu profile

SCD Type-2 Without the Duplicate-Current-Row Footgun

#dataengineering #sql #database #analytics
Comments 1
2 min read
Ananthika Unlocks Athena: SQL Wisdom Without a Single Server ⚡
ananthikaa4 profile

Ananthika Unlocks Athena: SQL Wisdom Without a Single Server ⚡

#aws #database #serverless #sql
Comments
5 min read
Army vs jOOQ
zoro7 profile

Army vs jOOQ

#database #java #opensource #sql
Comments
10 min read
5 Things AI Cannot Do at PostgreSQL
devunionx profile

5 Things AI Cannot Do at PostgreSQL

#postgressql #sql #sqlserver #ai
6
Comments
5 min read
A for Athena
amutha_nila profile

A for Athena

#aws #cloud #learning #sql
Comments
6 min read
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
Excel Turned a 20% Discount Into 19.999999999999998%. That Hid $2,325.
keenenwilkins profile

Excel Turned a 20% Discount Into 19.999999999999998%. That Hid $2,325.

#sql #beginners #career #excel
Comments 1
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.