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.
Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js

Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js

Comments
7 min read
SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD

SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD

Comments
4 min read
Oracle ORA-00060 오류 원인과 해결 방법 완벽 가이드

Oracle ORA-00060 오류 원인과 해결 방법 완벽 가이드

Comments
3 min read
PostgreSQL 08006 오류 원인과 해결 방법 완벽 가이드

PostgreSQL 08006 오류 원인과 해결 방법 완벽 가이드

Comments
2 min read
PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드

PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드

Comments
2 min read
Oracle ORA-00057 오류 원인과 해결 방법 완벽 가이드

Oracle ORA-00057 오류 원인과 해결 방법 완벽 가이드

Comments
3 min read
MP3 - SQLi, XSS, and CSRF WriteUp

MP3 - SQLi, XSS, and CSRF WriteUp

Comments
7 min read
SQL Pattern Series #1: The Presence Pattern

SQL Pattern Series #1: The Presence Pattern

Comments
3 min read
SQL for Developers: The Practical Guide (2026)

SQL for Developers: The Practical Guide (2026)

Comments
6 min read
Oracle ORA-00055 오류 원인과 해결 방법 완벽 가이드

Oracle ORA-00055 오류 원인과 해결 방법 완벽 가이드

Comments
3 min read
Quack-Mate: a chess engine in SQL

Quack-Mate: a chess engine in SQL

Comments
4 min read
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning

DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning

Comments
3 min read
Part 08: Designing Tables, Data Types and Constraints

Part 08: Designing Tables, Data Types and Constraints

Comments 1
5 min read
I Didn't Want to Open Excel Just to Generate Sequential Numbers in VS Code

I Didn't Want to Open Excel Just to Generate Sequential Numbers in VS Code

Comments
2 min read
PostgreSQL 08000 오류 원인과 해결 방법 완벽 가이드

PostgreSQL 08000 오류 원인과 해결 방법 완벽 가이드

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