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.
Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras
sangeetha_kalia_cb89c90aa profile

Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

#architecture #database #postgres #sql
Comments
17 min read
Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained
interviewshow-cs profile

Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

#career #coding #interview #sql
Comments
4 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes
sanikolaev profile

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

#backend #database #search #sql
Comments
3 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
How to write a cohort retention query in SQL (that actually runs)
sofrito profile

How to write a cohort retention query in SQL (that actually runs)

#sql #analytics #database #datascience
Comments
3 min read
Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7
soytuber profile
soy

Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7

#database #sql #sqlite #opensource
Comments
4 min read
ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs
tbson87 profile

ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs

#database #sql #mysql #postgres
Comments
10 min read
Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics
alexcrazy74 profile

Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics

#ai #sql #programming #rdbms
Comments 1
4 min read
Tracking Tableau Server Storage Over Time with PostgreSQL
jungalung profile

Tracking Tableau Server Storage Over Time with PostgreSQL

#postgres #sql #tableau #datavisualiszation
Comments
2 min read
That VARCHAR(255) Was Never a Decision. It Was a Default.
speccoding profile

That VARCHAR(255) Was Never a Decision. It Was a Default.

#database #sql #postgres #programming
Comments 1
4 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles
kostyabartashevich profile

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles

#azure #database #sql #architecture
Comments
5 min read
Solon Data SQL: Three Layers of Data Access Without the Bloat
solonjava profile

Solon Data SQL: Three Layers of Data Access Without the Bloat

#architecture #database #java #sql
Comments 3
5 min read
Why schema drift goes undetected
eggletric profile

Why schema drift goes undetected

#database #postgres #devops #sql
Comments 2
7 min read
Data Types and So much more
jomiedu profile

Data Types and So much more

#backend #database #sql
Comments
2 min read
Top N per group is the query `LIMIT` can't write
omer_hochman profile

Top N per group is the query `LIMIT` can't write

#sql #database #webdev
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.