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.
No More Rewriting the Same Logic for Every Database
esproc_spl profile
Judy

No More Rewriting the Same Logic for Every Database

#programming #devops #sql #sqlazy
5
Comments
4 min read
PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns
ineron profile
Eugene

PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns

#postgres #sql #backend #ai
Comments
2 min read
CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)
guidance_white profile

CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)

#database #vulnerabilities #cve #sql
1
Comments
6 min read
Four traps in querying 1.79M Overture Maps records with DuckDB
azorkai profile

Four traps in querying 1.79M Overture Maps records with DuckDB

#duckdb #sql #opendata #dotnet
Comments
4 min read
Paginating hybrid search on Postgres, and why the obvious fix is worse
pavangupta352 profile

Paginating hybrid search on Postgres, and why the obvious fix is worse

#postgres #sql #database #search
Comments
4 min read
Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)
arpitmbangre profile

Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)

#sql #database #dataengineering #career
Comments
2 min read
Temp Table vs View in SQL: A Saved Answer or a Saved Question
michaelnocito profile

Temp Table vs View in SQL: A Saved Answer or a Saved Question

#sql #database #tutorial #beginners
Comments
13 min read
How to Reconcile Two Tables in SQL When the Row Counts Match
michaelnocito profile

How to Reconcile Two Tables in SQL When the Row Counts Match

#sql #database #tutorial #beginners
1
Comments
14 min read
Subquery vs CTE in SQL: Same Logic, One You Can Check
michaelnocito profile

Subquery vs CTE in SQL: Same Logic, One You Can Check

#sql #database #tutorial #beginners
Comments
14 min read
Running Total in SQL: The Window Frame That Decides the Answer
michaelnocito profile

Running Total in SQL: The Window Frame That Decides the Answer

#sql #database #tutorial #beginners
Comments
14 min read
dbt Was Not Designed for Multi-Tenant SaaS. Here's How I Made It Work.
eu_ti_f127c5b5d7535b7174f profile

dbt Was Not Designed for Multi-Tenant SaaS. Here's How I Made It Work.

#dataengineering #sql #python #architecture
Comments
4 min read
Sampling rate is a correctness property, not a performance knob
edycutjong profile

Sampling rate is a correctness property, not a performance knob

#showdev #python #sql #ai
1
Comments
5 min read
Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph
ineron profile

Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph

#database #postgres #sql
Comments
3 min read
Turn any SQL schema into an interactive ER diagram
patu profile
Patu

Turn any SQL schema into an interactive ER diagram

#sql #database #postgres #tools
Comments
2 min read
How Express Actually Talks to a Database: From HTTP Request to SQL Query
surajsrggupta profile

How Express Actually Talks to a Database: From HTTP Request to SQL Query

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