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.
SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle
michaelnocito profile

SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle

#sql #database #tutorial #beginners
Comments
5 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
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
Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps
michaelnocito profile

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

#sql #database #tutorial #beginners
Comments
15 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
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
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
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
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
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
Is Supabase Actually a Database?
surajsrggupta profile

Is Supabase Actually a Database?

#sql #supabase #appwritehack #webdev
Comments
5 min read
MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade
dkelxldk profile

MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

#database #debugging #sql
Comments 2
2 min read
Building my first database with SQL: a library project
derick_lopes_c748a3f163e7 profile

Building my first database with SQL: a library project

#sql #computerscience
Comments
5 min read
Real-World Data Engineering on Snowflake: Architectural Patterns and DEA-C01 Insights
lucasitpro profile

Real-World Data Engineering on Snowflake: Architectural Patterns and DEA-C01 Insights

#snowflake #dataengineering #sql #cloud
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.