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.
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
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
SqlStealthRogue: a zero-probe SQL and NoSQL data dumper
lupingqaq profile

SqlStealthRogue: a zero-probe SQL and NoSQL data dumper

#database #python #security #sql
Comments
2 min read
Cleaning and Analyzing Tembo Hotel's Bookings
david_mwandairo profile

Cleaning and Analyzing Tembo Hotel's Bookings

#showdev #postgres #sql #dataanalysis
2
Comments
27 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
The Semantic Compression Problem: Engineering AI-Ready Views for Complex SQL
nikhil_ramank_152ca48266 profile

The Semantic Compression Problem: Engineering AI-Ready Views for Complex SQL

#ai #sql #bigdata #cloud
Comments 1
10 min read
SQL Joins Explained in Detail
ian_munene profile

SQL Joins Explained in Detail

#sql #joins
Comments
4 min read
I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.
sanjay_mehta_7618b5db60df profile

I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

#database #debugging #postgres #sql
1
Comments 1
5 min read
SQL for Frontend Engineers: Model the Relationship First
maximusft profile

SQL for Frontend Engineers: Model the Relationship First

#fullstack #sql #postgres #database
Comments
6 min read
PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column
tbson87 profile

PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

#postgres #database #sql #performance
Comments
10 min read
Oracle SQL: Essential Environment Commands
sandeep-dos profile

Oracle SQL: Essential Environment Commands

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