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.
How to Find Duplicate Rows in SQL (and Decide What Counts as One)
michaelnocito profile

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

#sql #database #tutorial #beginners
Comments
15 min read
NULL in SQL: Why = NULL Finds Nothing and What to Write Instead
michaelnocito profile

NULL in SQL: Why = NULL Finds Nothing and What to Write Instead

#sql #database #tutorial #beginners
Comments
14 min read
DDL and DML WHAT ARE THEY?
super_b8c82b4153dee9fab1c profile

DDL and DML WHAT ARE THEY?

#beginners #database #sql #tutorial
Comments
1 min read
ersioning Business Semantics for Enterprise AI
arisyndata profile

ersioning Business Semantics for Enterprise AI

#ai #llm #data #sql
Comments 1
7 min read
Why I Stopped Rushing to Machine Learning and Started with SQL Instead!
shreyas_s_cf15e23eb1cbcbc profile

Why I Stopped Rushing to Machine Learning and Started with SQL Instead!

#datascience #learning #machinelearning #sql
1
Comments
2 min read
Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.
nunc profile
Nunc

Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.

#showdev #ai #oracle #sql
Comments
5 min read
My alert fired 7 times across 1963 pairs. I assumed the thresholds were too high. They were, and it didn't matter
juanauriti profile

My alert fired 7 times across 1963 pairs. I assumed the thresholds were too high. They were, and it didn't matter

#monitoring #database #sql #webdev
3
Comments
4 min read
Window functions vs Aggregate functions
mark_glemba_962f6bc8a12dd profile

Window functions vs Aggregate functions

#analytics #database #datascience #sql
Comments
9 min read
Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration
tbson87 profile

Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration

#database #documentation #sql #postgres
Comments 1
7 min read
MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]
make-wp-fast profile

MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]

#database #performance #sql #wordpress
Comments
10 min read
Recursive CTEs: How SQL Secretly Learned to Loop
rahmanfrr profile

Recursive CTEs: How SQL Secretly Learned to Loop

#sql #database #programming #tutorial
Comments 3
3 min read
Text-to-SQL in Practice: When to Trust AI Output and When to Gate It
databaseinsights profile

Text-to-SQL in Practice: When to Trust AI Output and When to Gate It

#sql #ai #database #devops
3
Comments 1
4 min read
We caught a SQL injection with an offline AI security scanner — here's the exact query it found
jomynn profile

We caught a SQL injection with an offline AI security scanner — here's the exact query it found

#ai #javascript #security #sql
Comments 1
3 min read
Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs
hafsa_motiwala profile

Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs

#showdev #datascience #database #sql
1
Comments
4 min read
Is Supabase Actually a Database?
surajsrggupta profile

Is Supabase Actually a Database?

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