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 Injection – UNION attack, retrieving data from other tables | PortSwigger Lab Note #4

SQL Injection – UNION attack, retrieving data from other tables | PortSwigger Lab Note #4

5
Comments
1 min read
AI-powered PostgreSQL observability

AI-powered PostgreSQL observability

Comments
1 min read
A Beginner's Guide to SQL Joins and Window Functions

A Beginner's Guide to SQL Joins and Window Functions

1
Comments
6 min read
PostgreSQL Query Optimization: 10 Techniques That Actually Work

PostgreSQL Query Optimization: 10 Techniques That Actually Work

1
Comments
12 min read
I Thought My Rails Query Was Fine — Until NULL Ate My Data

I Thought My Rails Query Was Fine — Until NULL Ate My Data

4
Comments
2 min read
Rule Engines

Rule Engines

2
Comments 1
3 min read
I Built a Database That Never Forgets — Here's Why

I Built a Database That Never Forgets — Here's Why

1
Comments
14 min read
A Evolução do Modelo Relacional para Objeto-Relacional

A Evolução do Modelo Relacional para Objeto-Relacional

1
Comments
4 min read
PostgreSQL vs MySQL: Database Selection Guide for Developers (2026)

PostgreSQL vs MySQL: Database Selection Guide for Developers (2026)

1
Comments
15 min read
Atomicity

Atomicity

Comments
1 min read
Artigo sobre A Evolução do Modelo Relacional para Objeto-Relacional.

Artigo sobre A Evolução do Modelo Relacional para Objeto-Relacional.

1
Comments
6 min read
A EVOLUÇÃO DOS BANCOS DE DADOS: DO MODELO RELACIONAL CLÁSSICO À ARQUITETURA OBJETO-RELACIONAL

A EVOLUÇÃO DOS BANCOS DE DADOS: DO MODELO RELACIONAL CLÁSSICO À ARQUITETURA OBJETO-RELACIONAL

1
Comments
7 min read
SQL Injection – Login Bypass | PortSwigger Lab Note #2

SQL Injection – Login Bypass | PortSwigger Lab Note #2

7
Comments
1 min read
Getting Started With Caching in Ruby on Rails

Getting Started With Caching in Ruby on Rails

3
Comments
7 min read
PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.