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 Joins: How to Combine Tables the Right Way
patrickomondi profile

# SQL Joins: How to Combine Tables the Right Way

#backend #database #sql #tutorial
Comments
3 min read
# Subqueries & CTEs: Two Ways to Query Inside a Query
patrickomondi profile

# Subqueries & CTEs: Two Ways to Query Inside a Query

#sql #datascience #cte #subquery
Comments
3 min read
PostgreSQL vs MySQL: 7 syntax differences that break migrations
sharefun2023 profile

PostgreSQL vs MySQL: 7 syntax differences that break migrations

#postgres #mysql #database #sql
Comments
4 min read
# DDL, DML, DCL & TCL: SQL's Building Blocks in Plain English
patrickomondi profile

# DDL, DML, DCL & TCL: SQL's Building Blocks in Plain English

#sql #ddl #dml #dcl
Comments
4 min read
How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit
caiderek profile

How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit

#backend #database #sql #tools
1
Comments
3 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N
sharefun2023 profile

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

#sql #database #postgres #mysql
Comments
4 min read
The NOT IN trap: why your SQL query returns zero rows
sharefun2023 profile

The NOT IN trap: why your SQL query returns zero rows

#sql #database #postgres #mysql
Comments
3 min read
Your AI SQL Tool Doesn’t Have an “Undo Logic” Button – That’s the Real Problem
esproc_spl profile
Judy

Your AI SQL Tool Doesn’t Have an “Undo Logic” Button – That’s the Real Problem

#ai #programming #devops #sql
5
Comments
2 min read
How a Fox and a Single Quote Broke the Critter Gallery — SQLi in Intigriti Challenge 0926
duchuaz profile

How a Fox and a Single Quote Broke the Critter Gallery — SQLi in Intigriti Challenge 0926

#security #sql #bugbounty
1
Comments
3 min read
Storing Billions of Webhook Audit Logs in PostgreSQL: Partitioning, Indexing, Compression, and Retention
instawebhook profile

Storing Billions of Webhook Audit Logs in PostgreSQL: Partitioning, Indexing, Compression, and Retention

#database #performance #sql
1
Comments 1
22 min read
Database Modeling of a Music Marketplace. Part 1
databasedesignbook profile

Database Modeling of a Music Marketplace. Part 1

#database #tutorial #sql
1
Comments 1
8 min read
How I stream row changes out of SQLite without touching the app (reading the WAL)
zaydmulani09 profile

How I stream row changes out of SQLite without touching the app (reading the WAL)

#rust #sql #database #opensource
Comments
4 min read
I couldn't touch the database, so I built search next to it
_er2es_ profile
Szj

I couldn't touch the database, so I built search next to it

#sql #symfony #fuzzy #postgres
Comments 1
9 min read
No more messy f-strings: Type-safe fluent SQL for ClickHouse.
william_rodriguez_65a5898 profile

No more messy f-strings: Type-safe fluent SQL for ClickHouse.

#sql
Comments
1 min read
Snowflake Semantic Views: A Hands-On Three-Table Tutorial
fabian_stadler profile

Snowflake Semantic Views: A Hands-On Three-Table Tutorial

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