Understanding: 30 | Knowledge Hub

👋 Sign in for the ability to sort posts by relevant, latest, or top.

sharefun2023

Sep 29

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

#sql #database #postgres #mysql

4 min read

sharefun2023

Sep 29

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

#sql #database #postgres #mysql

3 min read

lupingQAQ

Sep 29

SqlStealthRogue: a zero-probe SQL and NoSQL data dumper

#database #python #security #sql

2 min read

David Mwandairo

Sep 29

Cleaning and Analyzing Tembo Hotel's Bookings

#showdev #postgres #sql #dataanalysis

27 min read

Judy

Sep 29

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

#ai #programming #devops #sql

2 min read

duchu.nft

Sep 29

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

#security #sql #bugbounty

3 min read

InstaWebhook

Sep 29

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

#database #performance #sql

22 min read

Alexey Makhotkin

Sep 29

Database Modeling of a Music Marketplace. Part 1

#database #tutorial #sql

8 min read

DataDriven

Oct 22

SQL Ties Python at 58%: What It Means for Data Engineer Interviews

#dataengineering #sql #interview #career

8 min read

Zayd Mulani

Sep 28

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

#rust #sql #database #opensource

4 min read

Nikhil raman K

Sep 28

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

#ai #sql #bigdata #cloud

10 min read

Ian munene

Sep 28

SQL Joins Explained in Detail

#sql #joins

4 min read

Anshuman Pattnaik

Oct 21

What Building an LLM-Offloaded Query Layer Taught Me

#backend #database #llm #sql

16 min read

Jennifer Evangelista

Oct 24

Three Orders In, Three Rows Out, 42.9% More Revenue

#sql #dataengineering #databricks

5 min read

Brian Mugo

Oct 21

Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

#sql #postgres #dataengineering #database

9 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.

DEV Community

select * from SQL

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

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

SqlStealthRogue: a zero-probe SQL and NoSQL data dumper

Cleaning and Analyzing Tembo Hotel's Bookings

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

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

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

Database Modeling of a Music Marketplace. Part 1

SQL Ties Python at 58%: What It Means for Data Engineer Interviews

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

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

SQL Joins Explained in Detail

What Building an LLM-Offloaded Query Layer Taught Me

Three Orders In, Three Rows Out, 42.9% More Revenue

Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.